[ https://issues.apache.org/jira/browse/DRILL-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16248223#comment-16248223 ]
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_r150364771 --- Diff: exec/java-exec/src/main/codegen/includes/parserImpls.ftl --- @@ -215,11 +215,12 @@ SqlNode SqlDropView() : /** * Parses a CTAS or CTTAS statement. - * CREATE [TEMPORARY] TABLE tblname [ (field1, field2, ...) ] AS select_statement. + * CREATE [TEMPORARY] [IF NOT EXISTS] TABLE tblname [ (field1, field2, ...) ] AS select_statement. --- End diff -- Fixed it > Implement "CREATE TABLE IF NOT EXISTS" > -------------------------------------- > > Key: DRILL-5952 > URL: https://issues.apache.org/jira/browse/DRILL-5952 > Project: Apache Drill > Issue Type: Bug > Components: SQL Parser > Affects Versions: 1.11.0 > Reporter: Prasad Nagaraj Subramanya > Assignee: Prasad Nagaraj Subramanya > Fix For: 1.12.0 > > > 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)