phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mujtaba Chohan <mujt...@apache.org>
Subject Re: Export large query results to CSV
Date Mon, 15 May 2017 17:25:17 GMT
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-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.
>>
>

Mime
View raw message