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>)