hadoop fs -ls /user/hive/warehouse
show databases;
use mydb;
show tables;
create table test1(id int,name string)partitioned by (dt string);
https://cwiki.apache.org/confluence/display/Hive/Tutorial
create table page_views
(
track_time string,
url string,
session_id string,
referer string,
ip string,
end_user_id string,
city_id string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
hive -e "load data local inpath '/home/hadoop/page_views.dat' OVERWRITE INTO TABLE page_views;"
内部表(托管表)
Drop
外边表(external )
默认分隔符:列 为 \001 行为 \n
分区表
Insert overwrite table page…
CREATE TABLE page_view(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(dt STRING, country STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '1'
STORED AS SEQUENCEFILE;
select * 不会解析为mapreduce,是直接找hdfs文件
show databases;
use mydb;
show tables;
create table test1(id int,name string)partitioned by (dt string);
https://cwiki.apache.org/confluence/display/Hive/Tutorial
create table page_views
(
track_time string,
url string,
session_id string,
referer string,
ip string,
end_user_id string,
city_id string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
hive -e "load data local inpath '/home/hadoop/page_views.dat' OVERWRITE INTO TABLE page_views;"
内部表(托管表)
Drop
外边表(external )
默认分隔符:列 为 \001 行为 \n
分区表
Insert overwrite table page…
CREATE TABLE page_view(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(dt STRING, country STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '1'
STORED AS SEQUENCEFILE;
select * 不会解析为mapreduce,是直接找hdfs文件