本文共 802 字，大约阅读时间需要 2 分钟。

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

转载地址：https://lovebigdata.blog.csdn.net/article/details/78751292 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！