You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/01/24 08:01:41 UTC
[jira] [Commented] (TAJO-549) Worker fails to find some columns
when it processes order by queries
[ https://issues.apache.org/jira/browse/TAJO-549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13880774#comment-13880774 ]
Hyunsik Choi commented on TAJO-549:
-----------------------------------
It is not a worker problem. It's just a validation problem.
{code}
select client, cache, httpcode, method, requestaddr, fqdn, ... group by client ...
{code}
Please note that all expressions in select list must appear in the GROUP BY clause or be used in an aggregate function.
> 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)