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