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 to
a.c300 = 0
From: Raj Hadoop
To: Hive
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
FROM t1 a JOIN t2 b ON
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
FROM t1 a JOIN t2 b ON a.c200 = b.c200
WHERE a.c100 IN (SELECT DISTINCT a.c100
FROM t1 a JOIN t2 b ON a.c200 = b.c200
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
wrote:
> Hi Abhijeet,
>
>
>
> Thanks for your r
gt; > Correct me if I am wrong in interpretation.
> >
> > ** **
> >
> > Thanks and Regards,
> >
> > Ajit Kumar Shreevastava
> >
> > ** **
> >
> > *From:* abhijeet gaikwad [mailto:abygaikwa...@gmail.com]
> > *Sent:* Wednesday, March 0
n.
>
>
>
> Thanks and Regards,
>
> Ajit Kumar Shreevastava
>
>
>
> From: abhijeet gaikwad [mailto:abygaikwa...@gmail.com]
> Sent: Wednesday, March 06, 2013 1:46 PM
> To: user@hive.apache.org
> Cc: u...@sqoop.apache.org
> Subject: Re: Data mismatch when importi