Select array fields from Hive table using JDBC

Question

I have a Hive table which has column with array data type. I am using JDBC to select rows from the table.

SELECT col1 FROM hive_table WHERE condition = 'condition'

After receiving the resultset, I am using res.getArray() method for the specific array field while looping through resultset.

Array arrayCol = res.getArray(1);

This is throwing a "Method not supported" error. Is it valid to use getArray() method for such queries executed on Hive table?

Kiyoshi Mizumaru · Accepted Answer · 2017-04-03 18:05:31Z

3

Unfortunately, no. You can see getArray() method is not implemented in ResultSet class for Hive JDBC. The actual class name is HiveBaseResultSet and the source code is located here.

Depends on what type of values the array holds, a client program need to decode its value by itself. For example, a column of type array<string> is encoded as a single String object like `["VALUE1","VALUE2",...,"VALUEN"]'. And we can use getString() method and freely re-construct any object of type Array<String> or List<String>.

answered Apr 3, 2017 at 18:05

Kiyoshi Mizumaru

462 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Srini · Accepted Answer · 2016-09-06 15:00:31Z

-1

You can loop though the result set and add the column values to arraylist in java. See example below assuming that your table column is of String type.

List<String> list = new ArrayList<String>();

     while (res.next()) {
                      list.add( res.getString(1));
                    }

answered Sep 6, 2016 at 15:00

Srini

769 bronze badges

1 Comment

mbgsuirp Over a year ago

Your reply is not relevant to the question. You have explained how to add values from multiple records to a list, but the question is why I am getting error when using getArray() method for array data types.

Collectives™ on Stack Overflow

Select array fields from Hive table using JDBC

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related