Jim Scott created DRILL-1206:
--------------------------------
Summary: left outer join - two CSV files - generates
NullPointerException
Key: DRILL-1206
URL: https://issues.apache.org/jira/browse/DRILL-1206
Project: Apache Drill
Issue Type: Bug
Components: Execution - RPC
Affects Versions: 1.0.0
Reporter: Jim Scott
This query:
SELECT * FROM dfs.`/tmp/Downloads/Crimes_-_2001_to_present.csv` crimes LEFT
OUTER JOIN dfs.`/tmp/Downloads/Sex_Offenders.csv` offenders ON
crimes.columns[3] = offenders.columns[2] LIMIT 20;
Generates this error:
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "b93b09b8-55f5-436a-b57d-acc596d712c3"
endpoint {
address: "myserver"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < ValidationException:[
java.lang.NullPointerException ] < NullPointerException"
]
Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
