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; set hive.auto.convert.join=true; set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict;
On Fri, Apr 4, 2014 at 4:38 PM, Decimus Phostle <decimusphos...@gmail.com>wrote: > 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 <skhan...@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 <decimusphos...@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 <skhan...@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 <skhan...@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 >>>>> >>>> >>>> >>> >> >