Partitions in Hive

2014-03-06 Thread nagarjuna kanamarlapudi
Hi, I have a table with 3 columns in hive. I want that table to be partitioned based on first letter of column 1. How do we define such partition condition in hive ? Regards, Nagarjuna K

Re: Partitions in Hive

2014-03-06 Thread Nitin Pawar
partition in hive is done on the column value and not on the sub portion of column value. If you want to separate data based on the first character then create another column to store that value On Thu, Mar 6, 2014 at 11:42 PM, nagarjuna kanamarlapudi nagarjuna.kanamarlap...@gmail.com wrote: