Access Apache Hive using ODBC driver

2020 8 5
1 个回答
回答已采纳
更新时间：2020 8 6
8 次查看（30 天）

0 个投票

Is it possible to send SQL query to Apache Hive through ODBC and get the result in Matlab workspace? In Database toolbox, all examples are RDBMS,not Hive in HDFS. Thank you for your help in advance.

请先登录，再回答此问题。

 采纳的回答

Kojiro Saito
Kojiro Saito 2020-8-6

0 个投票

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.
First, 64 bit ODBC Driver is requied.
Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive
datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);
Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by