Hive + Druid Integration accessing using ODBC gives error

Hi All,

I am trying to Integrate Druid with Hive for SQL interface on Druid. I was able to do that and create an external table source on top of Druid.

I am also able to run the hive queries using beeline client over hiveserver2.

However when I am trying to connect Power BI using hive ODBC to hiveserver2 to fetch the data , I get below error.

DataSource.Error: ODBC: ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: ‘1’ error message: ‘Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.ClassNotFoundException Class org.apache.hadoop.hive.druid.serde.DruidSerDe not found’.



DataSourcePath=dsn=Sample Hortonworks Hive DSN


I am using Hortonworks Sandbox HDP 2.6.2 to connect to Druid broker which is installed on different server



Hi Atul,

You might find more luck in asking the Apache Hive mailing list. The Druid/Hive adapter code lives in that project.