Hive使用记录-建表、加载数据

CREATE TABLE IF NOT EXISTS glif_aa_5kw(c1 STRING, c2 STRING,c3 STRING,c4 STRING, c5 STRING,c6 STRING,c7 STRING,c8 STRING,c9 STRING,c10 STRING, c11 STRING, c12 STRING,c13 STRING,c14 STRING, c15 STRING,c16 STRING,c17 STRING,c18 STRING,c19 STRING,c21 STRING, c22 STRING,c23 STRING,c24 STRING, c25 STRING)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

LOAD DATA LOCAL INPATH '/data1/20_glif_aa_5kw.csv'  INTO TABLE glif_aa_5kw;

SELECT * FROM glif_aa_5kw LIMIT 1;SELECT COUNT(1) FROM glif_aa_5kw;SELECT t1.c1,t2.c1 FROM rddGlifaa t1 JOIN rddGlifaa t2 ON t1.c1=t2.c1SELECT COUNT(DISTINCT(user_id)) FROM t_visit_log;SELECT COUNT(1) FROM glif_aa_5kw t1 JOIN glif_aa_1kw_part_column t2 ON t1.c1=t2.c1;CREATE DATABASE hcfhive0107;USE hcfhive0107;SHOW DATABASES;SHOW TABLES;