[jira] [Commented] (DRILL-392) Add support for SHOW TABLES, DESCRIBE TABLE

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13975380#comment-13975380 ] 

ASF GitHub Bot commented on DRILL-392:
--------------------------------------

GitHub user vkorukanti opened a pull request:

    https://github.com/apache/incubator-drill/pull/53

    DRILL-392: Support SHOW TABLES/SCHEMAS and DESCRIBE TABLE.

    Use Optiq parser template to generate Drill parser
    a) exec/java-exec/pom.xml changes:
       1. Write a plugin to move current existing codegen directory to target
          (fmpp can't handle more than one directory as template input dir).
       2. Change template directory path in fmpp plugin.
       3. Extract CombinedParser.jj into target/codegen/templates directory.
       4. Plugin to compile CombinedParser.jj using javacc.
    
    b) Add parser.tdd to define values for freemarker variables in CombinedParser.jj template.
    c) Define grammar and SqlCall types for new DDL statements.
    d) Handlers to rewrite newly added SqlCall DDL statements as select queries from INFORMATION_SCHEMA.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/vkorukanti/incubator-drill DRILL-392

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-drill/pull/53.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #53
    
----
commit 60af41f36a8a723d9f34c867e7eec8a5cd3ea79e
Author: vkorukanti <ve...@gmail.com>
Date:   2014-04-10T20:41:11Z

    DRILL-392: Support SHOW TABLES/SCHEMAS and DESCRIBE TABLE.
    
    Use Optiq parser template to generate Drill parser
    a) exec/java-exec/pom.xml changes:
       1. Write a plugin to move current existing codegen directory to target
          (fmpp can't handle more than one directory as template input dir).
       2. Change template directory path in fmpp plugin.
       3. Extract CombinedParser.jj into target/codegen/templates directory.
       4. Plugin to compile CombinedParser.jj using javacc.
    
    b) Add parser.tdd to define values for freemarker variables in CombinedParser.jj template.
    c) Define grammar and SqlCall types for new DDL statements.
    d) Handlers to rewrite newly added SqlCall DDL statements as select queries from INFORMATION_SCHEMA.

----


> Add support for SHOW TABLES, DESCRIBE TABLE
> -------------------------------------------
>
>                 Key: DRILL-392
>                 URL: https://issues.apache.org/jira/browse/DRILL-392
>             Project: Apache Drill
>          Issue Type: New Feature
>            Reporter: Jacques Nadeau
>            Assignee: Venki Korukanti
>
> Update Optiq and Drill so we can use our own SqlParser that extends Optiq's implementation with our own custom parser grammar.  Show tables and describe tables should translate into queries from the INFORMATION_SCHEMA.



--
This message was sent by Atlassian JIRA
(v6.2#6252)