[
https://issues.apache.org/jira/browse/DRILL-2738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Parth Chandra updated DRILL-2738:
---------------------------------
Component/s: Execution - Relational Operators
> Offset with casting a column to timestamp not working
> -----------------------------------------------------
>
> Key: DRILL-2738
> URL: https://issues.apache.org/jira/browse/DRILL-2738
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 0.7.0
> Reporter: Venkata krishnan Sowrirajan
>
> In the below query, it should skip the first row which is a header and want
> to cast one of the column to timestamp. But it is trying to parse the first
> row to cast it to timestamp. Without casting it to timestamp, simple offset
> query works fine.
> "select cast(columns[0] as timestamp) from
> `guts-csv/CSV/guts_run_lab-app002.csv` offset 1;"
> So I did explain plan on the above query
> explain plan without implementation for select cast(columns[0] as timestamp)
> from `guts-csv/CSV/guts_run_lab-app002.csv` offset 1;
> DrillScreenRel
> DrillLimitRel(offset=[1])
> DrillProjectRel(EXPR$0=[CAST(ITEM($0, 0)):TIMESTAMP(0)])
> DrillScanRel(table=[[fs, drill, guts-csv/CSV/guts_run_lab-app002.csv]],
> groupscan=[EasyGroupScan
> [selectionRoot=/mapr/yarn-test/drill/guts-csv/CSV/guts_run_lab-app002.csv,
> numFiles=1, columns=[`columns`[0]],
> files=[file:/mapr/yarn-test/drill/guts-csv/CSV/guts_run_lab-app002.csv]]])
> In the plan, it looks like it tries to do casting to timestamp and then the
> offset operation which is why its failing.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
