You can use concat function or case to do this like:
Concat ('/data1/customer/', id)
Where id <1000
Hope this help you ;)
Le 3 nov. 2013 23:51, "Raj Hadoop" <[EMAIL PROTECTED]> a écrit :
> I want to create partitions like the below and create a hive external
> table. How can i do that ?
> /data1/customer/id>1000 and id < 2000
> /data1/customer/id >2000
> Is this possible ( < and > symbols in folders ?)
> My requirement is to partition the hive table based on some customer id's.