Re: Export large query results to CSV
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 the Apache Phoenix User List mailing list archive at Nabble.com.
Re: Export large query results to CSV
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. >> >
Re: Export large query results to CSV
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.
Export large query results to CSV
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.