> Does it mean, I cannot use SQLserver as Druid metastore for Hive to work with Druid?
Apparently so. - In Hive 2.2.0 *hive.druid.metadata.db.type* was introduced with values "mysql" and "postgres" (HIVE-15277 <https://issues.apache.org/jira/browse/HIVE-15277>). - In Hive 2.3.0 the value "postgres" was changed to "postgresql" ( HIVE-15809 <https://issues.apache.org/jira/browse/HIVE-15809>). - In Hive 3.0.0 (upcoming release) the value "derby" is added (HIVE-18196 <https://issues.apache.org/jira/browse/HIVE-18196>). -- Lefty On Fri, Apr 6, 2018 at 10:09 AM Amit <ami...@gmail.com> wrote: > Hive Druid Integration: > I have Hive and Druid working independently. > But having trouble connecting the two together. > I don't have Hortonworks. > > I have Druid using sqlserver as metadata store database. > > When I try setting this property in Beeline, > > set hive.druid.metadata.db.type=sqlserver; > > I get a message: > Error: Error while processing statement: 'SET > hive.druid.metadata.db.type=sqlser ver' FAILED in > validation : Invalid value.. expects one of patterns [mysql, postgres]. > (state=42000,code=1) > > Does it mean, I cannot use SQLserver as Druid metastore for Hive to work > with Druid? > > > >