You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/06/19 05:01:06 UTC

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

     [ https://issues.apache.org/jira/browse/DRILL-5520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Rogers reassigned DRILL-5520:
----------------------------------

    Assignee: Paul Rogers

> 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.9.0, 1.10.0
>         Environment: MacOSX, Drill 1.9
>            Reporter: Charles Givre
>            Assignee: Paul Rogers
>            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.4.14#64029)