Thanks Pariksheet.
On Wed, Feb 25, 2015 at 1:35 PM, Pariksheet Barapatre pbarapa...@gmail.com
wrote:
Hi Dhaval,
You can use below code -
$SQLLINE $ZKEEPER END
!outputformat csv
!record $TMP_FILE
select * from system.catalog limit 10;
!record
!quit
END
## $SQLINE is sqlline.py path ,
Is there any SQL statement which can enable me to save query results as CSV
file on a local file system / hdfs ?
Thanks,
Dhaval
Thanks Vamsi.
On Tue, Feb 24, 2015 at 5:02 PM, Vamsi Krishna vamsi.attl...@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