phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Rami <dhavalr...@gmail.com>
Subject Re: SQL to export query result in a CSV file ?
Date Wed, 25 Feb 2015 03:16:22 GMT
Thanks Vamsi.

On Tue, Feb 24, 2015 at 5:02 PM, Vamsi Krishna <vamsi.attluri@gmail.com>
wrote:

> Using 'record' & 'outputformat' commands of sqlline.py you can save data
> to csv file.
>
> After connecting to cluster using sqlline.py execute the following
> commands:
> 1. !outputformat csv
> 2. !record data.csv
> 3. select * from system.catalog limit 10;
> 4. !record
> 5. !quit
>
> You should see data.csv file with 10 records from system.catalog table
> saved in the folder from which you executed sqlline.py.
>
> Thanks,
> Vamsi Attluri.
>
> On Tue, Feb 24, 2015 at 1:32 PM, Dhaval Rami <dhavalrami@gmail.com> wrote:
>
>> Is there any SQL statement which can enable me to save query results as
>> CSV file on a local file system / hdfs ?
>>
>> Thanks,
>> Dhaval
>>
>
>

Mime
View raw message