hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Decimus Phostle <decimusphos...@gmail.com>
Subject Re: Unable to run Join queries
Date Fri, 04 Apr 2014 20:38:10 GMT
You seem to have a dangling aggregate function in your SELECT:

SELECT
exposed_time,
ROUND(COUNT(ses_tx_20130805.pid)/10) ***COUNT***
FROM
tx_demography_info JOIN ses_tx_20130805
ON
(tx_demography_info.pid=ses_tx_20130805.pid)
WHERE
countyid='50015'
GROUP BY
exposed_time
ORDER BY
exposed_time;



On Fri, Apr 4, 2014 at 1:25 PM, saquib khan <skhannit@gmail.com> wrote:

> Thanks Decimus.
>
> Query:
> SELECT exposed_time, ROUND(COUNT(ses_tx_20130805.pid)/10) COUNT FROM
> tx_demography_info join ses_tx_20130805 on
> (tx_demography_info.pid=ses_tx_20130805.pid) where countyid='50015' GROUP
> BY exposed_time ORDER BY exposed_time;
>
>
>
>
>
>
>
>
> On Fri, Apr 4, 2014 at 4:22 PM, Decimus Phostle <decimusphostle@gmail.com>wrote:
>
>> It might help if you post details on the queries themselves.
>>
>>
>> On Fri, Apr 4, 2014 at 1:14 PM, saquib khan <skhannit@gmail.com> wrote:
>>
>>> I get java exceptions while running the queries:
>>>
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>> java.lang.InstantiationException: org.antlr.runtime.CommonToken
>>> Continuing ...
>>> java.lang.RuntimeException: failed to evaluate: <unbound>=Class.new();
>>> Continuing ...
>>>
>>>
>>>
>>> On Fri, Apr 4, 2014 at 4:03 PM, saquib khan <skhannit@gmail.com> wrote:
>>>
>>>> Dear Folks,
>>>>
>>>> Whenever I run join queries, it does not display the output, thought it
>>>> give me output for queries on single table.
>>>>
>>>> Thanks and Regards,
>>>> Saky
>>>>
>>>
>>>
>>
>

Mime
View raw message