You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Kishore kumar <ki...@techdigita.in> on 2014/01/07 10:13:10 UTC
partitioned by usage
Hi Experts,
As per this link
http://stackoverflow.com/questions/10276584/hive-table-partition-with-column-in-the-middle
I understood that we can create the partitioned table when we have already
a non partitioned table, if it is correct, when we will use partitioned by
clause to create a new partitioned table.
--
*Kishore Kumar*
Re: partitioned by usage
Posted by Nitin Pawar <ni...@gmail.com>.
its something like this
create table xyz (a int, b string) partitioned by (c string);
LOAD DATA LOCAL INPATH 'abc' INTO TABLE xyx PARTITION(c="abc");
remember if your data has multiple values on partition column and you do
not want to write mapreduce code or pig scripts then you will need a
temporary table and then enable dynamic partitioning while loading into
real table
On Tue, Jan 7, 2014 at 3:54 PM, Kishore kumar <ki...@techdigita.in> wrote:
> How to create partitioned table without creating intermediate table?
> simply..
>
>
> On Tue, Jan 7, 2014 at 10:21 AM, Nitin Pawar <ni...@gmail.com>wrote:
>
>> can you put your question in with an example?
>>
>>
>> On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar <ki...@techdigita.in>wrote:
>>
>>> Hi Experts,
>>>
>>> As per this link
>>>
>>>
>>> http://stackoverflow.com/questions/10276584/hive-table-partition-with-column-in-the-middle
>>>
>>> I understood that we can create the partitioned table when we have
>>> already a non partitioned table, if it is correct, when we will use
>>> partitioned by clause to create a new partitioned table.
>>>
>>> --
>>>
>>> *Kishore Kumar*
>>>
>>>
>>
>>
>> --
>> Nitin Pawar
>>
>
>
>
> --
>
> *Kishore Kumar*
> ITIM
>
> Bidstalk - Ingenius Programmatic Platform
>
> Email: kishore@techdigita.in| Tel: +1 415 423 8230 | Cell: +91 741 135
> 8658 | skype: kishore.alajangi | YM: kk_asn2004 | Twitter:
> __kishorealajangi
> [image: Inline image 1]
>
--
Nitin Pawar
Re: partitioned by usage
Posted by Kishore kumar <ki...@techdigita.in>.
How to create partitioned table without creating intermediate table?
simply..
On Tue, Jan 7, 2014 at 10:21 AM, Nitin Pawar <ni...@gmail.com>wrote:
> can you put your question in with an example?
>
>
> On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar <ki...@techdigita.in>wrote:
>
>> Hi Experts,
>>
>> As per this link
>>
>>
>> http://stackoverflow.com/questions/10276584/hive-table-partition-with-column-in-the-middle
>>
>> I understood that we can create the partitioned table when we have
>> already a non partitioned table, if it is correct, when we will use
>> partitioned by clause to create a new partitioned table.
>>
>> --
>>
>> *Kishore Kumar*
>>
>>
>
>
> --
> Nitin Pawar
>
--
*Kishore Kumar*
ITIM
Bidstalk - Ingenius Programmatic Platform
Email: kishore@techdigita.in| Tel: +1 415 423 8230 | Cell: +91 741 135
8658 | skype: kishore.alajangi | YM: kk_asn2004 | Twitter: __kishorealajangi
[image: Inline image 1]
Re: partitioned by usage
Posted by Nitin Pawar <ni...@gmail.com>.
can you put your question in with an example?
On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar <ki...@techdigita.in> wrote:
> Hi Experts,
>
> As per this link
>
>
> http://stackoverflow.com/questions/10276584/hive-table-partition-with-column-in-the-middle
>
> I understood that we can create the partitioned table when we have already
> a non partitioned table, if it is correct, when we will use partitioned by
> clause to create a new partitioned table.
>
> --
>
> *Kishore Kumar*
>
>
--
Nitin Pawar