You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Amjad ALSHABANI <as...@gmail.com> on 2014/05/28 10:41:56 UTC
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
Re: HiveServer2 with Hive CLI
Posted by Rahul Channe <dr...@googlemail.com>.
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 <as...@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.
>>
>> ************************************************************************************
>>
>
>
Re: HiveServer2 with Hive CLI
Posted by Amjad ALSHABANI <as...@gmail.com>.
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 <Di...@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]
> *Sent:* Wednesday, May 28, 2014 11:42 AM
> *To:* 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.
>
> ************************************************************************************
>
RE: HiveServer2 with Hive CLI
Posted by Dima Machlin <Di...@pursway.com>.
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]
Sent: Wednesday, May 28, 2014 11:42 AM
To: 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.
************************************************************************************