Thanks Shashwat for your reply.
According your reply, I am getting all column data using
res.getInt/getString for 30 times.
Actually my doubt is in:
sql="select a,c,b from tbl_name";
res=stmt.executeQuery();---> CONTAINS 30 RECORDS
while(res.next())
{
sql="select d,e,f, from t1";
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 wrote:
>
> Hi,
> I am trying to implement a task in Hive like Stor
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.executeQuer
