An error occurred while calling o321.sql.

[poojitha_yeluru]

I have written the above code when iam running the code , Iam getting below error.

And also I have checked by restarting the kernal , getting the same error, and also I check the below code
spark.sql('''CREATE TABLE STUDENT(ID INT,NAME VARCHAR(20))'''), get the same above error,Can you help why Iam getting the error.
 

[v-cgao-msft · Accepted solution]

Hi all,

Please try add the following code to the top of notebook as the first cell. 

%%pyspark 
!echo "spark.trident.pbiApiVersion=v1">>/home/trusted-service-user/.trident-context

After testing this works for me.

This is a known issue and the Product group is working on deploying a fix.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[fedezimm]

I have run the same code in a cell but I'm still getting the error. 

[fedezimm]

I'm having the same issue, the error is intermitent, same code cell sometimes run well and sometimes failed. Please let me know if you have a resolution. This error started showing up when we change capacity from 2 to 4. Has this something to do with it?

[poojitha_yeluru]

Hi @v-cgao-msft , Yes I hve enabled the Lakehouse Schema feature.

[v-cgao-msft]

Hi all,

I have elevated this matter to the product group for further attention. I will provide an update in this thread as soon as I have new information.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[arlindTrystar]

Any updates?

[v-cgao-msft]

Hi @poojitha_yeluru ,

Did you enable the Lakeshouse schema feature when you created Lakehouse?

I reproduced the same error.

For Lakehouse without this feature enabled, it has been tested to work fine:

Can you help me to confirm the above? Thks.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[arlindTrystar]

I can confirm as well that reading/writing from Lakehouses without schema enabled works. The issue is with Lakehouses that have schema enabled. Why is this? Any resolution to this?

We did not have this issue up until now, even in the schema enabled Lakehouses.

[arlindTrystar]

any resolution? The same is happening for me, and I'm sure we did not change any permissions or something like that