tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prafulla T (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-443) Order by query gives NullPointerException at at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142)
Date Sat, 21 Dec 2013 21:20:09 GMT
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)

Mime
View raw message