我有一个由以下代码创建的配置单元表:
CREATE TABLE如果不是EXISTS测试(datetime STRING,person_name STRING)ALTER TABLE测试SET serdeproperties(‘serialization.encoding’=‘UTF-8’…
我已用单引号替换双引号,插入数据时看不到任何错误。
hive> CREATE TEMPORARY TABLE IF NOT EXISTS test1 > (datetime STRING, person_name STRING); OK Time taken: 0.058 seconds hive> ALTER TABLE test1 SET serdeproperties ('serialization.encoding'='UTF-8'); OK Time taken: 0.079 seconds hive> insert into table test1 values ('2010-01-01', '啊'); Time taken: 12.456 seconds hive> select * from test1; OK 2010-01-01 啊 Time taken: 0.168 seconds, Fetched: 1 row(s)
即使有双引号,也没有问题
hive> insert into table test1 values ("2010-01-01", "啊"); hive> select * from test1; OK 2010-01-01 啊 2010-01-01 啊 Time taken: 0.102 seconds, Fetched: 2 row(s)