Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive 3.1 xml parsing error

hive 3.1 xml parsing error

New Contributor

Earlier in our old cluster we had hive 1.2 version and everything was working good. But now in new cluster we are using hive 3.1. I'm not able to run the scripts which are were running earlier used for xml parsing. 

 

i'm using the following jar. 

hive> add jar /home/projects/hivexmlserde-1.0.5.3.jar;

NOTE: I was able to parse the data in old cluster.

 

i'm getting the following error after execution of script

 

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hive/serde2/SerDe
INFO : Completed executing command(queryId=hive_20190923134750_*************); Time taken: 0.022 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hive/serde2/SerDe (state=08S01,code=1).

@Shelton @divakarreddy_a @jsensharma @Shu_ashu @EricL w@leed 

 

 

image.pngHive xml Parsing script

 

Please help me out with this error. Thanks in advance

1 REPLY 1
Highlighted

Re: hive 3.1 xml parsing error

Guru
@wati,

I can see that hivexmlserde has not been updated since 2015, see below link:
https://mvnrepository.com/artifact/com.ibm.spss.hive.serde2.xml/hivexmlserde

This is confirmed by checking the github repository:
https://github.com/dvasilen/Hive-XML-SerDe

It is unlikely that it will work with latest Hive version, given there are lots of changes. You might need to find alternatives. I have not used any, so I do not have recommendations.