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 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 <dhavalr...@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 >> > >
