Exporting query results

[Deenar Toraskar]

Hi guys

First of all congratulations on developing a great analytical front end for Hive/Shark. I want to use it as a web based frontend to our Shark and Spark cluster which the end users can use. I haven't found a way of exporting query results to a CSV or text file in Zeppelin. A very common use case is to export results to CSV and then analyse them further in excel. Is this something that can be achieved using Zeppelin?

Deenar

[Alex B]

Hey Deenar,

glad to hear you find it useful! 

Regarding your question: from the web ui right now there is no existing way you can export results to csv but this sounds a really reasonable feature request so i'v created issue https://zeppelin-project.atlassian.net/browse/ZEPPELIN-133 

Please feel free to contribute, this should not be hard to add as JSON data is already available on frontend in ie in this (default) visualization library in a form of google.visualization.Table.

As a workaround it's quite easy to save results of any query you need to a table created beforehand in the same job with smth like "ROW FORMAT DELIMITED FIELDS TERMINATED BY ','" 

--
You received this message because you are subscribed to the Google Groups "zeppelin-developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to zeppelin-develo...@googlegroups.com.
To post to this group, send email to zeppelin-...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

--

Kind regards,

Alexander.

[moon soo Lee]

Be aware, visualization library only display data less than 'zeppelin.max.result' (default 10000).

[Deenar Toraskar]

Hi

I have found a handy code snippet that converts a google.visualization.DataTable to CSV. I am going to try using this to provide a CSV export facility.

Deenar

On Friday, June 27, 2014 8:09:58 AM UTC+1, moon soo Lee wrote:

Be aware, visualization library only display data less than 'zeppelin.max.result' (default 10000).

On Fri, Jun 27, 2014 at 3:49 PM, Alex B <abez...@nflabs.com> wrote:

Hey Deenar,

glad to hear you find it useful! 

Regarding your question: from the web ui right now there is no existing way you can export results to csv but this sounds a really reasonable feature request so i'v created issue https://zeppelin-project.atlassian.net/browse/ZEPPELIN-133 

Please feel free to contribute, this should not be hard to add as JSON data is already available on frontend in ie in this (default) visualization library in a form of google.visualization.Table.

As a workaround it's quite easy to save results of any query you need to a table created beforehand in the same job with smth like "ROW FORMAT DELIMITED FIELDS TERMINATED BY ','" 

On Fri, Jun 27, 2014 at 12:36 AM, Deenar Toraskar <deenar....@gmail.com> wrote:

Hi guys

First of all congratulations on developing a great analytical front end for Hive/Shark. I want to use it as a web based frontend to our Shark and Spark cluster which the end users can use. I haven't found a way of exporting query results to a CSV or text file in Zeppelin. A very common use case is to export results to CSV and then analyse them further in excel. Is this something that can be achieved using Zeppelin?

Deenar

--
You received this message because you are subscribed to the Google Groups "zeppelin-developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to zeppelin-developers+unsub...@googlegroups.com.

To post to this group, send email to zeppelin-...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

--

Kind regards,

Alexander.

--
You received this message because you are subscribed to the Google Groups "zeppelin-developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to zeppelin-developers+unsub...@googlegroups.com.