hive 3.1 xml parsing error

[#1]

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 script

Please help me out with this error. Thanks in advance

[#2]

@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.

[#3]

is there an alternative that CLDR has identified?

[#4]

@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!