You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/29 10:20:52 UTC
[jira] [Assigned] (TAJO-443) Order by query gives
NullPointerException at at
org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
[ https://issues.apache.org/jira/browse/TAJO-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyunsik Choi reassigned TAJO-443:
---------------------------------
Assignee: Hyunsik Choi
> 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
>
> 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)