Access Apache Hive using ODBC driver
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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.
0 Commenti
Risposta accettata
Kojiro Saito
il 6 Ago 2020
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.
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);
Più risposte (0)
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!