Re: Hive Druid SQL

[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 integration is a big effort to do i
would guess.



On Tue, Apr 10, 2018 at 12:46 AM, Ashutosh Chauhan 
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 
> 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
>>).
>>- In Hive 2.3.0 the value "postgres" was changed to "postgresql" (
>>HIVE-15809 ).
>>- In Hive 3.0.0 (upcoming release) the value "derby" is added (
>>HIVE-18196 ).
>>
>> -- Lefty
>>
>>
>> On Fri, Apr 6, 2018 at 10:09 AM Amit  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=sqlserver' 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?
>>>
>>>
>>>
>>>
>

Re: Hive Druid SQL

[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 Leverenz 
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
>).
>- In Hive 2.3.0 the value "postgres" was changed to "postgresql" (
>HIVE-15809 ).
>- In Hive 3.0.0 (upcoming release) the value "derby" is added (
>HIVE-18196 ).
>
> -- Lefty
>
>
> On Fri, Apr 6, 2018 at 10:09 AM Amit  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?
>>
>>
>>
>>

Re: Hive Druid SQL

[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 value "postgres" was changed to "postgresql" (
   HIVE-15809 ).
   - In Hive 3.0.0 (upcoming release) the value "derby" is added (HIVE-18196
   ).

-- Lefty


On Fri, Apr 6, 2018 at 10:09 AM Amit  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=sqlserver' 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?
>
>
>
>