Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Query Issue


Copy link to this message
-
Re: Hive Query Issue
when you run select * from table .. it does not launch a mapreduce job,

where are when you put some condition, it does need to process the data so
it launches a mapreduce job

now when you start this query, go to your jobtracker page and see how many
jobs are running. Is it able to start your job? if not why ?
that will tell you why its stuck
On Tue, Aug 6, 2013 at 3:22 PM, Manickam P <[EMAIL PROTECTED]> wrote:

> Hi,
>
> If i run a hive query like "select * from table_name limit 10" it is
> working.
> If i run query like "select column_name from table_name limit 10" it
> hangs.
> *Total MapReduce jobs = 1*
> *Launching Job 1 out of 1*
> *Number of reduce tasks is set to 0 since there's no reduce operator*
> It just prints the above after that nothing happening in the hive shell.
>
> Can you pls help me on this.
>
>
> Thanks,
> Manickam P
>

--
Nitin Pawar
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB