MATLAB: Access Apache Hive using ODBC driver

apache hiveDatabase Toolboxodbc

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.

Best Answer

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
Related Question