How to export data to text file in Apache phoenix?

Question

I'm quite new to HBase and Phoenix.

But is there a way I can dump/export data to a text file? It would be highly appreciable if I can specify the field terminator, such as ',', '|>' etc.

Thanks.

score 26 · Answer 1 · answered Nov 25 '15 at 08:51

26

Another Solution.
After connecting to phoenix with sqlline.py:

!outputformat csv
!record data.csv
select * from system.catalog limit 10;
!record
!quit

answered Nov 25 '15 at 08:51

IgorekPotworek

1,267
11
32

This seems good except that my output file includes the message "Saving all output to..." and at the end of the select "3 rows selected". Is there a way to get it *only* output the stuff i want? or to skip system messages or something? – mr rogers Sep 02 '16 at 18:28
1

I have successfully exported, but some numbers are formatted in scientific notation (1,003E+4) when it should simply be an integer (or long float). How do I export the original number not formated? – LuizAngioletti May 22 '18 at 20:27
Is there a way to avoid scientific notation? – Jaison May 28 '20 at 02:04

score 2 · Answer 2 · answered Nov 25 '15 at 06:24

2

You can do it with Apache Pherf. Pherf arguments: -export Exports query results to CSV files in CSV_EXPORT directory

answered Nov 25 '15 at 06:24

Ramin Darvishov

1,024
1
13
24

I found this link also. But how can I specify the delimiter, for example '|>', I want? A sample code would be highly appreciated. – dehiker Nov 25 '15 at 08:10
1

Why don't you try using sed once you have generated the dump? – Pratyay May 09 '16 at 07:42
1

Are you sure this exports query output or the performance testing results ? – iec2011007 May 29 '17 at 11:33

score 0 · Answer 3 · answered May 09 '16 at 07:50

0

A workaround is to use sed once you have generated the dump. In my case, I wanted a \t de-limiter. However, the column values were of the form 'A','B','C','D' a simple s/','/'\t'/g did the trick for me.

answered May 09 '16 at 07:50

Pratyay

1,946
1
13
14

How to export data to text file in Apache phoenix?

3 Answers3