Hi,
I have a UDF that returns a list and another one that returns a list of
lists. I am not sure how to read the results back as lists in JDBC/hiveserver1.
All I can do is
while (rset.next()) {
String fld = rset.getString(2);
}
This returns the field as a string like :
"[[John,Jack,Jill],[Smith,Hill,Smith],[25,26,27],[NULL],[1,4,5]]"
Is there a way to read the data as a list instead of a String ?
I tried rset.getArray(2). But got an error "unsupported function". I am using
hive 0.9.
Or, is there a way to convert this to a list in Java without parsing this
string ? I saw some Groovy code online while seem to do something like that.
But would need this in Java/Python.
Would be helpful if someone has any ideas/pointers.
Thanks,
Murali.
