hive里建内部表和外部表示例

hive里建内部表

CREATE  TABLE MID_YW_NUMBER_2(       yw_mdn  STRING,        prov_id STRING,       operators INT,       bw_users BIGINT,       bw_users_trend DECIMAL(38,4))ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'    --分隔符NULL DEFINED AS ''          --为空的用NULL替代STORED AS INPUTFORMAT   'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT   'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'LOCATION   '/BIGDATA/DWI/TMP/YIWANGCEFAN/MID_YW_NUMBER_2';--存储数据文件路径

hive里建外部表

CREATE EXTERNAL TABLE SUM_YW_COMMCIR_M (       yw_mdn  STRING,        prov_id STRING,       operators INT,       bw_users BIGINT,       bw_users_trend DECIMAL(38,4))PARTITIONED BY(PART_MONTH STRING)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' NULL DEFINED AS '' LOCATION   '/BIGDATA/DWI/TMP/YIWANGCEFAN/SUM_YW_COMMCIR_M';