How to export data to text file in Apache phoenix?

hbase phoenix
dehiker picture dehiker · Nov 23, 2015 · Viewed 10.2k times · Source

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

IgorekPotworek picture IgorekPotworek · Nov 25, 2015

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

Related questions

Phoenix sqlline cannot display all columns of table on terminal

Use phoenix sqlline to connect the hbase. On SecureCRT terminal I can only see three columns of table which has more than 10 columns. I would like to display all columns of the table to test if data is ok. Is …

Read More
How to create a Phoenix Table / View over an Existing Hbase table

I am new to Phoenix, Hbase. We have a requirement to issue SQL Like queries against Hbase Database. A decision was made to go with Apache Phoenix as the SQL Skin on top of an existing Hbase table which was …

Read More
How to delete all data from solr and hbase

How do I delete all data from solr by command? We are using solr with lily and hbase. How can I delete data from both hbase and solr? http://lucene.apache.org/solr/4_10_0/tutorial.html#Deleting+Data

Read More