You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by Jim Carroll <ji...@gmail.com> on 2014/12/02 23:34:33 UTC

Standard SQL tool access to SchemaRDD

Hello all,

Is there a way to load an RDD in a small driver app and connect with a JDBC
client and issue SQL queries against it? It seems the thrift server only
works with pre-existing Hive tables.

Thanks
Jim




--
View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Standard-SQL-tool-access-to-SchemaRDD-tp20197.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
For additional commands, e-mail: user-help@spark.apache.org

Re: Standard SQL tool access to SchemaRDD

Posted by Jim Carroll <ji...@gmail.com>.

Thanks! I'll give it a try.




--
View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Standard-SQL-tool-access-to-SchemaRDD-tp20197p20202.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
For additional commands, e-mail: user-help@spark.apache.org

Re: Standard SQL tool access to SchemaRDD

Posted by Michael Armbrust <mi...@databricks.com>.

There is an experimental method that allows you to start the JDBC server
with an existing HiveContext (which might have registered temporary tables).

https://github.com/apache/spark/blob/master/sql/hive-thriftserver/src/main/scala/org/apache/spark/sql/hive/thriftserver/HiveThriftServer2.scala#L42

On Tue, Dec 2, 2014 at 2:34 PM, Jim Carroll <ji...@gmail.com> wrote:

> Hello all,
>
> Is there a way to load an RDD in a small driver app and connect with a JDBC
> client and issue SQL queries against it? It seems the thrift server only
> works with pre-existing Hive tables.
>
> Thanks
> Jim
>
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Standard-SQL-tool-access-to-SchemaRDD-tp20197.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
> For additional commands, e-mail: user-help@spark.apache.org
>
>