You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "JaeHwa Jung (JIRA)" <ji...@apache.org> on 2013/12/16 11:05:07 UTC
[jira] [Created] (TAJO-423) Using aggregation query on local file
system.
JaeHwa Jung created TAJO-423:
--------------------------------
Summary: Using aggregation query on local file system.
Key: TAJO-423
URL: https://issues.apache.org/jira/browse/TAJO-423
Project: Tajo
Issue Type: Bug
Affects Versions: 0.8-incubating
Reporter: JaeHwa Jung
Fix For: 0.8-incubating
I found a bug to use aggregation query which scan external table stored on local file system as follows:
* make just directory on local file system.
** location: /Users/blrunner/data/tajo/table1
* create table on tsql
** create external table table1 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') location 'file:/Users/blrunner/data/tajo/table1';
* query test
** select count(*) from table1: *PASSED*
** select id, count(*) from table1 group by id: *PASSED*
* make csv file on location which is '/Users/blrunner/data/tajo/table1'
* query test again
** select count(*) from table1: *PASSED*
** select id, count(*) from table1 group by id: *{color:red}FAILED{color}*
{code:xml}
2013-12-16 18:54:38,080 INFO planner.PhysicalPlannerImpl (PhysicalPlannerImpl.java:createBestAggregationPlan(727)) - The planner chooses [Hash Aggregation]
2013-12-16 18:54:38,080 INFO planner.PhysicalPlannerImpl (PhysicalPlannerImpl.java:createInMemoryHashAggregation(679)) - The planner chooses [Hash Aggregation]
2013-12-16 18:54:38,080 ERROR worker.Task (Task.java:run(366)) - java.lang.IllegalArgumentException: The number of partitions must be positive: 0
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:119)
at org.apache.tajo.engine.planner.logical.StoreTableNode.setPartitions(StoreTableNode.java:88)
at org.apache.tajo.engine.planner.PhysicalPlannerImpl.buildOutputOperator(PhysicalPlannerImpl.java:97)
at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:80)
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:680)
2013-12-16 18:54:38,081 INFO worker.Task (Task.java:run(411)) - Task Counter - total:5, succeeded: 2, failed: 3
2013-12-16 18:54:38,081 INFO worker.TaskRunner (TaskRunner.java:run(318)) - Request GetTask: eb_1387181184478_0005_000001,container_1387181184478_0005_01_000003
2013-12-16 18:54:38,081 ERROR querymaster.QueryUnitAttempt (QueryUnitAttempt.java:transition(292)) - FROM 192.168.0.187 >> java.lang.IllegalArgumentException: The number of partitions must be positive: 0
at com.google.common.base.Preconditions.checkArgument(Preconditions.java:119)
at org.apache.tajo.engine.planner.logical.StoreTableNode.setPartitions(StoreTableNode.java:88)
at org.apache.tajo.engine.planner.PhysicalPlannerImpl.buildOutputOperator(PhysicalPlannerImpl.java:97)
at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:80)
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:680)
{code}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)