Ajith Dharwar created DRILL-3672:
------------------------------------
Summary: Data Provenance and DFS metadata
Key: DRILL-3672
URL: https://issues.apache.org/jira/browse/DRILL-3672
Project: Apache Drill
Issue Type: Bug
Components: Metadata, Storage - Text & CSV
Affects Versions: 1.1.0
Environment: 1
Reporter: Ajith Dharwar
Assignee: Steven Phillips
My present query on Apache Drill is as follows -
select
CAST(columns[0] AS Integer) as ID,
to_timestamp(SUBSTR(columns[10],1,14),'YYYYMMddHHmmss') as RecordDt
from dfs.`/data/100Krows/`
What I would like to do is get the modificationTime metadata for each of the
.csv files in my folder as a column something like this -
select
CAST(columns[0] AS Integer) as ID,
to_timestamp(SUBSTR(columns[10],1,14),'YYYYMMddHHmmss') as RecordDt,
modificationTime as versionStartTime
from dfs.`/data/100Krows/`
The modificationTime along with filename metadata can be found when I run the
following qry
SHOW FILES in dfs.data
Is there a way to achieve this in its current version 1.1 or 1.0?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
