Support Questions
Find answers, ask questions, and share your expertise

hive/druid jdbc query failing with Error setting metadata result set: Metadata Result Set Error

hive/druid jdbc query failing with Error setting metadata result set: Metadata Result Set Error

Hi all, I have setup a new hive/druid stack and have it 'somewhat working'.

I have loaded data into druid and created an external hive table.

CREATE EXTERNAL TABLE wiki STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" = "wiki");

My goal is to be able to query druid from Hive via a 'jdbc' connection.

For my testing I am just using squirrel-sql client, with the HiveJDBC41.jar: jdbc41.HS2Driver, that I am pointing to hive-server on port 10000

I am able to run the following 'queries' without issue:

describe formatted wiki;

select count(*) from wiki;

But when I run this query.:

select * from wiki limit 100;

it fails with the error:

Error: [Cloudera][HiveJDBCDriver](500002) Error setting metadata result set: Metadata Result Set Error.SQLState:  HY000ErrorCode: 500002Error occurred in:select * from wiki limit 100

My setup includes 3 nodes, and for the metadata db I used derby.

Any other query run on this connection..will fail..(runs forever, or errors out immediately out of heap space).