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: > 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 > -- Nitin Pawar