[jira] [Created] (DRILL-5520) Using directory aliases by themselves in SELECT causes Unsupported Operation Error

[Charles Givre (JIRA)]

Charles Givre created DRILL-5520:
------------------------------------

             Summary: Using directory aliases by themselves in SELECT causes 
Unsupported Operation Error
                 Key: DRILL-5520
                 URL: https://issues.apache.org/jira/browse/DRILL-5520
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.10.0, 1.9.0
         Environment: MacOSX, Drill 1.9
            Reporter: Charles Givre
            Priority: Minor


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

{code:sql}
SELECT dir0  
FROM dfs.`logs/`
{code}

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:

{code:sql}
SELECT customer_id, dir0  
FROM dfs.`logs/`
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)