expand groovy magic to the other languages

[scottdraves]

in addition to %%groovy we should have %%java, %%scala, etc.

[dclong]

Do we have a %%sql magic?

[scottdraves]

Yes in 0.16.0

[dclong]

I found a notebook doc/python/KernelMagics.ipynb documenting the use of the %%sql magic in Python. Is it possible to assign the results to a Python variable?

[scottdraves]

yes, no, yes. see the last example of https://github.com/twosigma/beakerx/blob/master/doc/python/KernelMagics.ipynb

…

On Tue, May 1, 2018 at 11:24 AM Ben Chuanlong Du ***@***.***> wrote: Can it be used in ipykernel? Do I need to import the magic as an extension? Is there an example of using it? — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#7130 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA6yFeS61Ph6k1VWUhYby3x1VC9TPwiiks5tuHnKgaJpZM4TLS0s> .

-- BeakerX.com ScottDraves.com <http://www.ScottDraves.com> @Scott_Draves <http://twitter.com/scott_draves>

[dclong]

1. It seems that the magic %classpath is not supported in the Python kernel currently. This limits the use usage of JVM kernels. For example, I cannot get connected to Teradata SQL using the magic %%sql as Jar files from Teradata cannot be included using %classpath.

2. How can the results of the magic %%sql be accessed in Python?

[scottdraves]

1. It should work, just put it inside, like this:

%%sql
%classpath add jar ....

2. It's on the agenda, see provide two-way autotranslation #5039

[dclong]

I've just verified that 1. works following your example. Thank you very much!