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 remotely. This will require you to write some code.

cmbendre wrote:

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


View this message in context:
Sent from the Apache Phoenix User List mailing list archive at