Re: Execute query file

2012-04-19 Thread Edward Capriolo
Essentially just take the file and split on ';' . The only acception is the CLI allows ; to be escaped by \; Edward On Thu, Apr 19, 2012 at 11:17 AM, Chandan B.K wrote: > Hello users, > >                  Thanks Bhavesh, well as Bhavesh said, I completely agree. > For that i need to parse the fi

Re: Execute query file

2012-04-19 Thread Chandan B.K
Hello users, Thanks Bhavesh, well as Bhavesh said, I completely agree. For that i need to parse the file, extract the file line-by-line and execute it. If $bin/hive -f '/path/to/query/file' can execute a entire file without any overhead(manual parsing etc), there should be some wa

Re: Execute query file

2012-04-17 Thread Bhavesh Shah
Hi Chandan, Execute your queries which are in your file like JDBC operations. Like: sql="insert overwrite table ABC select * from TblA"; stmt.executeUpdate(sql); Like wise you can do it for all your queries. It will execute one by one and you will get the result. On Tue, Apr 17, 2012 at 4:32 PM,