Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive external table partitions with less than symbol ?


Copy link to this message
-
Re: Hive external table partitions with less than symbol ?
Matouk IFTISSEN 2013-11-04, 08:34
Hello
You can use concat function or case to do this like:
Concat ('/data1/customer/', id)
.....
Where id <1000

Etc..
Hope this help you ;)
Le 3 nov. 2013 23:51, "Raj Hadoop" <[EMAIL PROTECTED]> a écrit :

> All,
>
> I want to create partitions like the below and create a hive external
> table. How can i do that ?
>
> /data1/customer/id<1000
> /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.
>
> Thanks,
> Raj
>