Phoenix建表和Hbase建表

#Phoenix
#创建schema
create schema if not exists test;

#创建表
CREATE TABLE IF NOT EXISTS test.test_1 (
  id INTEGER NOT NULL,
  name VARCHAR,
  age INTEGER,
  CONSTRAINT pk PRIMARY KEY (id)
) SALT_BUCKETS=3;

#查看所有
!tables

#插入数据
UPSERT INTO test.test_1 (id, name, age) VALUES (1, 'John', 25);
UPSERT INTO test.test_1 (id, name, age) VALUES (2, 'Jane', 30);

#查看表数据
Select * from test.test_1

#删除表
drop  table test.test_1

#Hbase 
#创建NameSpace
create_namespace 'demo'

#查看NameSpace
list_namespace

#创建表，指定两列
create 'demo:test_2', 'cf1', 'cf2'

#查看表信息
describe 'demo:test_2'

#插入数据
put 'demo:test_2', 'row1', 'cf1:name', 'John'
put 'demo:test_2', 'row1', 'cf1:age', '25'

put 'demo:test_2', 'row2', 'cf2:name', 'Alice'
put 'demo:test_2', 'row2', 'cf2:age', '30'

#查看表数据
scan 'demo:test_2'

#删除表(先下线，再删除)
disable 'demo:test_2'
drop 'demo:test_2'