Re: Hive Query - Issue

2013-09-03 Thread Sanjay Subramanian
ache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Monday, September 2, 2013 4:32 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Hive Query - Issue Hello Experts, when i try to exe

Re: Hive Query - Issue

2013-09-02 Thread manish dunani
Hello, I think you are working with dynamic partition. Then you do not need to mention it's value.you only need to put partition like this::: try this:: insert overwrite table table_baseline partition (sourcedate) select * from (select * from table_a where sourcedate='tablea_2013_08' union all s

Hive Query - Issue

2013-09-02 Thread Manickam P
Hello Experts, when i try to execute the below query i'm getting error. Please help me to correct this. insert overwrite table table_baseline partition (sourcedate='base_2013_08') select * from (select * from table_a where sourcedate='tablea_2013_08' union all select * from table_b where sou

Re: Hive Query Issue

2013-08-07 Thread Sanjay Subramanian
.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Tuesday, August 6, 2013 4:10 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: RE: Hive Query Issue Hi, Thanks for your reply. I have a small tes

Re: Hive Query Issue

2013-08-07 Thread Sunita Arvind
> -- > Date: Tue, 6 Aug 2013 16:24:38 +0530 > Subject: Re: Hive Query Issue > From: nitinpawar...@gmail.com > To: user@hive.apache.org > > > when you run select * from table .. it does not launch a mapreduce job, > > where are when you put

RE: Hive Query Issue

2013-08-06 Thread Manickam P
also. All my data nodes are up and running. I don't have any clue here. Thanks, Manickam P Date: Tue, 6 Aug 2013 16:24:38 +0530 Subject: Re: Hive Query Issue From: nitinpawar...@gmail.com To: user@hive.apache.org when you run select * from table .. it does not launch a mapreduce job, wher

Re: Hive Query Issue

2013-08-06 Thread Nitin Pawar
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?

Hive Query Issue

2013-08-06 Thread Manickam P
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 = 1Launching Job 1 out of 1Number of reduce tasks is set to 0 since there's no reduce operatorIt just prints the above