Arina Ielchiieva created DRILL-5238: ---------------------------------------
Summary: CTTAS: unable to resolve temporary table if workspace is indicated without schema Key: DRILL-5238 URL: https://issues.apache.org/jira/browse/DRILL-5238 Project: Apache Drill Issue Type: Bug Affects Versions: 1.10.0 Reporter: Arina Ielchiieva Assignee: Arina Ielchiieva Fix For: 1.10.0 Drill is unable to resolve temporary table if default temporary workspace is partially indicated (schema was set using USE command and only workspace name is used in query). {noformat} 0: jdbc:drill:zk=local> use dfs; +-------+----------------------------------+ | ok | summary | +-------+----------------------------------+ | true | Default schema changed to [dfs] | +-------+----------------------------------+ 1 row selected (0.156 seconds) 0: jdbc:drill:zk=local> create temporary table tmp.t as select 'A' from (values(1)); +-----------+----------------------------+ | Fragment | Number of records written | +-----------+----------------------------+ | 0_0 | 1 | +-----------+----------------------------+ 1 row selected (1.525 seconds) 0: jdbc:drill:zk=local> select * from tmp.t; Feb 02, 2017 11:24:09 AM org.apache.calcite.sql.validate.SqlValidatorException <init> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'tmp.t' not found Feb 02, 2017 11:24:09 AM org.apache.calcite.runtime.CalciteException <init> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Table 'tmp.t' not found Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Table 'tmp.t' not found SQL Query null [Error Id: 5266cb67-9d37-4a94-9a4e-28a4a2f94be5 on localhost:31010] (state=,code=0) {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)