drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Charles Givre (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5251) Fields called 'Name' causing IndexOutOfBounds exception in Joins
Date Fri, 10 Feb 2017 15:59:41 GMT
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)

Mime
View raw message