Re: NPE from simple nested ANSI Join

2016-02-05 Thread Dave Nicodemus
>Rally Health > >nicholas.hakob...@rallyhealth.com > > > >On Thu, Feb 4, 2016 at 12:57 PM, Dave Nicodemus > > wrote: > >> Thanks Nick, > >> > >> I did a few experiments and found that the version of the query below > >>d

Re: NPE from simple nested ANSI Join

2016-02-04 Thread Dave Nicodemus
requires it to > have a table name alias so it can be referenced in an outer statement. > > -Nick > > Nicholas Szandor Hakobian > Data Scientist > Rally Health > nicholas.hakob...@rallyhealth.com > > On Thu, Feb 4, 2016 at 11:28 AM, Dave Nicodemus > wrote: >

NPE from simple nested ANSI Join

2016-02-04 Thread Dave Nicodemus
Using hive 1.2.1.2.3 Connecting using JDBC, issuing the following query : SELECT COUNT(*) FROM nation n INNER JOIN (customer c INNER JOIN orders o ON c.c_custkey = o.o_custkey) ON n.n_nationkey = c.c_nationkey; Generates the NPE and stack below. Fields are integ