Re: Which version of Hive can hanle creating XML table?

Yes. Serde must have been removed then in 2.x. > On 8. Jun 2018, at 23:52, Mich Talebzadeh wrote: > > Ok I am looking at this jar file > > jar tf hive-serde-3.0.0.jar|grep -i abstractserde > org/apache/hadoop/hive/serde2/AbstractSerDe.class > > Is this the correct one? > > Thanks > > >

Re: Which version of Hive can hanle creating XML table?

Ok I am looking at this jar file jar tf hive-serde-3.0.0.jar|grep -i abstractserde org/apache/hadoop/hive/serde2/AbstractSerDe.class Is this the correct one? Thanks Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Which version of Hive can hanle creating XML table?

Thanks Jorn so what is the resolution? do I need another jar file? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpre

Re: Which version of Hive can hanle creating XML table?

Oha i see now Serde is a deprecated Interface , if i am not wrong it has been replaced by the abstract class abstractserde > On 8. Jun 2018, at 22:22, Mich Talebzadeh wrote: > > Thanks Jorn. > > Spark 2.3.3 (labelled as stable) > > First I put the jar file hivexmlserde-1.0.5.3.jar under $HIV

Re: Which version of Hive can hanle creating XML table?

Thanks Jorn. Spark 2.3.3 (labelled as stable) First I put the jar file hivexmlserde-1.0.5.3.jar under $HIVE_HOME/lib and explicitly loaded with ADD JAR as well in hive session hive> ADD JAR hdfs://rhes75:9000/jars/hivexmlserde-1.0.5.3.jar; Added [/tmp/hive/7feb5165-780b-4ab6-aca8-f516d0388823_re

Re: issues with Hive 3 simple sellect from an ORC table

Mich, Try changing the hadoop.version in Hive's pom.xml to 2.7.3 and re-build. That should at least let you know where the problem are. .. Owen On Fri, Jun 8, 2018 at 9:05 AM, Mich Talebzadeh wrote: > Hi Owen, > > It is 2.7.3 > > hadoop version > Hadoop 2.7.3 > Subversion https://git-wip-us.

Re: issues with Hive 3 simple sellect from an ORC table

> It is 2.7.3 + > Error: java.io.IOException: java.lang.RuntimeException: ORC split generation > failed with exception: java.lang.NoSuchMethodError: > org.apache.hadoop.fs.FileStatus.compareTo(Lorg/apache/hadoop/fs/FileStatus;)I > (state=,code=0) https://issues.apache.org/jira/browse/HADOOP-1

Re: Which version of Hive can hanle creating XML table?

Can you get the log files and start Hive with more detailled logs? In could be that not all libraries are loaded (i don’t remember anymore but I think this one needs more , I can look next week in my docs) or that it does not support maps (not sure). You can try first with a more simpler extract

Re: issues with Hive 3 simple sellect from an ORC table

Hi Owen, It is 2.7.3 hadoop version Hadoop 2.7.3 Subversion https://git-wip-us.apache.org/repos/asf/hadoop.git -r baa91f7c6bc9cb92be5982de4719c1c8af91ccff Compiled by root on 2016-08-18T01:41Z Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6Ac

Re: issues with Hive 3 simple sellect from an ORC table

This looks like there is an API incompatibility between the version of hadoop expected and the version used. Which version of hadoop are you using? .. Owen > On Jun 8, 2018, at 08:31, Mich Talebzadeh wrote: > > Just installed and upgraded to Hive 3 where fun and game started :) > > First I ha

Which version of Hive can hanle creating XML table?

I tried Hive 2.0.1, 2.3.2 and now Hive 3/ I explicitly added hivexmlserde jar file as ADD JAR shown below 0: jdbc:hive2://rhes75:10099/default> ADD JAR hdfs://rhes75:9000/jars/hivexmlserde-1.0.5.3.jar; No rows affected (0.002 seconds) But still cannot create an xml table 0: jdbc:hive2://rhes75

issues with Hive 3 simple sellect from an ORC table

Just installed and upgraded to Hive 3 where fun and game started :) First I had to set below as per this JIRA to make hive server 2 start and stay up setting hive.metastore.event.db.notification.api.auth to false on hive-site.xm