Search code examples
hadoophbaseapache-phoenixambari

Phoenix Exporting CSV File

I’m quite new to HBase and Phoenix. I’m trying to export some data to a csv file. Tried this and seems to work.

!outputformat csv
!record /data.csv
select * from “data”;
!record

My question is where did this csv file export to? I did not get any errors exporting the query above, but I can not seem to find the file itself.

Solution

  • Probably your data.csv file has been generated in root directory of your machine, since your file starts with /. Normally, path prefix would be the location where you started the phoenix-sqlline shell. (And actually path is logged in sqlline just before starting to record)

    For example:

    
## Started sqlline in /tmp/alicana directory

0: jdbc:phoenix:> !record data.csv
Saving all output to "/tmp/alicana/data.csv". Enter "record" with no arguments to stop it.

0: jdbc:phoenix:> !record ../alicana-data.csv
Saving all output to "/tmp/alicana/../alicana-data.csv". Enter "record" with no arguments to stop it.

## When sqlline started in (~) user home 
0: jdbc:phoenix:> !record data.csv
Saving all output to "/home/alicana/data.csv". Enter "record" with no arguments to stop it.

## Official sqlline documentation
0: jdbc:oracle:thin:@localhost:1521:mydb> !record /tmp/mysession.out
Saving all output to "/tmp/mysession.out". Enter "record" with no arguments to stop it.