Hi
When you do a SELECT * , the partition columns are returned as last N columns
(if u have N partitions)
In this case the 63rd column in SELECT * is the partition column
Instead of SELECT *
Do a
SELECT
col1,
col2,
col3,
…..
Not to show the candle to t
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
.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
> --
> 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
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
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?
