Mailing-List: contact common-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: common-user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of hadoophive@gmail.com
 designates 209.85.212.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAFztyZgZ8oPQ8ahBJ6ZfPNa5wLU5Dmj+7pS6=72BcCZOfZ74Gg@mail.gmail.com>
References: 
 <CAFztyZhRBDTkpk1wwSqkkr-xDCSdJuY+ah97U2ibz6OLUxSr4g@mail.gmail.com>
	<B3B9325A15474BE39C373049F261F6FA@hortonworks.com>
	<CAFztyZgZ8oPQ8ahBJ6ZfPNa5wLU5Dmj+7pS6=72BcCZOfZ74Gg@mail.gmail.com>
Date: Fri, 10 Feb 2012 11:03:46 +0530
Message-ID: 
 <CADtHtMy+3hcqSiwi7gPowr92gO3Lboq+i-p0=_LB8+wZ2yCxDQ@mail.gmail.com>
Subject: Re: How to setup Hive on a single node ?
From: hadoop hive <hadoophive@gmail.com>
To: common-user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=0016e6de1795fb2ed704b895782d

--0016e6de1795fb2ed704b895782d
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

hey Lac,

its showing like you dont have DBS table in metastore(derby or mysql),
actually you have to again install the hive or again build hive through ANT=
.

Check you metastore(that DBS is exists or not)

Thanks & regards
Vikas Srivastava

On Fri, Feb 10, 2012 at 8:33 AM, Lac Trung <trungnb3535@gmail.com> wrote:

> Thanks for your reply !
>
> I think i installed Hadoop correctly because i run wordcount example i ha=
ve
> correct output. But i didn't know how to install Hive, so i installed Hiv=
e
> via https://cwiki.apache.org/confluence/display/Hive/GettingStartedinclud=
e
> installed Hadoop 20.0 (may be not install on single node)  ^_^
> I configured like the instruction in hive-site.xml but error like this :
>
> ------------------------------------
>
> hive> show tables;
> FAILED: Error in metadata: javax.jdo.JDODataStoreException: Required
> table missing : "`DBS`"
> in Catalog "" Schema "".
> DataNucleus requires this table to perform its persistence operations.
> Either your MetaData
> is incorrect,
> or you need to enable "datanucleus.autoCreateTables"
> NestedThrowables:
> org.datanucleus.store.rdbms.exceptions.MissingTableException: Required
> table missing : "`DBS`"
> in Catalog "" Schema "".
> DataNucleus requires this table to perform its persistence operations.
> Either your MetaData
> is incorrect,
> or you need to enable "datanucleus.autoCreateTables"
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> ----------------------------------------
>
> I didn't know what to do so I reinstall Ubuntu to install from start and
> hope that someone can show me the way to do.
>
> --
> L=E1=BA=A1c Trung
>

--0016e6de1795fb2ed704b895782d--