[
https://issues.apache.org/jira/browse/DRILL-7508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17006724#comment-17006724
]
Daniel Hitchcock commented on DRILL-7508:
-----------------------------------------
If giving the column an alias, the correct data is returned:
{code:java}
SELECT Event_Date, Event_Time, Event_ID, Message_Type, Message, Filename AS
File_Name
FROM easymorph.logs.`Spaces/Default`
LIMIT 10;
{code}
!Tableau_Alias.png!
> Filesystem Implicit Columns Not Returned
> ----------------------------------------
>
> Key: DRILL-7508
> URL: https://issues.apache.org/jira/browse/DRILL-7508
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - ODBC
> Affects Versions: 1.17.0
> Environment: Windows Server 2016R2, Drill 1.17, ODBC x86 / x64
> 1.3.22.1055
> Reporter: Daniel Hitchcock
> Priority: Minor
> Attachments: GUI.png, Tableau.png, Tableau_Alias.png
>
>
> When using the latest ODBC driver with Drill 1.17, the newly added Implicit
> Columns
> ([http://drill.apache.org/docs/querying-a-file-system-introduction/#implicit-columns])
> are not returned when performing a query.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
