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).