Hi,
I am trying to implement a task in Hive like Stored Procedure in SQL.
In SQL, when we write cursor, first we execute select query and then
fetching the records we perform some actions.
Likely I have fired a select query as actions in Hive. sql="select a,c,b from tbl_name"; res=stmt.executeQuery(); -----------> CONTAINS 30 RECORDS while(res.next()) { sql="insert into tabl2..... "; rs1=stmt.executeQuery(); like wise many queries are there.....
. . . .. }
As my select query contans 30 records but when I execute it my while(res.next()) execute only once. I didn't get any kind of errors/exceptions
But instead of queries I just try to display field to check whether it is fetching or not then it is working fine.. (while loop contains only System.out.println statements)
sql="select * from tbl_name"; res=stmt.executeQuery(sql);
while(res.next()) { S.O.P.("fields : "+res.getString(0)); }
Why it is happening I am not getting. Is anything I am doing wrong?
-- Regards, Bhavesh Shah
Bhavesh Shah's gravatar image asked Mar 16 2012 at 05:47 in Hive-User by Bhavesh Shah

1 Answers

S.O.P.("fields : "+res.getString(0)); according type of your fields you can acc more res.getint(1) res.getString(2) like this up to 30 so this will give all the columns you needed.
On Fri, Mar 16, 2012 at 11:17 AM, Bhavesh Shah > Hi, > I am trying to implement a task in Hive like Stored Procedure in SQL. > In SQL, when we write cursor, first we execute select query and then > fetching the records we perform some actions. > > Likely I have fired a select query as actions in Hive. > sql="select a,c,b from tbl_name"; > res=stmt.executeQuery(); -----------> CONTAINS 30 RECORDS > while(res.next()) > { > sql="insert into tabl2..... "; > rs1=stmt.executeQuery(); > like wise many queries are there..... > > . > . > . > .. > } > > As my select query contans 30 records but when I execute it my > while(res.next()) execute only once. > I didn't get any kind of errors/exceptions > > But instead of queries I just try to display field to check whether it is > fetching or not > then it is working fine.. (while loop contains only System.out.println > statements) > > sql="select * from tbl_name"; > res=stmt.executeQuery(sql); > > while(res.next()) > { > S.O.P.("fields : "+res.getString(0)); > } > > Why it is happening I am not getting. Is anything I am doing wrong? > > > > > > > -- > Regards, > Bhavesh Shah > >
-- Shashwat Shriparv
+91-9663531241 +91-990059620
shashwat shriparv's gravatar image answered Mar 17 2012 at 10:56 by shashwat shriparv