[
https://issues.apache.org/jira/browse/TOREE-534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ricardo Gaspar updated TOREE-534:
---------------------------------
Fix Version/s: 0.4.0
(was: 0.1.0)
Description:
Would it be possible to render as table (HTML like) as the dataframe magic
(%%dataframe) shows the results?
Based on the documentation examples:
[https://github.com/apache/incubator-toree/blob/5b19aac2e56a56d35c888acc4ed5e549b1f4ed7c/etc/examples/notebooks/magic-tutorial.ipynb]
Instead of rendering as plaintext when using %%sql , it would be better to be
able to render it as a table.
Currently the only way to achieve this is with a 2 step process (2 cells):
# creating a dataframe with the SQL query
# and then render it using the %%dataframe to render it.
Zeppelin does this by default when using the %sql annotation. But Zeppelin is
not as good as Jupyter.
Additionally, %%SQL magic doesn't allow to control the limit of rows to show,
always defaults to 10.
was:
First execution of a %%SQL cell works fine. The second one prints the error
```
Magic sql failed to execute with error:
spark.sql.execution.id is already set
```
Might be related to https://issues.apache.org/jira/browse/SPARK-10548
Issue Type: Improvement (was: Bug)
Priority: Trivial (was: Critical)
> SQL magic - Render as table like dataframe magic
> ------------------------------------------------
>
> Key: TOREE-534
> URL: https://issues.apache.org/jira/browse/TOREE-534
> Project: TOREE
> Issue Type: Improvement
> Reporter: Ricardo Gaspar
> Priority: Trivial
> Fix For: 0.4.0
>
>
> Would it be possible to render as table (HTML like) as the dataframe magic
> (%%dataframe) shows the results?
> Based on the documentation examples:
> [https://github.com/apache/incubator-toree/blob/5b19aac2e56a56d35c888acc4ed5e549b1f4ed7c/etc/examples/notebooks/magic-tutorial.ipynb]
> Instead of rendering as plaintext when using %%sql , it would be better to be
> able to render it as a table.
> Currently the only way to achieve this is with a 2 step process (2 cells):
> # creating a dataframe with the SQL query
> # and then render it using the %%dataframe to render it.
>
> Zeppelin does this by default when using the %sql annotation. But Zeppelin is
> not as good as Jupyter.
>
> Additionally, %%SQL magic doesn't allow to control the limit of rows to show,
> always defaults to 10.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
