Hi Mike,
Yes. The create table statements fail with below exception. Could you please check the version of datanucleus-rdbms.jar that you have? Caused by: MetaException(message:java.lang.ClassCastException: org.datanucleus.store.rdbms.mapping.datastore.ClobImpl cannot be cast to oracle.sql.CLOB) Alan, Thanks for your inputs. Regards, Arjun ________________________________ From: Alan Gates <alanfga...@gmail.com> Sent: Thursday, June 7, 2018 1:38 AM To: user@hive.apache.org Subject: Re: Oracle 11g Hive 2.1 metastore backend 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<mailto: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 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<mailto: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