Re: Any column search in HIVE

2012-04-30 Thread Nitin Pawar
;> Thanks & Regards,**** >> >> *Rinku Garg* >> >> >> >> *From:* Nitin Pawar [mailto:nitinpawar...@gmail.com] >> *Sent:* 30 April 2012 12:18 >> *To:* user@hive.apache.org >> *Subject:* Re: Any column search in HIVE >> >> *

Re: Any column search in HIVE

2012-04-30 Thread Ashwanth Kumar
itin Pawar [mailto:nitinpawar...@gmail.com] > *Sent:* 30 April 2012 12:18 > *To:* user@hive.apache.org > *Subject:* Re: Any column search in HIVE > > ** ** > > you can write your query in a file > > ** ** > > then execute the query like hive -f hive.hql >

RE: Any column search in HIVE

2012-04-30 Thread Garg, Rinku
Sent: 30 April 2012 12:18 To: user@hive.apache.org Subject: Re: Any column search in HIVE you can write your query in a file then execute the query like hive -f hive.hql > some_output_file Thanks, Nitin On Mon, Apr 30, 2012 at 11:28 AM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wrot

Re: Any column search in HIVE

2012-04-29 Thread Vinod Singh
Also look at INSERT OVERWRITE LOCAL DIRECTORY feature with usage of concat function to create CSV output. Thanks, Vinod On Mon, Apr 30, 2012 at 12:18 PM, Nitin Pawar wrote: > you can write your query in a file > > then execute the query like hive -f hive.hql > some_output_file > > Thanks, > Niti

Re: Any column search in HIVE

2012-04-29 Thread Nitin Pawar
you can write your query in a file then execute the query like hive -f hive.hql > some_output_file Thanks, Nitin On Mon, Apr 30, 2012 at 11:28 AM, Garg, Rinku wrote: >Hi All, > > We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also > loaded a large number of CSV files

RE: Any column search in HIVE

2012-04-29 Thread Garg, Rinku
Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now we want to store the hive query output result to an CSV file. Any help is appreciated. Thanks Rinku Garg _ The

Re: Any column search in HIVE

2012-04-19 Thread shashwat shriparv
Check out these links : http://stackoverflow.com/questions/2763112/opening-lucene-index-stored-in-hdfs http://ieeexplore.ieee.org/xpl/login.jsp?tp=&arnumber=5575646&url=http%3A%2F%2Fieeexplore.ieee.org%2Fxpls%2Fabs_all.jsp%3Farnumber%3D5575646 http://www.drdobbs.com/article/print?articleID=226300

Any column search in HIVE

2012-04-19 Thread Garg, Rinku
Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now we want to search for an keyword in any of the columns of a particular table. Any link/thread will be helpful. Thanks & R