hive元数据mysql

CREATE DATABASE hive_metadata;

USE hive_metadata;

CREATE TABLE metastore (
    id INT PRIMARY KEY,
    table_name VARCHAR(255),
    column_name VARCHAR(255)
);

-- 在 Hive 配置文件中指定 MySQL 连接信息
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://your_mysql_host:3306/hive_metadata?createDatabaseIfNotExist=true</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>your_username</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>your_password</value>
</property>