Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CD0AF10C61 for ; Wed, 28 May 2014 11:03:35 +0000 (UTC) Received: (qmail 40046 invoked by uid 500); 28 May 2014 11:03:34 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 39966 invoked by uid 500); 28 May 2014 11:03:34 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 39958 invoked by uid 99); 28 May 2014 11:03:34 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 May 2014 11:03:34 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of drahulc@googlemail.com designates 209.85.192.44 as permitted sender) Received: from [209.85.192.44] (HELO mail-qg0-f44.google.com) (209.85.192.44) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 May 2014 11:03:30 +0000 Received: by mail-qg0-f44.google.com with SMTP id i50so17407007qgf.31 for ; Wed, 28 May 2014 04:03:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=PnIhmyAE7lw2RetkBO+KIMH/bOUQvAF+pRYoxYpeo+k=; b=cpO316e/LAS6I0DpRXJhwZfSX4BXjShlg6x6iUHW+anNFy2tcLm9M2YPo5gFy5ykm/ bco4pIptZMu8jtKL7PckWm1gWawOjBDf+Ujhgn0qaeMcF/jyo7EAbQOdvckzLmAzIg+h ouvYY3t6rpg0SdbfXoB2CSjVNBjd0hZKTGM0fZ8d50BDkKdakOQRP1gmwkrWK4xTWOy+ S/Q7ElxI3QIKS1Be8wboqnAPSOp9W/QDto/qVF8YV9L3/SfoX/cZEpNXR3L1Vuz93Nrl pc0aKJmmG/1YDsAcLjmEmIjohpo9+f4V1ssYxvfBdxn9I5BeLm5XppHMR7Cg6W8AhXp0 fXoA== MIME-Version: 1.0 X-Received: by 10.140.49.76 with SMTP id p70mr48562254qga.86.1401274989462; Wed, 28 May 2014 04:03:09 -0700 (PDT) Received: by 10.140.91.99 with HTTP; Wed, 28 May 2014 04:03:09 -0700 (PDT) In-Reply-To: References: <199112FAF2ED6C45A4B7D703BEC6FF0A23363215@Mail-srv.pursway.local> Date: Wed, 28 May 2014 07:03:09 -0400 Message-ID: Subject: Re: HiveServer2 with Hive CLI From: Rahul Channe To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=001a11370a34fac9f004fa73c142 X-Virus-Checked: Checked by ClamAV on apache.org --001a11370a34fac9f004fa73c142 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 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 whe= n > moving to production > > Thanx > > > On Wed, May 28, 2014 at 10:52 AM, Dima Machlin > > wrote: > >> You are using the default Derby metastore? >> >> There shouldn=E2=80=99t be any problem opening multiple connections to M= ySQL, >> 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 n= ot >> 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. >> >> ************************************************************************= ************ >> > > --001a11370a34fac9f004fa73c142 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You can try running derby in multi session mode. I did that , now I can use= Hive web interface and hive CLI simultaneously=C2=A0

O= n 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 =C2=A0but on the production m= achine we are using Postgres, so I hope that everything will go well when m= oving to production=C2=A0

Thanx


On Wed, May 28, 2014 at 10:52 AM, Dima Machlin <Dima.Machlin@pursway.com&= gt; wrote:

You are using the default= Derby metastore?

There shouldn=E2=80=99t b= e any problem opening multiple connections to MySQL, Oracle or Postgres.=

=C2=A0

=C2=A0

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

=C2=A0

Hello everybody,

=C2=A0

I m trying to start hiveserver2 to connect to hive v= ia 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 =C2=A0 (the Hive thrift server seems to lock the metastore ).=

=C2=A0

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 issu= e 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

=C2=A0

=C2=A0

Cheers

=C2=A0

Amjad

=C2=A0




***************************************************************************= *********
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & compu= ter viruses.
***************************************************************************= *********


--001a11370a34fac9f004fa73c142--