Re: Any column search in HIVE

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

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

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