Hdfs 导入Hive，时间相关的字段 导入后为NULL

CREATE TABLE  OFFER_${day_id}
(
OFFER_ID    BIGINT,
ATOM_ACTION_ID  BIGINT,
PARTY_ID    BIGINT,
OFFER_SPEC_ID   BIGINT,
OFFER_NBR   STRING,
AREA_ID INT,
MKT_ACTIVITY_ID BIGINT,
START_DT    STRING,
END_DT  STRING,
BSS_START_DT    STRING,
BSS_END_DT  STRING,
BILL_START_DT   STRING,
BILL_END_DT STRING,
STATUS_CD   STRING,
STATUS_DT   STRING,
CREATE_DT   STRING,
VERSION STRING,
EXT_PROD_OFFER_INST_ID  STRING,
EXT_SYSTEM  STRING

) ROW FORMAT DELIMITED
FIELDS TERMINATED BY ''
STORED AS TEXTFILE;
  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
  
17
  
18
  
19
  
20
  
21
  
22
  
23
  
24
  
25
 

解决办法: 之前在Hive中创建表的时候，时间相关的字段建的是DATE类型，发现导入Hive后，DATE字段的值都是NULL。 后来都将DATE类型的字段调整成了STRING类型，经测试，时间相关的字段均可入hive。

文章来源: artisan.blog.csdn.net，作者：小小工匠，版权归原作者所有，如需转载，请联系作者。

原文链接：artisan.blog.csdn.net/article/details/50350298