Hive的SQL基本上和我们原先的MYSQL的SQL查询效果差不多,下面是一些实例:
create databases hivedb;
我们可以看到会在/user/hive/warehouse 下面出现hivedb.db文件
use hivedb
;create table test(id int,name string);
drop table test;
CREATE TABLE IF NOT EXISTS t_customer(id int,name string,age int,address string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '/opt/datas/customer.txt' OVERWRITE INTO TABLE T_CUSTOMER;
hdfs dfs -mkdir /user/datas
hdfs dfs -put /opt/datas/customer.txt /user/datas
然后将HDFS数据导入hive
LOAD DATA INPATH '/user/datas/customer.txt' INTO TABLE T_CUSTOMER;
我们可以看到源文件已经删除
但是在warehouse会保留备份