[DRILL-5868] Support SQL syntax highlighting of queries

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.13.0
• Component/s: Web Server
• Labels: ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Arina Ielchiieva
• Created: 12/Oct/17 05:45
• Updated: 21/Mar/18 01:48
• Resolved: 25/Jan/18 01:51

Description

Based on the commit for DRILL-5981 (PR #1043), this JIRA's commit further leverages the Ace JavaScript library with customizations specific to Drill.

This introduces the following to Drill:

1. Syntax highlighting (This is also supported for submitted query profiles)
2. Auto-complete supported in all SQL editors (including the Edit Query tab within an existing profile to rerunning the query).
   For browsers like Chrome, you should be able to type Ctrl+Space to show a drop down list for use. Arrow keys are used for navigating to the desired option.
3. Specifying Drill specific keywords and functions in visible autocomplete
4. Key snippets (template SQLs) allowing for rapid writing of syntax:
   i. Query System Tables
   ii. CView, CTAS, CTempTAS and CFuncJar
   iii. Alter Session
   iv. Explain and Select * queries
   This is done by leveraging the Snippets feature in the Ace library, which allows for writing SQL code from templates. Like auto-complete, this will insert a template for you. The required/optional fields are then selected (in order) for you to populate, as you complete each and navigate to the next using Tab.

NOTE: The lists for items 3 and 4 are not exhaustive. As more features are added to Drill, these lists can be expanded.

Snapshot:

Issue Links

• is duplicated by: DRILL-5703 Add Syntax Highlighting & Autocompletion to Query Form
• relates to: DRILL-5981 Add Syntax Highlighting and Error Checking to Storage Plugin Config Page
• links to: GitHub Pull Request #1084