Entered :
https://issues.apache.org/jira/browse/HIVE-13012
On Thu, Feb 4, 2016 at 6:58 PM, Sergey Shelukhin
wrote:
> The stack below looks like a bug; Hive should support joins like these, or
> it should fail with a parse error, not an NPE. Can you open a JIRA?
>
> On 16/2/4, 15:15, "Nicholas Ha
Hi Dave,
Your schema looks like this
NATION --< CUSTOMER --< ORDERS
I have a similar schema with the following relationship
COUNTRIES --< CUSTOMERS --< SALES
I tried this one and it works both in Hive 1.2.1 and Spark getting total sales
for each country
SELECT c.country_nam
The stack below looks like a bug; Hive should support joins like these, or
it should fail with a parse error, not an NPE. Can you open a JIRA?
On 16/2/4, 15:15, "Nicholas Hakobian"
wrote:
>I'm only aware of this:
>https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins
>but its unc
I'm only aware of this:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins
but its unclear if it supports your syntax or not.
Nicholas Szandor Hakobian
Data Scientist
Rally Health
nicholas.hakob...@rallyhealth.com
On Thu, Feb 4, 2016 at 12:57 PM, Dave Nicodemus
wrote:
> Thanks
Thanks Nick,
I did a few experiments and found that the version of the query below does
work. So I'm not sure about your theory. Do you know if there is a document
that spells out the exact accepted syntax ?
SELECT COUNT(*)
FROM (nation n INNER JOIN customer c ON n.n_nationkey = c.c_nationkey)
IN
I don't believe Hive supports that join format. Its expecting either a
table name or a subquery. If its a subquery, it usually 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...@rallyh
