[
https://issues.apache.org/jira/browse/TAJO-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi resolved TAJO-443.
-------------------------------
Resolution: Fixed
Fix Version/s: 0.8-incubating
Fixed by TAJO-501.
> 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
> Assignee: Hyunsik Choi
> Fix For: 0.8-incubating
>
>
> 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.5#6160)
