topic Re: Getting error while running a pipeline in Pipelines

Getting error while running a pipeline

jashfabric — Wed, 13 Mar 2024 07:48:24 GMT

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.

Re: Getting error while running a pipeline

Anonymous — Wed, 13 Mar 2024 07:58:01 GMT

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.

Re: Getting error while running a pipeline

jashfabric — Wed, 13 Mar 2024 12:58:24 GMT

That helped a lot Anonymous
Thanks for the help.

Re: Getting error while running a pipeline

Anonymous — Wed, 13 Mar 2024 13:06:37 GMT

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