tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-443) Order by query gives NullPointerException at at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
Date Sun, 29 Dec 2013 09:22:51 GMT

    [ https://issues.apache.org/jira/browse/TAJO-443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13858292#comment-13858292
] 

Hyunsik Choi commented on TAJO-443:
-----------------------------------

This is also a projection push down bug. Essentially, this bug is the same to TAJO-463.

> 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)

Mime
View raw message