phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vamsi Krishna <vamsi.attl...@gmail.com>
Subject Re: SQL to export query result in a CSV file ?
Date Tue, 24 Feb 2015 22:02:42 GMT
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