- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
no output after running hive --service metastore
- Labels:
-
Apache Hive
-
HDFS
Created ‎08-19-2021 05:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, i have a problem with hive --service metastore when i excute it there is no output and no errors just starting hive metastore server
///hive-site.xml////
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://10.16.100.236/hive?createDatabaseIfNotExist=true</value>
<description>metadata is stored in a MySQL server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
<description>MySQL JDBC driver class</description>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>user name for connecting to mysql server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>Anem@2021</value>
<description>password for connecting to mysql server</description>
</property>
<property>
<name>datanucleus.autoCreateSchema</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://10.16.100.236:9083</value>
<description>Thrift server hostname and port</description>
</property>
</configuration>
Created ‎08-22-2021 05:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i've shared start hms with enabling debug mode please follow https://community.cloudera.com/t5/Support-Questions/hive-service-metastore/m-p/322941#M228976
if this resolve your issue please follow that case and accept this one .
Created ‎08-27-2023 05:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, I have the same issue.
- I ran "hive --service metastore -verbose". It says "start hive metastore on port 9083". I can see the listening on 9083 via netstate.
- I can enter hive env. but if I ran "hive> show databases;" It throws " hive exception....Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient". The Mysql database setting is correct. I can access the database via Workbench using the credentials as in the hive-site.xml.
Please could you guide? Thanks!
