hive集成mysql作为元数据,使用MySQL作为Metastore从HIVE查询元数据

I am looking for a way to query the metadata of my HIVE data with a HiveQL command.

I configured a MySQL metastore, but it is necessary to query the metadata via HIVE command because then I want to access the data with ODBC connection to the HIVE system.

Thanks in advanced.

解决方案

You can do it currently using Hive JDBC StorageHandler: https://github.com/qubole/Hive-JDBC-Storage-Handler

Example of table creation from their page:

DROP TABLE HiveTable;

CREATE EXTERNAL TABLE HiveTable(

id INT,

id_double DOUBLE,

names STRING,

test INT

)

STORED BY 'org.apache.hadoop.hive.jdbc.storagehandler.JdbcStorageHandler'

TBLPROPERTIES (

"mapred.jdbc.driver.class"="com.mysql.jdbc.Driver",

"mapred.jdbc.url"="jdbc:mysql://localhost:3306/rstore",

"mapred.jdbc.username"="root",

"mapred.jdbc.input.table.name"="JDBCTable",

"mapred.jdbc.output.table.name"="JDBCTable",

"mapred.jdbc.password"="",

"mapred.jdbc.hive.lazy.split"= "false"

);

I tested, it works fine with MySQL. And FilterPushDown also works.