[jira] [Created] (ZEPPELIN-1876) Improve JDBC autocompletion - schema, tables, columns and aliases

["Sergey Sotnichenko (JIRA)" <ji...@apache.org>]

Sergey Sotnichenko created ZEPPELIN-1876:
--------------------------------------------

             Summary: Improve JDBC autocompletion - schema, tables, columns and aliases
                 Key: ZEPPELIN-1876
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1876
             Project: Zeppelin
          Issue Type: Improvement
          Components: Interpreters
            Reporter: Sergey Sotnichenko
            Priority: Minor


Autocompletion mixes schema, tables and colums names.
No matter where in sql my cursor is and what am I writing it shows all schemas, tables and columns mixed together.

But more logic if autocompletion will depend on the context.

||Command||Cursor position||What autocompletion must show||
|{{select * from some}}|at the end|only schema names|
|{{select * from some_schema.some}}|at the end|only tables from some_schema schema|
|{{select * from some_schema.some_table a where a.some}}|at the end|only columns from some_schema.some_table table|
|{{select a.some from some_schema.some_table}}|after a.some|only columns from some_schema.some_table table|




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)