hive操作(三)

从hive导入到文件中

insert overwrite local directory '/home/source/load_local.txt' select * from t_hive2;

从hive导入到hdfs

insert overwrite directory  '/user/hive/warehouse/search_urls/online-s1'  select * from search_urls  limit 5

导hdfs文件到hive

load data inpath '/user/hive/warehouse/t_hadoop/load_f.txt' overwrite into table t_hive2;

清空hive表

insert overwrite table pokes select * from pokes where 1=0;

建分区表

CREATE TABLE t_hft(
SecurityID STRING,
tradeTime STRING,
PreClosePx DOUBLE
) PARTITIONED BY (tradeDate INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';