hive表创建，删除，导入数据，删除数据

--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';