Re: Export large query results to CSV

2017-05-15 Thread cmbendre
Thank you for the info. I am open to writing code or contributing to the project if this feature is missing. Let me create an issue for this. -- View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Export-large-query-results-to-CSV-tp3530p3537.html Sent from

Re: Export large query results to CSV

2017-05-15 Thread Mujtaba Chohan
You might be able to use sqlline to export. Use !outputformat csv and !record commands to export as CSV locally. On Sun, May 14, 2017 at 8:22 PM, Josh Elser wrote: > I am not aware of any mechanisms in Phoenix that will automatically write > formatted data, locally or

Re: Export large query results to CSV

2017-05-14 Thread Josh Elser
I am not aware of any mechanisms in Phoenix that will automatically write formatted data, locally or remotely. This will require you to write some code. cmbendre wrote: Hi, Some of our queries on Phoenix cluster gives millions of rows as a result. How do i export these results to a csv file