[
https://issues.apache.org/jira/browse/DRILL-5868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320114#comment-16320114
]
ASF GitHub Bot commented on DRILL-5868:
---------------------------------------
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/1084#discussion_r160651815
--- Diff:
exec/java-exec/src/main/resources/rest/static/js/ace-code-editor/snippets/sql.js
---
@@ -0,0 +1,46 @@
+/**
+ * Drill SQL Syntax Snippets
+ */
+
+ace.define("ace/snippets/sql",["require","exports","module"],
function(require, exports, module) {
+"use strict";
+
+exports.snippetText = "snippet info\n\
+ select * from INFORMATION_SCHEMA.${1:<tableName>};\n\
+snippet sysmem\n\
+ select * from sys.mem;\n\
+snippet sysopt\n\
+ select * from sys.opt;\n\
+snippet sysbit\n\
+ select * from sys.bit;\n\
+snippet sysconn\n\
+ select * from sys.conn;\n\
+snippet sysprof\n\
+ select * from sys.prof;\n\
+snippet cview\n\
+ create view ${1:[workspace]}.${2:<viewName>} ( ${3:<columnName>} ) as
\n\
+ ${4:<query>};\n\
+snippet ctas\n\
+ create table ${1:<tableName>} ( ${2:<columnName>} ) as \n\
+ ${3:<query>};\n\
+snippet ctemp\n\
+ create temporary table ${1:<tableName>} ( ${2:<columnName>} ) as \n\
--- End diff --
Could you please also add snippet for create function: `CREATE FUNCTION
USING JAR '<jar_name>.jar';`?
> 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
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
