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

Using directory aliases by themselves in SELECT causes Unsupported Operation Error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 1.9.0, 1.10.0
    • None
    • SQL Parser
    • None

    • MacOSX, Drill 1.9

    • Important

    Description

      I have data that is nested in a directory structure. If I try to execute the following query 

      SELECT dir0  
FROM dfs.`logs/`

      I get the following error:

      org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION ERROR: With extractHeader enabled, only header names are supported column name columns column index

      However, if I execute the same query with a second field:

      SELECT customer_id, dir0  
FROM dfs.`logs/`

      This query executes without problem. It would seem as if Drill should support this kind of query.

      Attachments

        Activity

          People

            paul-rogers Paul Rogers
            cgivre Charles Givre
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: