Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5979

unnable to access temporary table from drill web interface

    Details

    • 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
    • Labels:
      None
    • Environment:

      CentOS

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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Rajeshwar.Rao Rajeshwar Rao
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: