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.

Answer 1

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

1. !outputformat csv
2. !record data.csv
3. select * from system.catalog limit 10;
4. !record
5. !quit

Answer 2

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