[DRILL-6989] Upgrade to SqlLine 1.7.0

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Labels: doc-complete ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Arina Ielchiieva
• Reviewer: Vova Vysotskyi
• Created: 21/Jan/19 15:32
• Updated: 02/May/19 22:54
• Resolved: 29/Mar/19 14:52

Description

Upgrade to SqlLine 1.7.0 after its officially released.

Major improvements is that Drill Sqlline prom will change from the default 0: jdbc:drill:zk=local> to apache drill> if schema is unset. If schema was set (ex: use dfs.tmp), prompt will look the following way: apache drill (dfs.tmp)>.

To return to previous prompt display, user can modify drill-sqlline-override.conf and set drill.sqlline.prompt.with_schema to false.

To set custom prompt user can use one of the SqlLine properties: prompt, promptScript, rightPrompt.
This can be achieved using set command, example: !set prompt my_prompt), or these properties can be overridden in drill-sqlline-override.conf.

Issue Links

• contains: DRILL-808 Sqlline use schema does not change the displayed schema
• contains: DRILL-3090 sqlline : save SQL to script file and replay from script, results in error
• contains: DRILL-6980 --run regression - error when empty line or command at end of the file
• contains: DRILL-1506 Current Schema Not Shown In the sqlline Prompt
• contains: DRILL-1669 Custom sqlline Prompt
• links to: GitHub Pull Request #1717