Support Questions
Find answers, ask questions, and share your expertise

Exporting a phoenix table into a csvfile

Exporting a phoenix table into a csvfile

Is there a way to export a phoenix table into a csv file using the phoenix pherf ulitly. If so can anyone provide the details. I couldnt get the proper documetnation for this. we are supposed to export around 26 million rows into csv file.

11 REPLIES 11

Re: Exporting a phoenix table into a csvfile

Phoenix pherf utility exports details like how much time the query took etc..not the data. There is no way to export data into csv from Phoenix. Can't you use Export utility provided by HBase.

Re: Exporting a phoenix table into a csvfile

Better to go with @Ankit Singhal suggestion of using pig/hive or spark to export.

Re: Exporting a phoenix table into a csvfile

hi @Rajeshbabu Chintaguntla, the export utility provided by hbase generates sequence files i guess. how to convert them into csv files.

I tried the pig export, but the datatypes are not mapped.

i used a query similar to this

A = load 'hbase://query/select * from TRANSACTION' using org.apache.phoenix.pig.PhoenixHBaseLoader('localhost');

Should i need to explicitly specify the schema and if so how to do that.

Re: Exporting a phoenix table into a csvfile

Yes Export generate sequence files. If you want to import back the exported data to other HBase table in different cluster then you can use it other wise it won't help.

Pig should map the data types properly. Can you try specifying the columns list than * and check. For eg:

A = load 'hbase://query/select col1,col2.. from TRANSACTION' using org.apache.phoenix.pig.PhoenixHBaseLoader('localhost');

Re: Exporting a phoenix table into a csvfile

@ARUN

Or else can you try something similar to type convertion.

A = load 'hbase://query/select col1,col2.. from TRANSACTION' using org.apache.phoenix.pig.PhoenixHBaseLoader('localhost') as (rowKey:chararray,col_a:int, col_b:double, col_c:chararray);

Re: Exporting a phoenix table into a csvfile

Re: Exporting a phoenix table into a csvfile

Depending on the size of the data you want to export, you can just run a normal query.

SELECT col1 || ',' || col2 || ',' || col3 from my_table;

Re: Exporting a phoenix table into a csvfile

Explorer

@ARUN did you get it, how to export a phoenix table into a csv file?

Re: Exporting a phoenix table into a csvfile

Explorer

@ARUN did you get it, how to export a phoenix table into a csv file?