My case is very opposite to below JIRAs as in my case , using subquery
giving correct result ...but using original table giving mismatched column
value.
https://issues.apache.org/jira/browse/HIVE-9613
https://issues.apache.org/jira/browse/HIVE-9327
Regards
Sanjiv Singh
Mob : +091 9990-447-339
Adding to that
Surprisingly it is giving correct result if i use derived tables rather
than original tables;
changes query :
*select *from ( select * from T1 ) aLEFT OUTER JOIN ( select * from T2) bON
a.t1c2 = b.t2c1;*
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Mon, Jan 11, 201
Any help on this ?
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Sat, Jan 9, 2016 at 3:42 PM, @Sanjiv Singh
wrote:
> Hi All,
>
> I am facing strange behaviour as explained below. I have tow hive table
> T1 and T2 , joined with LEFT OUTER JOIN ..I am getting strange value for
> two columns
Hi All,
I am facing strange behaviour as explained below. I have tow hive table T1
and T2 , joined with LEFT OUTER JOIN ..I am getting strange value for two
columns t2c2t2c3 of table T2 after join.
See below complete detail :
*Table T1 :*
create table T1 ( t1c1 int , t1c2 int , t1c3 int )
