Fwd: Queries : partitioning

2014-09-22 Thread Dhaval Patel
-- Forwarded message --
From: Dhaval Patel er.dcpa...@gmail.com
Date: 22/09/2014 7:33 pm
Subject: Queries : partitioning
To: user@hive.apache.org
Cc:

Hey folks,
1) Hive table can be partitioned by column, is there any way to partition
by range?
2) while loading data into hive table we specify the partition column
value. Is there any way to auto partition the data, rather than we specify
logic to partition?

As i am very new to hive, please suggest the way.

Thanks,


Re: Queries : partitioning

2014-09-22 Thread 丁桂涛(桂花)
Hi Dhaval,

1. you can add a new partitioned column based on the range of you
interested column.

2.  try to use dynamic partition.

https://cwiki.apache.org/confluence/display/Hive/DynamicPartitions

On Tue, Sep 23, 2014 at 10:49 AM, Dhaval Patel er.dcpa...@gmail.com wrote:

 -- Forwarded message --
 From: Dhaval Patel er.dcpa...@gmail.com
 Date: 22/09/2014 7:33 pm
 Subject: Queries : partitioning
 To: user@hive.apache.org
 Cc:

 Hey folks,
 1) Hive table can be partitioned by column, is there any way to partition
 by range?
 2) while loading data into hive table we specify the partition column
 value. Is there any way to auto partition the data, rather than we specify
 logic to partition?

 As i am very new to hive, please suggest the way.

 Thanks,




-- 
丁桂涛