XSQL icon indicating copy to clipboard operation
XSQL copied to clipboard

Are you Interested in integrating XSQL into Scriptis and Linkis?

Open wushengyeyouya opened this issue 5 years ago • 5 comments

Hi, Your project is particularly great, but there are certain thresholds for analysis users. Are you Interested in integrating XSQL into Scriptis and Linkis? . Scriptis: https://github.com/WeBankFinTech/Scriptis Linkis: https://github.com/WeBankFinTech/Linkis I look forward to your reply. Thank you very much.

wushengyeyouya avatar Sep 06 '19 03:09 wushengyeyouya

@wushengyeyouya do you want to use hive thriftserver2 jdbc?

WeiWenda avatar Sep 06 '19 03:09 WeiWenda

Linkis support spark engine, and we can implement a new EngineHook to get the ability of XSQL. Scriptis can show the metadata of XSQL holded, and submit sql to linkis.

wushengyeyouya avatar Sep 06 '19 04:09 wushengyeyouya

How does Scriptis&Linkis use spark now? xsql usage is all the same as spark

WeiWenda avatar Sep 06 '19 04:09 WeiWenda

Linkis use spark repl to obtain the ability of spark. So we think Scriptis&Linkis is pretty easy to integrate XSQL.

wushengyeyouya avatar Sep 06 '19 05:09 wushengyeyouya

You can configure spark.sql.catalogImplementation=xsql in spark-defaults.conf,so that spark-shell、spark-sql、spark-submit will enable XSQL syntax. But above configuration only works in bin version, spark.sql.catalogImplementation=xsql is not allowed in raw spark. image

WeiWenda avatar Sep 06 '19 05:09 WeiWenda