在hive里面操作sogou数据

进入hive：

hive

查看数据库

SHOW DATABASES;

创建一个数据库

CREATE DATABASE sogou;

连接数据库

USE sogou;

创建表

CREATE EXTERNAL TABLE sogou.sogou_20111230(
    ts STRING,
    uid STRING,
    keyword STRING,
    rank INT,
    order INT,
    URL STRING
  )COMMENT 'This is sogou search query data of one day' 
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\t'
  STORED AS TEXTFILE 
  LOCATION '/user/hadoop/input/sogou/20111230';

查看表

SHOW TABLES;

查看创建的表的信息

SHOW CREATE TABLE sogou.sogou_20111230

查看表信息

DESCRIBE sogou.sogou_20111230;

再次创建表

CREATE EXTERNAL TABLE sogou.sogou_ext_20111230(
ts STRING,
uid STRING,
keyword STRING,
rank INT,
order INT,
URL STRING,
yrer INT,
month INT,
day INT,
hour INT
)COMMENT 'This is sogou search query data of one day' ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE 
LOCATION '/user/hadoop/input/sogou/sogou_ext';

再次创建分区表

CREATE EXTERNAL TABLE sogou.sogou_partition(
ts STRING,
uid STRING,
keyword STRING,
rank INT,
order INT,
URL STRING
)COMMENT 'This is sogou search query data by partition'
partitioned by(
yrer INT,
month INT,
day INT,
hour INT
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE ;

end