Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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 ?
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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB