[DRILL-6084] Expose list of Drill functions for consumption by JavaScript libraries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Web Server
• Labels: ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Arina Ielchiieva
• Created: 12/Jan/18 19:24
• Updated: 19/Oct/18 11:31
• Resolved: 19/Oct/18 11:31

Description

DRILL-5868 introduces SQL highlighter and the auto-complete feature in the web-UI's query editor.
For the backend Javascript to highlight the keywords correctly as SQL reserved words or functions, it needs a list of all the Drill functions to be already defined in a source JavaScript ( ../mode-sql.js ) .
While this works well for standard Drill functions, it means that any new function added to Drill needs to be explicitly hard-coded into the file, rather than be programatically discovered and loaded for the library to highlight.

It would help if this can be done dynamically without contributors having to explicitly alter the script file to add new function names.

Issue Links

• requires: DRILL-3988 Create a sys.functions table to expose available Drill functions
• links to: GitHub Pull Request #1491