hive表创建，删除，导入数据，删除数据代码,Hive代码库,德仔网

代码语言

代码分类

【Hive】 hive表创建，删除，导入数据，删除数据

作者: / 发布于2017/7/12/ 662

--hive 数据表创建 
use company; 
DROP TABLE ETL_ACTIONS_TMP; 
CREATE TABLE IF NOT EXISTS company.ETL_ACTIONS_TMP 
( 
time STRING, 
ip STRING, 
action STRING, 
customer_id STRING 
) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' 
STORED AS TEXTFILE 
LOCATION '/user/work/tables2/ETL_ACTIONS_TMP'; 

--带分区 
CREATE TABLE IF NOT EXISTS company.FACT_EC_PRODUCT 
( 
STATE_DATE      INT, 
EXIT_NUMBER     INT 
) 
PARTITIONED BY (datestr STRING,account STRING) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' 
STORED AS TEXTFILE 
LOCATION '/user/work/tables2/FACT_EC_PRODUCT'; 

--数据插入hive表 

INSERT OVERWRITE TABLE bae_ods.ETL_ACTIONS_TMP 
select time,ip,action,customer_id from a 
END_HIVE 


--数据导出 

INSERT OVERWRITE LOCAL DIRECTORY '/home/work/20120321/dim_ec_browser' 
select 
concat(BROWSER_ID,'\t',BROWSER) 
from dim_ec_browser; 

cat /home/work/20120321/dim_ec_browser/* >/home/work/exp_data/dim_ec_browser.txt; 


--创建外部表 

CREATE EXTERNAL TABLE IF NOT EXISTS ETL_ACTIONS 
( 
time STRING, 
region_id STRING, 
action STRING, 
pay STRING 
) 
PARTITIONED BY (datestr STRING) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' 
STORED AS TEXTFILE 
LOCATION '/user/gan/tables2/ETL_ACTIONS';

试试其它关键字

同语言下

可能有用的

贡献的其它代码Label