[
https://issues.apache.org/jira/browse/DRILL-5868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Khatua updated DRILL-5868:
--------------------------------
Description:
Based on the commit for DRILL-5981 ([PR
#1043|https://github.com/apache/drill/pull/1043]), this commit further
leverages the Ace JavaScript library with customizations specific to Drill.
This introduces the following to Drill:
# Syntax highlighting (This is also supported for submitted query profiles)
# 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.
# Specifying Drill specific keywords and functions in visible autocomplete
# Key snippets (template SQLs) allowing for rapid writing of syntax:
i. Query System Tables
ii. CView, CTAS, CTempTAS and CFnJar
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.
was:
It would be nice to have the Query Editor support syntax highlighting.
An autocomplete would be even better as new functions are introduced in Drill
> Support SQL syntax highlighting of queries
> ------------------------------------------
>
> Key: DRILL-5868
> URL: https://issues.apache.org/jira/browse/DRILL-5868
> Project: Apache Drill
> Issue Type: New Feature
> Components: Web Server
> Affects Versions: 1.12.0
> Reporter: Kunal Khatua
> Assignee: Kunal Khatua
> Priority: Minor
> Labels: doc-impacting
> Fix For: 1.13.0
>
>
> Based on the commit for DRILL-5981 ([PR
> #1043|https://github.com/apache/drill/pull/1043]), this commit further
> leverages the Ace JavaScript library with customizations specific to Drill.
> This introduces the following to Drill:
> # Syntax highlighting (This is also supported for submitted query profiles)
> # 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.
> # Specifying Drill specific keywords and functions in visible autocomplete
> # Key snippets (template SQLs) allowing for rapid writing of syntax:
> i. Query System Tables
> ii. CView, CTAS, CTempTAS and CFnJar
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
