Forum Discussion

jashfabric's avatar
jashfabric
Helper II
2 years ago
Solved

Getting error while running a pipeline

Hi,
I am new to Fabric and doing the exercise https://learn.microsoft.com/en-us/training/modules/use-data-factory-pipelines-fabric/.
Everything runs fine. But in the Modify Pipeline (https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/04-ingest-pipeline.html#modify-the-pipeline) step I am facing an error:

Operation on target 'Sample notebook' failed: Notebook execution encountered an error at the Notebook service with HTTP status code - '200'. Please review the Run logs on the Notebook for additional details. Error details: 'Error name - AnalysisException, Error value - org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message: Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)

I have been trying to fix this from long but not able to succeed. Appreciate your help.

Need Help
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jashfabric 
    Thanks for using Fabric Community.
    Can you please follow the below steps and retry:

    At the leftside of the notebook please click on lakehouses.


    Click on Add lakehouse.

     



    Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

     



    Now try to run the pipeline. 

    You can also try this:
    Navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

     


    Hope this helps. Please let me know if you have any further questions.


  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jashfabric 
    Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jashfabric 
    Thanks for using Fabric Community.
    Can you please follow the below steps and retry:

    At the leftside of the notebook please click on lakehouses.


    Click on Add lakehouse.

     



    Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

     



    Now try to run the pipeline. 

    You can also try this:
    Navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

     


    Hope this helps. Please let me know if you have any further questions.


      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi jashfabric 
        Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.