XSQL icon indicating copy to clipboard operation
XSQL copied to clipboard

How to use jdbc to connect to XSQL

Open lordk911 opened this issue 5 years ago • 3 comments

hi,all : I have successfully deploy xsql-0.6.0-bin-spark-2.4.3 , and tested with cil . but after I started the thriftserver I could not query out anything.

lordk911 avatar Sep 06 '19 08:09 lordk911

I draw a simple graph to illustrate what's happened when set spark.sql.catalogImplementation to xsql, or calling SparkSession.builder().enableXSQLSupport() image

WeiWenda avatar Sep 07 '19 03:09 WeiWenda

As long as you change spark.sql.catalogImplementation to xsql, both spark-hive-thriftserver and spark-repl will start to support multi-datasource instead of one hive only. For permanent change, add new line spark.sql.catalogImplementation=xsql in your spark-defaults.conf. For temporary change, add args --conf spark.sql.catalogImplementation=xsql when you start thriftserver or spark-shell.

WeiWenda avatar Sep 07 '19 03:09 WeiWenda

I draw a simple graph to illustrate what's happened when set spark.sql.catalogImplementation to xsql, or calling SparkSession.builder().enableXSQLSupport() image

I think this graph could added into docs.

beliefer avatar Sep 07 '19 10:09 beliefer