phoenix 실행

cd /usr/hdp/2.6.3.0-235/phoenix/bin

./sqlline.py 192.168.1.101:2181:/hbase-unsecure

 

 

 

CREATE TABLE Company (COMPANY_ID INTEGER PRIMARY KEY, NAME VARCHAR(225));

 

 

CREATE TABLE Com (COMPANY_ID INTEGER PRIMARY KEY, COMPANY_NAME VARCHAR(225));

 

!tables

 

UPSERT INTO Company VALUES(1, 'Microsoft’);

 

INSERT INTO Company VALUES(4, 'Microsoft4’);

 

UPSERT INTO Com VALUES(1, 'Microsoft');

 

SELECT * FROM Company;

 

!quit