
之前集群一直好的,最近装了新的,hdp-hive-3.1.0.
CREATE EXTERNAL TABLE `ods.a2`( `key` string COMMENT 'k', `value` string COMMENT 'v') COMMENT '注释' ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ( 'field.delim'=',,', 'serialization.format'=',,') STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 'hdfs:///user/hive/warehouse/ods.db/a2'; err:
Error: Error while compiling statement: FAILED: SemanticException Line 1:22 Table or database name may not contain dot(.) character 'ods.a2' (state=42000,code=40000) 有一个办法是这样 CREATE EXTERNAL TABLE ods.a2 但是之前一直是可以的,不想改,而且一些手动 set 的 hive 属性都带 dot,都无法使用。
1 SErHo 2021-04-08 20:15:24 +08:00 `ods.a2` -> `ods`.`a2` |