1
$\begingroup$

I am trying to connect to Cloudera Impala via Mathematica, but so far I have not been able to do so. Has anyone ever done it?

I have been able to connect to it via R using the JDBC or ODBC interface and the Cloudera JAR driver.

$\endgroup$
  • $\begingroup$ You need to elaborate more in your question. Please share the code you are working on. Only good questions are likely to get great answers. Please edit your question to improve it. have you look into JDBCDrivers and Database Connectivity? $\endgroup$ – rhermans Oct 16 '15 at 10:51
  • $\begingroup$ Don't know much about Cloudera. It seems like a Hadoop management system? Mathematica has HadoopLink $\endgroup$ – Lost in Knowledge Oct 16 '15 at 13:17
  • $\begingroup$ Both thank you for your comments. Unfortunately i can't share any Mathematica code in this case since i do not know how to connect with Mathematica to Impala. If it does help i can share an R example script . I am using R right now as alternative. In R i am using a JDBC driver and the Cloudera JAR. Yes Cloudera is based on Hadoop however the database query i am using is not using directly the Hadoop interface. $\endgroup$ – bernddude Oct 16 '15 at 19:04
  • $\begingroup$ I did spent some additional time on this and i do believe i found a solution. Maybe it will help somebody else. Step 1: load the Cloudera Device Driver (cloudera.com/content/www/en-us/downloads/connectors/impala/jdbc/…). Step2: set the Classpath : Needs["JLink`"]; AddToClassPath[FileNameJoin[{Directory[], "Impala"}]]; Step 3: open a connection conn = OpenSQLConnection[ JDBC[ "com.cloudera.impala.jdbc4.Driver", "jdbc:impala://impalaelb.xyz.com:21050" ], "Name" -> "manualImpala", "Username" -> "" ] (sorry for the messy edit) $\endgroup$ – bernddude Oct 16 '15 at 23:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.