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, > -- 丁桂涛