We currently run our Oracle tests against 11g, but that is only for the 3.0 and beyond releases. Given the error I am guessing this is a result of the Oracle version plus the datanucleus version, which we changed between 2.1 and 2.3.
Alan. On Wed, Jun 6, 2018 at 12:12 PM Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > 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 >> >> >