Hive常用命令

Hive常用命令

创建简单表：

CREATE TABLE pokes (foo INT, bar STRING);

创建外部表：

CREATE EXTERNAL TABLE page_view(
    viewTime INT, 
    userid BIGINT,
    page_url STRING, 
    referrer_url STRING,
    ip STRING COMMENT 'IP Address of the User',
    country STRING COMMENT 'country of origination'
)
COMMENT 'This is the staging page view table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '54'
STORED AS TEXTFILE
LOCATION '';

建分区表

CREATE TABLE par_table(
    viewTime INT, 
    userid BIGINT,
    page_url STRING, 
    referrer_url STRING,
    ip STRING COMMENT 'IP Address of the User'
)
COMMENT 'This is the page view table'
PARTITIonED BY(date STRING, pos STRING)
ROW FORMAT DELIMITED ‘’
FIELDS TERMINATED BY ''
STORED AS SEQUENCEFILE;

建Bucket表

CREATE TABLE par_table(
    viewTime INT, 
    userid BIGINT,
    page_url STRING, 
    referrer_url STRING,
    ip STRING COMMENT 'IP Address of the User'
)
COMMENT 'This is the page view table'
PARTITIonED BY(date STRING, pos STRING)
CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
ROW FORMAT DELIMITED ‘’
FIELDS TERMINATED BY ''
STORED AS SEQUENCEFILE;

创建表并创建索引字段

CREATE TABLE invites (foo INT, bar STRING) 
PARTITIonED BY (ds STRING);

复制一个空表

CREATE TABLE empty_key_value_store
LIKE key_value_store;