My Hive is 2.3.2 my Oracle is 12.c
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options and these are hive connections sessions as on JUN 06 2018 08:21 PM LOGIN SID/serial# LOGGED IN S HOST OS PID Client PID PROGRAM MEM/KB Logical I/O Physical I/O --------------- ----------- ----------- ---------- -------------- -------------- --------------- ------------ ---------------- ------------ ACT INFO --- ------- HIVEUSER 46,34139 06/06 07:29 rhes75 oracle/28441 hduser/1234 JDBC Thin Clien 1,088 46 0 N HIVEUSER 325,8569 06/06 08:01 rhes75 oracle/28748 hduser/1234 JDBC Thin Clien 1,088 44 0 N HIVEUSER 407,64925 06/06 07:29 rhes75 oracle/28437 hduser/1234 JDBC Thin Clien 1,088 44 0 N I have no issues Is this your issue? Caused by: MetaException(message:java.lang.ClassCastException: org.datanucleus.store.rdbms.mapping.datastore.ClobImpl cannot be cast to oracle.sql.CLOB) HTH, Mich Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 6 June 2018 at 05:10, Arjun kr <arjun...@outlook.com> wrote: > Hi All, > > Is anyone using Oracle 11g configured as Hive 2.1 metastore backend? I'm > encountering below exception with Oracle 11g configured as Hive 2.1 > metastore backend. Any help would be appreciated. > > 2018-05-23T13:05:03,219 DEBUG [main] transport.TSaslTransport: CLIENT: > reading data length: 211 > 2018-05-23T13:05:03,220 DEBUG [main] transport.TSaslTransport: data length > after unwrap: 179 > 2018-05-23T13:05:03,245 ERROR [main] exec.DDLTask: > org.apache.hadoop.hive.ql.metadata.HiveException: > MetaException(message:java.lang.ClassCastException: > org.datanucleus.store.rdbms.mapping.datastore.ClobImpl cannot be cast to > oracle.sql.CLOB) > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:842) > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:847) > at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3992) > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:332) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:197) > at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential( > TaskRunner.java:100) > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2074) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1745) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1454) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1172) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1162) > at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd( > CliDriver.java:234) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:185) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:337) > at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:435) > at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:451) > at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:763) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:729) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:652) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:647) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > Caused by: MetaException(message:java.lang.ClassCastException: > org.datanucleus.store.rdbms.mapping.datastore.ClobImpl cannot be cast to > oracle.sql.CLOB) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_ > table_with_environment_context_result$create_table_ > with_environment_context_resultStandardScheme.read( > ThriftHiveMetastore.java:41498) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_ > table_with_environment_context_result$create_table_ > with_environment_context_resultStandardScheme.read( > ThriftHiveMetastore.java:41466) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$create_ > table_with_environment_context_result.read(ThriftHiveMetastore.java:41392) > at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client. > recv_create_table_with_environment_context(ThriftHiveMetastore.java:1183) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client. > create_table_with_environment_context(ThriftHiveMetastore.java:1169) > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient. > create_table_with_environment_context(HiveMetaStoreClient.java:2334) > at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient. > create_table_with_environment_context(SessionHiveMetaStoreClient.java:93) > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable( > HiveMetaStoreClient.java:747) > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable( > HiveMetaStoreClient.java:735) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke( > RetryingMetaStoreClient.java:154) > at com.sun.proxy.$Proxy20.createTable(Unknown Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient$ > SynchronizedHandler.invoke(HiveMetaStoreClient.java:2265) > at com.sun.proxy.$Proxy20.createTable(Unknown Source) > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:832) > ... 26 more > > Thanks, > > Arjun > >