[LIVY-40] Ability to create SQL Kind Session on Livy Job Server

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.1
• Component/s: Core
• Labels: SQL Spark-SQL
• Assignee: Unassigned
• Reporter: Prabhu Kasinathan
• Created: 29/Dec/15 20:49
• Updated: 12/May/16 00:11
• Resolved: 12/May/16 00:11

Description

Currently Livy Job Server supports only PySpark and Scala Spark kind sessions to create and submit codes.
curl -X POST --data '

{"kind": "pyspark"}

' -H "Content-Type: application/json" localhost:8998/sessions
curl -X POST --data '

{"kind": "spark"}

' -H "Content-Type: application/json" localhost:8998/sessions
It would be better, if we are able to create '

{"kind": "sql"}

' kind session to submit spark sql through hiveContext.
eg:
curl -X POST --data '

{"kind": "sql"}

' -H "Content-Type: application/json" localhost:8998/sessions
curl localhost:8998/sessions/0/statements -X POST -H 'Content-Type: application/json' -d '

{"code":"INSERT OVERWRITE TABLE target SELECT cols FROM source"}