Re: Oracle 11g Hive 2.1 metastore backend

2018-06-07 Thread Arjun kr
to oracle.sql.CLOB) Alan, Thanks for your inputs. Regards, Arjun From: Alan Gates 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

Re: Oracle 11g Hive 2.1 metastore backend

2018-06-06 Thread Alan Gates
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 wrote:

Re: Oracle 11g Hive 2.1 metastore backend

2018-06-06 Thread Mich Talebzadeh
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

Oracle 11g Hive 2.1 metastore backend

2018-06-05 Thread Arjun kr
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:

Reg:Sqoop Import-Oracle to Hive-Parquet

2016-11-29 Thread kishore kumar
Hi Experts, We are trying to use parquet for importing data from oracle to hive, we are encountering the below error, could anyone help me to resolve this issue ? We are using sqoop version 1.4.6 and hive version 1.2. Error: 16/11/28 21:21:46 INFO hive.metastore: Connected

Re: Oracle to Hive

2013-07-10 Thread Michael Malak
From: Raj Hadoop hadoop...@yahoo.com To: Hive user@hive.apache.org Sent: Wednesday, July 10, 2013 3:30 PM Subject: Oracle to Hive   All,   Can anyone give me tips on how to convert the following Oracle SQL to a Hive query.     SELECT a.c100, a.c300, b.c400

RE: Data mismatch when importing data from Oracle to Hive through Sqoop without an error

2013-03-08 Thread Ajit Kumar Shreevastava
importing data from Oracle to Hive through Sqoop without an error Hi Ajit Do you know if rest of the columns also are null when the three non null columns are null Venkat On Wed, Mar 6, 2013 at 12:35 AM, Ajit Kumar Shreevastava ajit.shreevast...@hcl.com wrote: Hi Abhijeet, Thanks for your

Re: Data mismatch when importing data from Oracle to Hive through Sqoop without an error

2013-03-06 Thread Venkat Ranganathan
inserted as Null is the case then count should not be mis-match in both the case. Here the null value inserted are extra value apart from the other value which is already present in both Oracle Table and Hive table. Correct me if I am wrong in interpretation. Thanks and Regards, Ajit

Re: Data mismatch when importing data from Oracle to Hive through Sqoop without an error

2013-03-06 Thread Jarek Jarcec Cecho
in both Oracle Table and Hive table. ** ** Correct me if I am wrong in interpretation. ** ** Thanks and Regards, Ajit Kumar Shreevastava ** ** *From:* abhijeet gaikwad [mailto:abygaikwa...@gmail.com] *Sent:* Wednesday, March 06, 2013 1:46 PM *To:* user