Database Table Selector with Arrays

KNIME Analytics Platform
1

I am attempting to connect a Database Table Selector to a Hive Connector. In Database Table Selector the statement "SELECT * FROM mytable" comes back with

Execute failed: Error while validating SQL query: Unregonized Thrift TTypeId value: ARRAY_TYPE

I can select individual columns fine as long as the columns do not contain arrays. I checked the Beginner's Luck and Cookbook resources, but found no hints.

How can I work with tables containing arrays in KNIME, in particular import them into workflows?

Regards,

Rowi

2

Hello Rowi,

reading of arrays is not supported by the open source Hive driver (see this post) as well as by the commercial Simba driver (see Simba documentation) which is provided by the big data vendors such as Cloudera and Hortonworks.

Bye

Tobias