Charles Givre created DRILL-5251:
------------------------------------
Summary: Fields called 'Name' causing IndexOutOfBounds exception
in Joins
Key: DRILL-5251
URL: https://issues.apache.org/jira/browse/DRILL-5251
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.9.0
Environment: Mac OS 10.11
Reporter: Charles Givre
In working on a training class for Drill I discovered that if you have fields
called 'Name' in your data, it will cause IndexOutOfBounds exceptions when you
use that field in a join.
This is the query I used:
```
SELECT data2016.`EmpName`, data2016.`JobTitle`, data2016.`AnnualSalary` AS
salary_2016, data2015.`AnnualSalary` AS salary_2015
FROM dfs.drillclass.`baltimore_salaries_2016.csvh` AS data2016
INNER JOIN dfs.drillclass.`baltimore_salaries_2015.csvh` AS data2015
ON data2016.`EmpName` = data2015.`EmpName`
```
I renamed the Name field to EmpName and the query worked fine. If you want to
try this out, the data is available here:
https://data.baltimorecity.gov/City-Governm…
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
