Return-Path: Delivered-To: apmail-hive-user-archive@www.apache.org Received: (qmail 1746 invoked from network); 3 Dec 2010 09:31:43 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 Dec 2010 09:31:43 -0000 Received: (qmail 59683 invoked by uid 500); 3 Dec 2010 09:31:43 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 59363 invoked by uid 500); 3 Dec 2010 09:31:41 -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 59355 invoked by uid 99); 3 Dec 2010 09:31:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Dec 2010 09:31:40 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [203.199.18.82] (HELO mail1.impetus.co.in) (203.199.18.82) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Dec 2010 09:31:33 +0000 Received: from mail1.impetus.co.in ([192.168.100.28]) by mail1.impetus.co.in ([192.168.100.28]) with mapi; Fri, 3 Dec 2010 14:48:41 +0530 From: Vivek Mishra To: "user@hive.apache.org" Date: Fri, 3 Dec 2010 14:48:40 +0530 Subject: RE: Running a HiveClient with create external table HBase Thread-Topic: Running a HiveClient with create external table HBase Thread-Index: AcuSvyzQUqPnNWpyTL22GhIBp6KROQAC8u3A Message-ID: <1D695991EA0CFA4D934A3D5300C3DAB2C573E208EB@mail1.impetus.co.in> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_1D695991EA0CFA4D934A3D5300C3DAB2C573E208EBmail1impetusc_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_1D695991EA0CFA4D934A3D5300C3DAB2C573E208EBmail1impetusc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I found answer for this issue. It was related to metastore_db. Server and = client were on different metastore_db. Vivek From: Vivek Mishra Sent: Friday, December 03, 2010 1:48 PM To: user@hive.apache.org Subject: Running a HiveClient with create external table HBase Hi, Currently I am facing random behavior while trying to create a java client = for Hive hbase integration. Case: I am trying to create a hive table for existing HBase table. So i hav= e started hiveserver via /hive -service hiveserver. In logs I can see = it is printing by my sql with "CREATE EXTERNAL TABLE". But somehow that tab= le is not getting created in Hive. Interesting point is running the sql com= mand from command line with Hive is running fine. This behavior is random. Sometimes it shows me all created tables in Hive(w= hen I use "SHOW TABLES"). Does it have something to do with 'metastore_db'? Any idea? ________________________________ Register for Impetus Webinar on 'Building Highly Scalable and Flexible SaaS= Solutions' on Dec 10 (10:00 a.m. PT). Click http://www.impetus.com to know more. Follow us on www.twitter.com/imp= etuscalling. NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impe= tus does not represent, warrant and/or guarantee, that the integrity of thi= s communication has been maintained nor that the communication is free of e= rrors, virus, interception or interference. --_000_1D695991EA0CFA4D934A3D5300C3DAB2C573E208EBmail1impetusc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I found answer for this i= ssue. It was related to metastore_db.  Server and client were on diffe= rent metastore_db.

 <= /p>

Vivek

 <= /p>

From: Vivek Mi= shra
Sent: Friday, December 03, 2010 1:48 PM
To: user@hive.apache.org
Subject: Running a HiveClient with create external table HBase<= /o:p>

 

Hi,

Currently I am facing ran= dom behavior while trying to create a java client for Hive hbase integratio= n.

Case: I am trying to crea= te a hive table for existing HBase table. So i have started hiveserver via&= nbsp; /hive –service hiveserver.     In logs I ca= n see it is printing by my sql with “CREATE EXTERNAL TABLE”. But somehow t= hat table is not getting created in Hive. Interesting point is running the = sql command from command line with Hive is running fine.

 <= /p>

This behavior is random. = Sometimes it shows me all created tables in Hive(when I use “SHOW TAB= LES”).  

 <= /p>

Does it have  someth= ing to do with ‘metastore_db’?

 <= /p>

 <= /p>

Any idea?


Register for Impetus Webin= ar on ‘Building Highly Scalable and Flexible SaaS Solutions’ on= Dec 10 (10:00 a.m. PT).

Click http://www.impetus.com to know more. Follow us on www.twitter.com/imp= etuscalling.

NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant = and/or guarantee, that the integrity of this communication has been maintai= ned nor that the communication is free of errors, virus, interception or in= terference.
 --_000_1D695991EA0CFA4D934A3D5300C3DAB2C573E208EBmail1impetusc_--