[DRILL-5979] unnable to access temporary table from drill web interface

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.10.0, 1.11.0
• Fix Version/s: 1.12.0
• Component/s: Web Server

Environment

CentOS

• Assignee: Unassigned
• Reporter: Rajeshwar Rao
• Created: 20/Nov/17 13:30
• Updated: 20/Nov/17 13:34
• Resolved: 20/Nov/17 13:34

Description

Hi,

I am unable to access a temporary table created from Apache drill web Interface.

In web UI temporary table is created successfully using following query
create temporary table t as select 'A' from (values(1))

when we try to access the temporary table using

select * from t

following error is seen, org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: At line 1, column 15: Table 't' not found SQL Query null

even when i use the workspace and schema same error is shown

Note : The same works fine from CLI ( jdbc:drill:zk=local>)