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 <els...@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-lis >> t.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. >> >
