search

neilChenXie / MyExp

1 stars 0 forks source link

HBase客户端 #116

Closed neilChenXie closed 6 years ago

neilChenXie commented 7 years ago

jeff_fang(方昆) 05-18 15:37:50

SQuirreL SQL Client

jeff_fang(方昆) 05-18 15:39:01

http://phoenix.apache.org/language/index.html#create_table

jeff_fang(方昆) 05-18 15:39:12

hbasehenley_lin(林恒) 21:09:44

CREATE EXTERNAL TABLE h_user_read(key String, memId string, type String, strDate String, remoteAddr String, clientType String, refId String, refType String, source String) STORED BY 'org.apache.phoenix.jdbc.PhoenixDriver' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,h_user_read:memId,h_user_read:type,h_user_read:strDate,h_user_read:remoteAddr,h_user_read:clientType,h_user_read:refId,h_user_read:refType,h_user_read:source") TBLPROPERTIES("hbase.table.name" = "h_user_read");