Re: Hive external table partitions with less than symbol ?

2013-11-04 Thread Raj Hadoop
Hi - I have this doubt. Why do i need to use an INSERT INTO . can I just create hdfs directories and map it to a hive external table setting the location of the hdfs directories. will this work ? please advise. Thanks, Raj On Monday, November 4, 2013 8:34 AM, Matouk IFTISSEN wrot

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Cynthia Smith
great welcome love eme On Sunday, November 3, 2013 9:06 PM, Carl Steinbach wrote: The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache Hive project. Please join me in congratulating Xuefu! Thanks. Carl

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Jason Dere
Xuefu, congrats! On Nov 4, 2013, at 9:53 AM, Vaibhav Gumashta wrote: > Congrats Xuefu! > > > On Mon, Nov 4, 2013 at 9:17 AM, Prasad Mujumdar wrote: > >> Congratulations Xuefu! >> >> thanks >> Prasad >> >> >> >> On Sun, Nov 3, 2013 at 8:06 PM, Carl Steinbach >> wrote: >> >>> The Apache

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Vaibhav Gumashta
Congrats Xuefu! On Mon, Nov 4, 2013 at 9:17 AM, Prasad Mujumdar wrote: >Congratulations Xuefu! > > thanks > Prasad > > > > On Sun, Nov 3, 2013 at 8:06 PM, Carl Steinbach >wrote: > > > The Apache Hive PMC has voted to make Xuefu Zhang a committer on the > Apache > > Hive project. > > > > Ple

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Prasad Mujumdar
Congratulations Xuefu! thanks Prasad On Sun, Nov 3, 2013 at 8:06 PM, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache > Hive project. > > Please join me in congratulating Xuefu! > > Thanks. > > Carl >

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Jarek Jarcec Cecho
Excellent job Xuefu, congratulations! Jarcec On Sun, Nov 03, 2013 at 08:06:07PM -0800, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache > Hive project. > > Please join me in congratulating Xuefu! > > Thanks. > > Carl signature.asc Descriptio

Re: Hive external table partitions with less than symbol ?

2013-11-04 Thread Matouk IFTISSEN
Yes it is possible: hadoop fs -mkdir /hdfs_path/'cust_id>1000' I tested it and works, then you can store data in this directory . for concat function you do simple: insert into your_table_partionned PARTITION (path_xxx) select attr,id, concat ('/data1/customer/', id) as path_xxx from your_table

Re: Hive external table partitions with less than symbol ?

2013-11-04 Thread Raj Hadoop
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 wrote: Hello You can u

Re: Hive external table partitions with less than symbol ?

2013-11-04 Thread Matouk IFTISSEN
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" a écrit : > All, > > I want to create partitions like the below and create a hive external > table. How can i do that ? >

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

2013-11-04 Thread Thejas Nair
Congrats Xuefu! On Sun, Nov 3, 2013 at 11:11 PM, Mohammad Islam wrote: > Congrats Xuefu! > > --Mohammad > > > On Sunday, November 3, 2013 9:07 PM, "hsubramani...@hortonworks.com" > wrote: > Congrats Xuefu! > > Thanks, > Hari > > On Nov 3, 2013, at 8:28 PM, Gunther Hagleitner > wrote: > > Congra