topic Re: An error occurred while calling o321.sql. in Data Engineering

An error occurred while calling o321.sql.

poojitha_yeluru — Fri, 09 Aug 2024 06:20:15 GMT

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.

Re: An error occurred while calling o321.sql.

arlindTrystar — Fri, 09 Aug 2024 07:29:06 GMT

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

Re: An error occurred while calling o321.sql.

Anonymous — Fri, 09 Aug 2024 08:06:56 GMT

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

Re: An error occurred while calling o321.sql.

poojitha_yeluru — Fri, 09 Aug 2024 08:12:22 GMT

Hi @Anonymous , Yes I hve enabled the Lakehouse Schema feature.

Re: An error occurred while calling o321.sql.

arlindTrystar — Fri, 09 Aug 2024 08:30:57 GMT

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.

Re: An error occurred while calling o321.sql.

Anonymous — Fri, 09 Aug 2024 09:22:00 GMT

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

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

Re: An error occurred while calling o321.sql.

arlindTrystar — Wed, 14 Aug 2024 06:58:53 GMT

Any updates?

Re: An error occurred while calling o321.sql.

Anonymous — Fri, 23 Aug 2024 20:21:32 GMT

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?

Re: An error occurred while calling o321.sql.

Anonymous — Tue, 03 Sep 2024 08:49:53 GMT

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

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

Re: An error occurred while calling o321.sql.

Anonymous — Wed, 04 Sep 2024 15:14:30 GMT

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