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 <elserj@apache.org> wrote:
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 or s3 location ?

The query output size is approximately in range of GBs

Thanks,
Chaitanya



--
View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Export-large-query-results-to-CSV-tp3530.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.