[jira] [Created] (TAJO-1767) "ERROR: Cannot evaluate the field "?substr" at node" is occured

["Dongkyu Hwangbo (JIRA)" <ji...@apache.org>]

Dongkyu Hwangbo created TAJO-1767:
-------------------------------------

             Summary: "ERROR: Cannot evaluate the field "?substr" at node" is occured
                 Key: TAJO-1767
                 URL: https://issues.apache.org/jira/browse/TAJO-1767
             Project: Tajo
          Issue Type: Bug
          Components: Benchmark
    Affects Versions: 0.11.0
            Reporter: Dongkyu Hwangbo
            Priority: Minor


when i enter below query,

{code:SQL}
select substr(r_reason_desc,1,20)
       ,avg(ws_quantity)
       ,avg(wr_refunded_cash)
       ,avg(wr_fee)
 from [...]
 where [...]
group by r_reason_desc
order by substr(r_reason_desc,1,20)
        ,avg(ws_quantity)
        ,avg(wr_refunded_cash)
        ,avg(wr_fee)
limit 100;
{code}

this error is occured.
{noformat}
ERROR: Cannot evaluate the field "?substr" at node (12)
{noformat}

so, I editted GROUP BY clause like below then run correctly.

{code:SQL}
select substr(r_reason_desc,1,20)
       ,avg(ws_quantity)
       ,avg(wr_refunded_cash)
       ,avg(wr_fee)
 from [...]
 where [...]
group by substr(r_reason_desc,1,20)
order by substr(r_reason_desc,1,20)
        ,avg(ws_quantity)
        ,avg(wr_refunded_cash)
        ,avg(wr_fee)
limit 100;
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)