Forum Discussion

poojitha_yeluru's avatar
poojitha_yeluru
Advocate I
2 years ago
Solved

An error occurred while calling o321.sql.

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.
 

Lakehouse
Notebook
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

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

  • arlindTrystar's avatar
    arlindTrystar
    Advocate I
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      arlindTrystar
      Advocate I
      2 years ago

      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.