Are you running the Spark Thrift JDBC/ODBC server? In my environment I have a Hive Metastore server and the Spark Thrift Server pointing to the Hive Metastore.
I use the Hive beeline tool for testing. With this setup I'm able to use Tableau connecting to Hive tables and using Spark SQL as the engine. Regards, Ricardo On Thu, Jan 14, 2016 at 11:15 PM, sdevashis [via Apache Spark User List] < ml-node+s1001560n25976...@n3.nabble.com> wrote: > Hello Experts, > > I am getting started with Hive with Spark as the query engine. I built the > package from sources. I am able to invoke Hive CLI and run queries and see > in Ambari that Spark application are being created confirming hive is using > Spark as the engine. > > However other than Hive CLI, I am not able to run queries from any other > clients that use the JDBC to connect to hive through thrift. I tried > Squirrel, Aginity Netezza workbench, and even Hue. > > No yarn applications are getting created, the query times out after > sometime. Nothing gets into /tmp/user/hive.log Am I missing something? > > Again I am using Hive on Spark and not spark SQL. > > Version Info: > Spark 1.4.1 built for Hadoop 2.4 > > > Thank you in advance for any pointers. > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://apache-spark-user-list.1001560.n3.nabble.com/Using-JDBC-clients-with-Spark-on-Hive-tp25976.html > To start a new topic under Apache Spark User List, email > ml-node+s1001560n1...@n3.nabble.com > To unsubscribe from Apache Spark User List, click here > <http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=cmljYXJkby5wYWl2YUBjb3JwLmdsb2JvLmNvbXwxfDQ1MDcxMTc2Mw==> > . > NAML > <http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- Ricardo Paiva Big Data / Semântica 2483-6432 *globo.com* <http://www.globo.com> -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Using-JDBC-clients-with-Spark-on-Hive-tp25976p25988.html Sent from the Apache Spark User List mailing list archive at Nabble.com.
