Re: Hive Druid SQL

2018-04-09 Thread Amit
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

Re: Hive Druid SQL

2018-04-09 Thread Ashutosh Chauhan
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

Re: Hive Druid SQL

2018-04-09 Thread Lefty Leverenz
> 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 ). - In Hive 2.3.0 the

Hive Druid SQL

2018-04-06 Thread Amit
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