配置单元错误:无法验证serde:org.apache.hadoop.serde2.regexserde

axzmvihb  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(313)

我在这里非常新,我正在尝试在我的cloudera快速启动vm上运行以下代码。

CREATE TABLE apache_common_log (
  host STRING,
  identity STRING,
  user STRING,
  time STRING,
  request STRING,
  status STRING,
  size STRING
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (

"input.regex" = "([^ ]) ([^ ]) ([^ ]) (-|\^\\]) ([^ "]*|" [^\"]*\") (-|[0-9]*) (-|[0-9]*)", "output.format.string" = "%1$s %2$s %3$s %4$s %5$s %6$s %7$s" ) STORED AS TEXTFILE; 但我有个错误:

failed: execution error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask, Cannot validate serde: org.apache.hadoop.hive.serde2.RegexSerde

我做了一些研究,所有的字段都是字符串,我已经添加了jar /usr/lib/hive/lib/hive-contrib.jar /usr/lib/hive/lib/hive-serde.jar /usr/lib/hive/lib/hive-common.jar 还是没用。真的需要帮助!任何意见都将不胜感激!!!

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题