Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

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


+
Manickam P 2013-08-06, 09:52
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
+
Manickam P 2013-08-06, 11:10
+
Sunita Arvind 2013-08-07, 14:22
+
Sanjay Subramanian 2013-08-07, 19:31
+
Manickam P 2013-09-02, 11:32
+
manish dunani 2013-09-02, 11:52
+
Sanjay Subramanian 2013-09-03, 18:18