Home > other >  Hive metastore is not connected to the specified mysql urgent!!!!!!
Hive metastore is not connected to the specified mysql urgent!!!!!!

Time:09-27

Installed the hive, mysql, start the hive to perform the show databases only see a default database, didn't see me in the mysql database, feel the hive login metastore is not my specified mysql, which help to have a look at the great god, thank you very much!!!!!!

Hive> show databases;
OK
The default
Time seems: 0.031 seconds, Fetched: 1 row (s)


mysql> Show the databases;
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| Database |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| information_schema |
| hive |
| mysql |
| performance_schema |
| test |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +

================================================================================
XML hive - site.
================================================================================
<? The XML version="1.0"?>
<? XML - stylesheet type="text/XSL" href="https://bbs.csdn.net/topics/configuration.xsl"?>
Licensed to the Apache Software Foundation (ASF) under one or more
Contributor license agreements. See the NOTICE file distributed with
This work for additional information regarding copyright ownership.
The ASF licenses this file to You under The Apache License, Version 2.0
(the "License"); You may not use this file except in the compliance with
The License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
Distributed under the License is distributed on an "AS is" BASIS,
WITHOUT WARRANTIES OR the CONDITIONS OF ANY KIND, either express OR implied.
See the License for the specific language governing permissions and
Limitations under the License.
-->






Hive. Metastore. Uris
Thrift://zdemsser3:9083 & lt;/value>
Thrift URI for the remote metastore. 2 by metastore client to connect to remote metastore. & lt;/description>



Javax.mail. Jdo. Option. ConnectionURL
JDBC: mysql://10.1.144.37:3306/hive? CreateDatabaseIfNotExist=true
The JDBC connect string for a JDBC metastore



Javax.mail. Jdo. Option. ConnectionDriverName
Com. Mysql. JDBC. Driver
JDBC Driver class name for a metastore



Javax.mail. Jdo. Option. ConnectionUserName
Hive
The username to use against metastore database



Javax.mail. Jdo. Option. ConnectionPassword
Hive
The password to use against metastore database




Hive. Metastore. Warehouse. Dir
/user/hive/warehouse
The location of the default database for warehouse



============================================================================
  • Related