You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by Lac Trung <tr...@gmail.com> on 2012/02/10 03:28:42 UTC
How to setup Hive on a single node ?
Hi everyone !
I try to setup Hive on single node to configure and use before i setup on
multi node.
First, i install Hadoop on single node (
http://www.michael-noll.com/tutorials/running-hadoop-on-ubuntu-linux-single-node-cluster/).
Then, i setup Hive (https://cwiki.apache.org/confluence/display/Hive/Home).
But that way has many errors and quite difficult to configure.
If someone has experience in it, please tell me the steps to setup
correctly.
Thanks so much !
--
Lạc Trung
Re: How to setup Hive on a single node ?
Posted by Lac Trung <tr...@gmail.com>.
Thanks for your reply !
I've already installed Hive correctly.
First, i installed
CDH3<https://ccp.cloudera.com/display/CDHDOC/CDH3+Installation>,
unfortunately i use Ubuntu Oneiric but CDH don't support Oneiric, so, i
download and install the CDH3 package for Lucid system.
Then, i installed Hadoop via the following command : ... *sudo apt-get
install hadoop-0.20 *
Next, i installed Hive via the following command : ... *sudo apt-get
install hadoop-hive*
**
After that, i installed
Mysql<http://ariejan.net/2007/12/12/how-to-install-mysql-on-ubuntudebian>
Finally, i configure
Hive<https://ccp.cloudera.com/display/CDHDOC/Hive+Installation>and
some
variables<https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration>
(conf/hive-site.xml)
+ Hive - Hadoop : hadoop.bin.path, hadoop.config.dir
+ Hive - Mysql : hive.metastore.warehouse.dir
Now, it run correctly.
Thanks so much !
2012/2/9 hadoop hive <ha...@gmail.com>
> 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 <tr...@gmail.com> wrote:
>
> > Thanks for your reply !
> >
> > I think i installed Hadoop correctly because i run wordcount example i
> have
> > correct output. But i didn't know how to install Hive, so i installed
> Hive
> > via
> https://cwiki.apache.org/confluence/display/Hive/GettingStartedinclude
> > 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ạc Trung
> >
>
--
Lạc Trung
20083535
Re: How to setup Hive on a single node ?
Posted by hadoop hive <ha...@gmail.com>.
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 <tr...@gmail.com> wrote:
> Thanks for your reply !
>
> I think i installed Hadoop correctly because i run wordcount example i have
> correct output. But i didn't know how to install Hive, so i installed Hive
> via https://cwiki.apache.org/confluence/display/Hive/GettingStartedinclude
> 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ạc Trung
>
Re: How to setup Hive on a single node ?
Posted by Lac Trung <tr...@gmail.com>.
Thanks for your reply !
I think i installed Hadoop correctly because i run wordcount example i have
correct output. But i didn't know how to install Hive, so i installed Hive
via https://cwiki.apache.org/confluence/display/Hive/GettingStarted include
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ạc Trung
Re: How to setup Hive on a single node ?
Posted by Rohit <ro...@hortonworks.com>.
Hi Lac,
Could you provide some more information on what kind of errors you are encountering?
Did the Hadoop setup install correctly? If so, how did you try to install Hive? Once you have a single node setup of Hadoop running, you can install Hive by building from source:
https://cwiki.apache.org/confluence/display/Hive/AdminManual+Installation
Then you will want to make sure the hive configuration files are correctly set up (hive-site.xml).
Thanks,
Rohit
Rohit Bakhshi
www.hortonworks.com (http://www.hortonworks.com/)
On Thursday, February 9, 2012 at 6:28 PM, Lac Trung wrote:
> Hi everyone !
>
> I try to setup Hive on single node to configure and use before i setup on
> multi node.
>
> First, i install Hadoop on single node (
> http://www.michael-noll.com/tutorials/running-hadoop-on-ubuntu-linux-single-node-cluster/).
> Then, i setup Hive (https://cwiki.apache.org/confluence/display/Hive/Home).
> But that way has many errors and quite difficult to configure.
>
> If someone has experience in it, please tell me the steps to setup
> correctly.
>
> Thanks so much !
>
> --
> Lạc Trung
>
>