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 On Mon, Jan 11, 2016 at 10:44 PM, David Morel <david.mo...@amakuru.net> wrote: > On 11 Jan 2016, at 8:54, @Sanjiv Singh wrote: > > > Adding to that .... > > > > Surprisingly it is giving correct result if i use derived tables rather > > than original tables; > > Related to https://issues.apache.org/jira/browse/HIVE-9613 ? > > David >