phoenix #조회 #hbase
-
phoenix 실행빅데이터 2019. 8. 29. 01:00
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; !q..