How can i use concat function? I did not get it. Can you please elaborate. 

My requirement is to create a HDFS directory like 
(cust_id>1000 and cust_id<2000)


and map this to a Hive External table.

can i do that?



On Monday, November 4, 2013 3:34 AM, Matouk IFTISSEN 
<matouk.iftis...@ysance.com> wrote:
 
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" <hadoop...@yahoo.com> 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

Reply via email to