You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Arjun kr <ar...@outlook.com> on 2018/06/06 04:10:23 UTC
Oracle 11g Hive 2.1 metastore backend
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
Re: Oracle 11g Hive 2.1 metastore backend
Posted by Arjun kr <ar...@outlook.com>.
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 <al...@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 <mi...@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 <ar...@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
Re: Oracle 11g Hive 2.1 metastore backend
Posted by Alan Gates <al...@gmail.com>.
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 <mi...@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 <ar...@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
>>
>>
>
Re: Oracle 11g Hive 2.1 metastore backend
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <ar...@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
>
>