Hi Amit, Yes only mysql and postgres are supported for druid metadata storage. Thats because Druid only supports these. You mentioned that Hive and Druid are working independently. Which metadata storage your Druid install is using?
Thanks, Ashutosh On Mon, Apr 9, 2018 at 7:39 PM, Lefty Leverenz <[email protected]> wrote: > > 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 <[email protected]> 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? >> >> >> >>
