Serde的匹配属性

发布于 2025-02-13 22:46:33 字数 376 浏览 0 评论 0原文

看来我能够创建具有无效属性的表。例如，“ Some_junk”不是CSV序列化的有效属性。该声明应该失败。

CREATE EXTERNAL TABLE test2 (
f1 string,
s2 string) 
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' 
WITH SERDEPROPERTIES ("some_junk" = ",", "escapeChar" = "\\") 
LOCATION 's3://DOC-EXAMPLE-BUCKET/dataset/test1/'

由于“ some_junk ”，我期望出现错误。但是该声明已成功执行。

原文

It seems that I am able to create tables with invalid properties.
For e.g. "some_junk" is not valid property of csv serialization. The statement should fail.

CREATE EXTERNAL TABLE test2 (
f1 string,
s2 string) 
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' 
WITH SERDEPROPERTIES ("some_junk" = ",", "escapeChar" = "\\") 
LOCATION 's3://DOC-EXAMPLE-BUCKET/dataset/test1/'

I was expecting an error because of "some_junk". But the statement was executed successfully.

分享到QQ

分享到微博