You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2014/01/24 07:26:38 UTC

[jira] [Created] (TAJO-549) Worker fails to find some columns when it processes order by queries

Jihoon Son created TAJO-549:
-------------------------------

             Summary: Worker fails to find some columns when it processes order by queries
                 Key: TAJO-549
                 URL: https://issues.apache.org/jira/browse/TAJO-549
             Project: Tajo
          Issue Type: Bug
          Components: physical operator, worker
            Reporter: Jihoon Son
             Fix For: 0.8-incubating


Suppose a following table.
{noformat}
CREATE TABLE test (totaltime int8, client inet4, cache text, httpcode int4, totalsize int8, method text, requestaddr text, fqdn text) USING CSV;
{noformat}
When I run a query which contains a group by and an order by clauses, a worker returns the java.lang.IllegalStateException: No Such Column Reference error as follows.
{noformat}
tajo> select client, cache, httpcode, method, requestaddr, fqdn, sum(totalsize) as sum_size, sum(totaltime) as sum_time from test group by client order by sum_size, sum_time;

,,,
2014-01-24 15:14:45,951 INFO  worker.Task (Task.java:waitForFetch(344)) - ta_1390543843292_0002_000003_000000_00 All fetches are done!
2014-01-24 15:14:46,852 ERROR worker.Task (Task.java:run(378)) - java.lang.IllegalStateException: No Such Column Reference: test.cache (TEXT), schema: {(3) test.client (INET4),sum_size (INT8),sum_time (INT8)}
        at org.apache.tajo.engine.eval.FieldEval.eval(FieldEval.java:47)
        at org.apache.tajo.engine.planner.Projector.eval(Projector.java:48)
        at org.apache.tajo.engine.planner.physical.ProjectionExec.next(ProjectionExec.java:63)
        at org.apache.tajo.engine.planner.physical.StoreTableExec.next(StoreTableExec.java:76)
        at org.apache.tajo.worker.Task.run(Task.java:370)
        at org.apache.tajo.worker.TaskRunner$1.run(TaskRunner.java:392)
        at java.lang.Thread.run(Thread.java:701)

2014-01-24 15:14:46,852 INFO  worker.TaskAttemptContext (TaskAttemptContext.java:setState(106)) - Query status of ta_1390543843292_0002_000003_000000_00 is changed to TA_FAILED
2014-01-24 15:14:46,854 INFO  worker.Task (Task.java:run(430)) - Task Counter - total:4, succeeded: 3, failed: 1
,,,
{noformat}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)