hive - 将空值加载到 Hive 表

Question

我有一个包含以下行的 .txt 文件:

Steve,1 1 1 1 1 5 10 20 10 10 10 10

当我创建一个外部表、加载数据并选择 * 时，我得到了空值。请帮助如何显示数值而不是空值。非常感谢您的帮助!

create external table Teller(Name string, Bill array<int>)
row format delimited
fields terminated by ','
collection items terminated by '\t'
stored as textfile
location '/user/training/hive/Teller';

load data local inpath'/home/training/hive/input/*.txt' overwrite into table Teller;

输出:

Steve   [null]

Answer 1

似乎整数是用空格而不是制表符分隔的

庆典

hdfs dfs -mkdir -p /user/training/hive/Teller
echo Steve,1 1 1 1 1 5 10 20 10 10 10 10 | hdfs dfs -put - /user/training/hive/Teller/data.txt

hive

hive> create external table Teller(Name string, Bill array<int>)
    > row format delimited
    > fields terminated by ','
    > collection items terminated by ' '
    > stored as textfile
    > location '/user/training/hive/Teller';
OK
Time taken: 0.417 seconds
hive> select * from teller;
OK
Steve   [1,1,1,1,1,5,10,20,10,10,10,10]