>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
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:
>
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