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