drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4956) Temporary tables support
Date Tue, 06 Dec 2016 06:12:59 GMT

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

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

Github user paul-rogers commented on a diff in the pull request:

    https://github.com/apache/drill/pull/666#discussion_r90701076
  
    --- Diff: exec/java-exec/src/main/codegen/includes/parserImpls.ftl ---
    @@ -214,8 +214,8 @@ SqlNode SqlDropView() :
     }
     
     /**
    - * Parses a CTAS statement.
    - * CREATE TABLE tblname [ (field1, field2, ...) ] AS select_statement.
    + * Parses a CTAS or CTTAS statement.
    + * CREATE [TEMPORARY] TABLE tblname [ (field1, field2, ...) ] AS select_statement.
    --- End diff --
    
    MySQL requires the full TEMPORARY keyword. Postgress allows both TEMPORARY and the shorter
TEMP. (SqlServer requires a funky # table name prefix.) Oracle seems to use the full TEMPORARY
keyword.


> Temporary tables support
> ------------------------
>
>                 Key: DRILL-4956
>                 URL: https://issues.apache.org/jira/browse/DRILL-4956
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.8.0
>            Reporter: Arina Ielchiieva
>            Assignee: Paul Rogers
>              Labels: doc-impacting
>             Fix For: Future
>
>
> Link to design doc - https://docs.google.com/document/d/1gSRo_w6q2WR5fPx7SsQ5IaVmJXJ6xCOJfYGyqpVOC-g/edit



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

Mime
View raw message