hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Channe <drah...@googlemail.com>
Subject Re: HiveServer2 with Hive CLI
Date Wed, 28 May 2014 11:03:09 GMT
You can try running derby in multi session mode. I did that , now I can use
Hive web interface and hive CLI simultaneously

On Wednesday, May 28, 2014, Amjad ALSHABANI <ashshabani@gmail.com> wrote:

> OOps, I forgot about that :)
>
> Thanks Dima to mention that.
>
> Actually where I m doing the test using Derby  but on the production
> machine we are using Postgres, so I hope that everything will go well when
> moving to production
>
> Thanx
>
>
> On Wed, May 28, 2014 at 10:52 AM, Dima Machlin <Dima.Machlin@pursway.com<javascript:_e(%7B%7D,'cvml','Dima.Machlin@pursway.com');>
> > wrote:
>
>>  You are using the default Derby metastore?
>>
>> There shouldn’t be any problem opening multiple connections to MySQL,
>> Oracle or Postgres.
>>
>>
>>
>>
>>
>> *From:* Amjad ALSHABANI [mailto:ashshabani@gmail.com<javascript:_e(%7B%7D,'cvml','ashshabani@gmail.com');>]
>>
>> *Sent:* Wednesday, May 28, 2014 11:42 AM
>> *To:* user@hive.apache.org<javascript:_e(%7B%7D,'cvml','user@hive.apache.org');>
>> *Subject:* HiveServer2 with Hive CLI
>>
>>
>>
>> Hello everybody,
>>
>>
>>
>> I m trying to start hiveserver2 to connect to hive via a PHP application,
>> but in the same time I would like to keep connecting Hive CLI ( hive> ) on
>> the same machine to execute some request manually. It seems that it is not
>> possilbe to do so   (the Hive thrift server seems to lock the metastore ).
>>
>>
>>
>> Is there a way to configure Hive and Hiveserver2 so they could both work
>> together on same machine.
>>
>> I ve seen that using beeline cli may solve this issue but I m not aiming
>> to move now to this solution since it is a production machine and moving to
>> new CLI would cost me some time
>>
>>
>>
>>
>>
>> Cheers
>>
>>
>>
>> Amjad
>>
>>
>>
>>
>>
>>
>>
>> ************************************************************************************
>> This footnote confirms that this email message has been scanned by
>> PineApp Mail-SeCure for the presence of malicious code, vandals &
>> computer viruses.
>>
>> ************************************************************************************
>>
>
>

Mime
View raw message