Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 6 Feb 2017 09:50:42 +0000 (UTC)
From: "Arina Ielchiieva (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13037345.1485260115000.4104.1486374642419@Atlassian.JIRA>
In-Reply-To: <JIRA.13037345.1485260115000@Atlassian.JIRA>
References: <JIRA.13037345.1485260115000@Atlassian.JIRA> <JIRA.13037345.1485260115444@jira-lw-us.apache.org>
Subject: [jira] [Commented] (DRILL-5215) CTTAS: disallow temp tables in view
 expansion logic
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 06 Feb 2017 09:50:46 -0000


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

Arina Ielchiieva commented on DRILL-5215:
-----------------------------------------

Merged into master with commit id 63ae6cffc23f1de8159217da9a8879b9ffb86423

> CTTAS: disallow temp tables in view expansion logic
> ---------------------------------------------------
>
>                 Key: DRILL-5215
>                 URL: https://issues.apache.org/jira/browse/DRILL-5215
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.10.0
>            Reporter: Arina Ielchiieva
>            Assignee: Arina Ielchiieva
>             Fix For: 1.10.0
>
>
> This Jira is addressing last two CR comments in PR for Jira DRILL-4956:
> 1. Disallow temp tables in view expansion logic.
> Steps to reproduce:
> a. use default temporary workspace.
> b. create persistent table with name t:
> c. create view over persistent table.
> d. drop persistent table.
> e. create temporary table with the same name as persistent table.
> f. select from view 
> Currently Drill returns result on step f but should return error message.
> {noformat}
> VALIDATION ERROR: Temporary tables usage is disallowed. Used temporary table name: t
> {noformat}
> {noformat}
> use dfs.tmp;
> create table t as select 'TABLE' from (values(1));
> create view v as select * from t;
> select * from v;
> +---------+
> | EXPR$0  |
> +---------+
> | TABLE   |
> +---------+
> drop table t;
> create temporary table t as select 'TEMP' from (values(1));
> select * from v;
> +---------+
> | EXPR$0  |
> +---------+
> | TEMP    |
> +---------+
> {noformat}
> 2. Replace link to gist with CTTAS design doc to Jira link.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)