Home: http://manmustbecool.github.io/MyWiki/

0.1 Hbase

cd /opt/hbase-0.94.26/bin/
./hbase shell

0.2 phoenix

start sql

cd /opt/phoenix-3.3.0-src/bin/
./sqlline.py localhost

http://phoenix.apache.org/faq.html

? # help
!tables # list tables
!describe <tablename> # describe table

sql command line is similar to SQLLine

create table test (mykey integer not null primary key, mycolumn varchar);
upsert into test values (1,'Hello');
upsert into test values (2,'World!');
select * from test;

load CSV file

head /opt/phoenix-3.3.0-src/examples/WEB_STAT.csv
./psql.py localhost -t 'WEB_STAT' ../examples/WEB_STAT.csv

.