Prafulla T created TAJO-443:
-------------------------------
Summary: Order by query gives NullPointerException at at
org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
Key: TAJO-443
URL: https://issues.apache.org/jira/browse/TAJO-443
Project: Tajo
Issue Type: Bug
Components: physical operator
Affects Versions: 0.8-incubating
Reporter: Prafulla T
Prepare the table like below:
{noformat}
[prafulla@localhost mytests] cat data.csv
1|abc|1.1|a
2|def|2.3|b
3|ghi|3.4|c
4|jkl||d
5|mno|5.6|e
{noformat}
{noformat}
create external table table1 (id int, name text, score float, type text) using
csv with ('csvfile.delimiter'='|')
location 'file:<path to data.csv>';
{noformat}
Note that score table has NULL value.
Give this query to reproduce this problem.
{noformat}
tajo> select score is null from table1 order by score;
Query failed!
{noformat}
In logs:
{noformat}
2013-12-21 13:09:04,813 INFO worker.Task (Task.java:<init>(197)) -
==================================
2013-12-21 13:09:04,814 INFO worker.TaskAttemptContext
(TaskAttemptContext.java:setState(105)) - Query status of
ta_1387659623971_0012_000001_000000\
_02 is changed to TA_RUNNING
2013-12-21 13:09:04,817 ERROR worker.Task (Task.java:run(366)) -
java.lang.NullPointerException
at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
at
org.apache.tajo.storage.TupleComparator.<init>(TupleComparator.java:56)
at
org.apache.tajo.engine.planner.physical.SortExec.<init>(SortExec.java:38)
at
org.apache.tajo.engine.planner.physical.MemSortExec.<init>(MemSortExec.java:40)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestSortPlan(PhysicalPlannerImpl.java:761)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createSortPlan(PhysicalPlannerImpl.java:749)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:155)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:73)
at
org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:44)
at org.apache.tajo.worker.Task.run(Task.java:355)
at org.apache.tajo.worker.TaskRunner$1.run(TaskRunner.java:376)
at java.lang.Thread.run(Thread.java:724)
2013-12-21 13:09:04,818 INFO worker.Task (Task.java:run(411)) - Task Counter -
total:21, succeeded: 9, failed: 12
2013-12-21 13:09:04,818 ERROR querymaster.QueryUnitAttempt
(QueryUnitAttempt.java:transition(292)) - FROM 127.0.1.1 >>
java.lang.NullPointerException
at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
at
org.apache.tajo.storage.TupleComparator.<init>(TupleComparator.java:56)
at
org.apache.tajo.engine.planner.physical.SortExec.<init>(SortExec.java:38)
at
org.apache.tajo.engine.planner.physical.MemSortExec.<init>(MemSortExec.java:40)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestSortPlan(PhysicalPlannerImpl.java:761)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createSortPlan(PhysicalPlannerImpl.java:749)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:155)
at
org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:73)
at
org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:44)
at org.apache.tajo.worker.Task.run(Task.java:355)
at org.apache.tajo.worker.TaskRunner$1.run(TaskRunner.java:376)
at java.lang.Thread.run(Thread.java:724)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
