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

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

Github user prasadns14 commented on a diff in the pull request:

    https://github.com/apache/drill/pull/1033#discussion_r153004699
  
    --- Diff: 
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/parser/SqlCreateView.java
 ---
    @@ -47,20 +47,19 @@ public SqlCall createCall(SqlLiteral functionQualifier, 
SqlParserPos pos, SqlNod
       private SqlIdentifier viewName;
       private SqlNodeList fieldList;
       private SqlNode query;
    -  private boolean replaceView;
    +  private SqlLiteral createViewType;
     
    -  public SqlCreateView(SqlParserPos pos, SqlIdentifier viewName, 
SqlNodeList fieldList,
    -      SqlNode query, SqlLiteral replaceView) {
    -    this(pos, viewName, fieldList, query, replaceView.booleanValue());
    +  public enum SqlCreateViewType {
    +    SIMPLE, ORREPLACE, IFNOTEXISTS
    --- End diff --
    
    done


> Implement "CREATE TABLE IF NOT EXISTS"
> --------------------------------------
>
>                 Key: DRILL-5952
>                 URL: https://issues.apache.org/jira/browse/DRILL-5952
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: SQL Parser
>    Affects Versions: 1.11.0
>            Reporter: Prasad Nagaraj Subramanya
>            Assignee: Prasad Nagaraj Subramanya
>             Fix For: Future
>
>
> Currently, if a table/view with the same name exists CREATE TABLE fails with 
> VALIDATION ERROR
> Having "IF NOT EXISTS" support for CREATE TABLE will ensure that query 
> succeeds 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to