Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5868

Support SQL syntax highlighting of queries



    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.12.0
    • 1.13.0
    • Web Server


      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.



        1. SnippetExample.png
          22 kB
          Kunal Khatua

        Issue Links



              kkhatua Kunal Khatua
              kkhatua Kunal Khatua
              Arina Ielchiieva Arina Ielchiieva
              0 Vote for this issue
              4 Start watching this issue