无法验证serde：org.openx.data.jsonserde.jsonserde [英] Cannot validate serde : org.openx.data.jsonserde.jsonserde

问题描述

我已经写了这个查询来在配置单元上创建一个表。我的数据最初是json格式，所以我下载并构建了serde并添加了运行所需的所有jar。但我收到以下错误：

  FAILED：执行错误，从org.apache.hadoop.hive.ql返回代码1 .exec.DDLTask。无法验证serde：org.openx.data.jsonserde.JsonSerDe 
  

QUERY：

  create table tip（type string，
 text string，
 business_id string，
 user_id string，
日期日期，
喜欢int）
 ROW FORMAT SERDE'org.openx.data.jsonserde.JsonSerDe'
 WITH SERDEPROPERTIES（date.mapping=date）
 STORED AS TEXTFILE; 
  

解决方案

我也遇到过这个问题。在我的情况下，我设法通过添加 json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar 来解决此问题。
$ b

 蜂房> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar; 
  

以下是我在Ubuntu 14.04上遵循的步骤：

  1。启动Linux终端和cd / usr / local 
 
 2. sudo git clone https://github.com/rcongiu/Hive-JSON-Serde.git 
 
 3。 sudo mvn -Pcdh5 clean package 
 
 4. serde文件位于
 /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7 -SNAPSHOT-jar -with-dependencies.jar 
 
 5.转到hive提示符并添加JAR文件，如步骤6所示。
 
 6. hive> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7- SNAPSHOT-jar-with-dependencies.jar; 
 
 7.现在从配置单元>创建配置单元表。提示。在这个阶段，应该成功创建Hive表，没有任何错误。 
  

Hive 版本：1.2.1

Hadoop 版本：2.7.1

参考：< a href =https://github.com/rcongiu/Hive-JSON-Serde =noreferrer> Hive-JSON-Serde

I have written this query to create a table on hive. My data is initially in json format, so i have downloaded and build serde and added all jar required for it to run. But i am getting the following error:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.openx.data.jsonserde.JsonSerDe

QUERY:

create table tip(type string,
  text string,
  business_id string,
  user_id string,
  date date,
  likes int)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES("date.mapping"="date")
STORED AS TEXTFILE;

解决方案

I too encountered this problem. In my case, I managed to fix this issue by adding json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar at hive command prompt as shown below:

hive> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar;

Below are the steps I have followed on Ubuntu 14.04:

1. Fire up Linux terminal and cd /usr/local

2. sudo git clone https://github.com/rcongiu/Hive-JSON-Serde.git

3. sudo mvn -Pcdh5 clean package

4. The serde file will be in 
   /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar

5. Go to hive prompt and ADD JAR file as shown in Step 6.

6. hive> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7- SNAPSHOT-jar-with-dependencies.jar;

7. Now create hive table from hive> prompt. At this stage, Hive table should be created successfully without any error.

Hive Version: 1.2.1

Hadoop Version: 2.7.1

Reference: Hive-JSON-Serde

这篇关于无法验证serde：org.openx.data.jsonserde.jsonserde的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！