I removed the count, but it still does not output the query results.
These are the parameters I set for hive:
set hive.stats.autogather=false
set hive.optimize.autoindex=true;
set hive.optimize.index.filter=true;
set hive.exec.parallel=true;
set mapred.reduce.tasks=5;
set hive.exec.reducers.max=5;
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;
O
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:14 PM, saquib khan wrote:
> I get j
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 Ph
It might help if you post details on the queries themselves.
On Fri, Apr 4, 2014 at 1:14 PM, saquib khan wrote:
> I get java exceptions while running the queries:
>
> java.lang.InstantiationException: org.antlr.runtime.CommonToken
> Continuing ...
> java.lang.RuntimeException: failed to evaluat
I get java exceptions while running the queries:
java.lang.InstantiationException: org.antlr.runtime.CommonToken
Continuing ...
java.lang.RuntimeException: failed to evaluate: =Class.new();
Continuing ...
java.lang.InstantiationException: org.antlr.runtime.CommonToken
Continuing ...
java.lang.Runt
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