drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kunal Khatua (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5868) Support SQL syntax highlighting of queries
Date Fri, 12 Jan 2018 19:08:00 GMT

     [ 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 JIRA's 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 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.

  was:
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 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.


> 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 JIRA's 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 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.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message