Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>ok cloudera is using version HIVE 0.10, that doesn't support remote login </p> <p>but you need to go around that bug, logging to the server that is getting the error the cloudera manager will tell you the ip </p> <p>1) create login in to the Server that fails to install HIVE 2) Create a $HADDOP_HOME</p> <pre><code>$HADOOP_HOME="/usr/lib/hadoop/" </code></pre> <p>3) INSTALL postgres in the server that fails</p> <pre><code>`$ sudo apt-get install postgresql` $ cat /etc/postgresql/9.1/main/postgresql.conf | grep -e listen -e standard_conforming_strings </code></pre> <p>modify this to lines in the file</p> <pre><code>listen_addresses = '*' standard_conforming_strings = off </code></pre> <p>You also need to configure authentication for your network in pg_hba.conf. You need to make sure that the PostgreSQL user that you will create in the next step will have access to the server from a remote host. To do this, add a new line into pg_hba.con that has the following information:</p> <pre><code>host &lt;database&gt; &lt;user&gt; &lt;network address&gt; &lt;mask&gt; password </code></pre> <p>Start PostgreSQL Server</p> <pre><code>$ sudo service postgresql start </code></pre> <p>Use chkconfig utility to ensure that your PostgreSQL server will start at a boot time:</p> <pre><code>chkconfig postgresql on </code></pre> <p>You can use the chkconfig utility to verify that PostgreSQL server will be started at boot time, for example:</p> <pre><code>chkconfig --list postgresql </code></pre> <p>Step 2: Install the Postgres JDBC Driver</p> <p>Before you can run the Hive metastore with a remote PostgreSQL database, you must configure a JDBC driver to the remote PostgreSQL database, set up the initial database schema, and configure the PostgreSQL user account for the Hive user.</p> <p>To install the PostgreSQL JDBC Driver on a Debian/Ubuntu system:</p> <p>Install libpostgresql-jdbc-java and symbolically link the file into the /usr/lib/hive/lib/ directory.</p> <pre><code>$ sudo apt-get install libpostgresql-jdbc-java $ ln -s /usr/share/java/postgresql-jdbc4.jar /usr/lib/hive/lib/postgresql-jdbc4.jar </code></pre> <p>Step 3: Create the metastore database and user account</p> <pre><code>bash# sudo –u postgres psql bash$ psql postgres=# CREATE USER hiveuser WITH PASSWORD 'mypassword'; postgres=# CREATE DATABASE metastore; postgres=# \c metastore; You are now connected to database 'metastore'. postgres=# \i /usr/lib/hive/scripts/metastore/upgrade/postgres/hive-schema-0.10.0.postgres.sql SET SET ... </code></pre> <p>Now you need to grant permission for all metastore tables to user hiveuser. PostgreSQL does not have statements to grant the permissions for all tables at once; you'll need to grant the permissions one table at a time. You could automate the task with the following SQL script:</p> <pre><code>bash# sudo –u postgres psql metastore=# \o /tmp/grant-privs metastore=# SELECT 'GRANT SELECT,INSERT,UPDATE,DELETE ON "' || schemaname || '"."' || tablename || '" TO hiveuser ;' metastore-# FROM pg_tables metastore-# WHERE tableowner = CURRENT_USER and schemaname = 'public'; metastore=# \o metastore=# \i /tmp/grant-privs </code></pre> <p>You can verify the connection from the machine where you'll be running the metastore service as follows:</p> <pre><code>psql –h myhost –U hiveuser –d metastore metastore=# </code></pre> <p>Step 4: Configure the Metastore Service to Communicate with the PostgreSQL Database</p> <p>change the IP of the AWS amazon master Server, or your master server, don't use DNS name</p> <pre><code>$find / -name hive-site.xml $nano /run/cloudera-scm-agent/process/27-hive-metastore-create-tables/hive-site.xml </code></pre> <p>in the File search for:</p> <pre><code>&lt;property&gt; &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt; &lt;value&gt;jdbc:postgresql://myhost/metastore&lt;/value&gt; &lt;/property&gt; </code></pre> <p>and change to the correct IP that is your Master Hadoop Server where u are running Cloudera Manager also every link in that file that is not correctly write to the hadoop master Cloudera manager connector , you will have to change to the correct IP</p> <p>after all this just get back to the autoinstall of cloudera manager and run again and it will be all good :)</p> <p>that it all the installation that you have to work around our contract cloudera support (that's their business) :)</p> <p>all this it works fine for me when i have this problem in de cloudera CDH 4.X with sorl</p> <p>Regards</p>
    singulars
    1. This table or related slice is empty.
    1. POCreating Hive Metastore Database Tables Error
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USraf10x
    1. USraf10x
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload