Support Questions
Find answers, ask questions, and share your expertise

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 

 

 

Hive xml Parsing scriptHive xml Parsing script

 

Please help me out with this error. Thanks in advance

3 REPLIES 3

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.

New Contributor

is there an alternative that CLDR has identified?

Moderator

@smarinov As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. Thanks!


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
; ;