I am creating the Notebook in Jupyter where I have created the data frame(using python kernel-pyspark), from data frame I created temp view(df.createOrReplaceTempView(“df_table”)). Then in new cell I am using %%sql magic command however it is getting failed with below error message.
I have installed
ipython-sql, but still getting error. But this works in Databricks community edition notebook.
Please help on this.
In new cell:
%%sql select * from df_table **ERROR:** UsageError: Cell magic `%%sql` not found