Hi Thanks for checking. Our Druid installation has Sql Server as metastore, and it is using Azure for Deep storage. It is working fine. That is why i was wondering why Hive would need MySQL or Postgres only for Druid integration.
I'm using Hive 2.2.0 Now dismantling Druid just for Hive integration is a big effort to do i would guess. On Tue, Apr 10, 2018 at 12:46 AM, Ashutosh Chauhan <hashut...@apache.org> wrote: > 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 <leftylever...@gmail.com> > 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 <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? >>> >>> >>> >>> >