Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 871BA10E2D for ; Mon, 20 Jan 2014 01:57:46 +0000 (UTC) Received: (qmail 13190 invoked by uid 500); 20 Jan 2014 01:57:45 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 13156 invoked by uid 500); 20 Jan 2014 01:57:45 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 13059 invoked by uid 99); 20 Jan 2014 01:57:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jan 2014 01:57:44 +0000 X-ASF-Spam-Status: No, hits=-2000.5 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 20 Jan 2014 01:57:41 +0000 Received: (qmail 12073 invoked by uid 99); 20 Jan 2014 01:57:19 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jan 2014 01:57:19 +0000 Date: Mon, 20 Jan 2014 01:57:19 +0000 (UTC) From: "Hyunsik Choi (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (TAJO-443) Order by query gives NullPointerException at at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:142) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ 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:'; > {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:(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.(TupleComparator.java:56) > at org.apache.tajo.engine.planner.physical.SortExec.(SortExec.java:38) > at org.apache.tajo.engine.planner.physical.MemSortExec.(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.(TupleComparator.java:56) > at org.apache.tajo.engine.planner.physical.SortExec.(SortExec.java:38) > at org.apache.tajo.engine.planner.physical.MemSortExec.(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)