在配置单元中显示为null的非字符串值

yuvru6vn  于 2021-05-27  发布在  Hadoop
关注(0)|答案(1)|浏览(508)

我是新来的Hive和创建我的第一个表!
出于某种原因,所有非字符串值都显示为null(包括int、boolean等)
我的数据如下所示:

58;"management";"married";"tertiary";"no";2143;"yes";"no";"unknown";5;"may";261;1;-1;0;"unknown";"no"

我用这个来创建表:

create external table bank_dataset(
age       TINYINT, 
job       string, 
education string, 
default   BOOLEAN, 
balance   INT, 
housing   BOOLEAN, 
loan      BOOLEAN, 
contact   STRING,
day       STRING, 
month     STRING, 
duration  INT,
campaign  INT, 
pdays     INT, 
previous  INT,
poutcome  STRING,
y         BOOLEAN)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\u003B'
STORED AS TEXTFILE
location '/user/marchenrisaad_gmail/Bank_Project'
tblproperties("skip.header.line.count"="1");
mkshixfv

mkshixfv1#

谢谢你的评论!但我有一个问题。对于每一行,我都正确地获得了所有数据,然后我得到了空值的额外列。在我的代码下面找到:

create external table bank_dataset(age TINYINT, job string, education string, default BOOLEAN, balance INT, housing BOOLEAN, loan BOOLEAN, contact STRING,day INT, month STRING, duration INT,campaign INT, pdays INT, previous INT, poutcome STRING,y BOOLEAN)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   "separatorChar" = "\u003B",
   "quoteChar"     = '"'
)  
STORED AS TEXTFILE
location '/user/marchenrisaad_gmail/Bank_Project'
tblproperties("skip.header.line.count"="1");

有什么建议吗?

相关问题