[jira] [Commented] (TAJO-238) NullPointerException occurs when a query includes an alias of UDF at the group by clause

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13789967#comment-13789967 ] 

Hyunsik Choi commented on TAJO-238:
-----------------------------------

I've tested a SQL query with the same conditions of your query as follows:
{code:sql}
select upper(trim(l_comment)) as capname, sum(l_orderkey) from lineitem group by capname order by capname
{code}

If you show more clues, it would be helpful to find the bug.

Thank you for your reporting.

> NullPointerException occurs when a query includes an alias of UDF at the group by clause
> ----------------------------------------------------------------------------------------
>
>                 Key: TAJO-238
>                 URL: https://issues.apache.org/jira/browse/TAJO-238
>             Project: Tajo
>          Issue Type: Bug
>          Components: operator/function/udf
>            Reporter: Jihoon Son
>            Assignee: Jihoon Son
>             Fix For: 0.2-incubating
>
>
> The query which I run is
> {code}
> SELECT hour(time) as t, sum(size) 
> FROM log 
> GROUP BY t  
> ORDER BY t asc
> {code}
> The function hour() returns the hour of values of the column 'time'.
> The error log is
> {code}
> 13/10/08 21:21:18 ERROR worker.Task: java.lang.NullPointerException
>         at org.apache.tajo.catalog.Schema.getColumnId(Schema.java:154)
>         at org.apache.tajo.engine.eval.FieldEval.eval(FieldEval.java:51)
>         at org.apache.tajo.engine.eval.GeneralFunctionEval.terminate(GeneralFunctionEval.java:62)
>         at org.apache.tajo.engine.planner.physical.HashAggregateExec.next(HashAggregateExec.java:94)
>         at org.apache.tajo.engine.planner.physical.MemSortExec.next(MemSortExec.java:54)
>         at org.apache.tajo.engine.planner.physical.IndexedStoreExec.next(IndexedStoreExec.java:92)
>         at org.apache.tajo.worker.Task.run(Task.java:381)
>         at org.apache.tajo.worker.TaskRunner$2.run(TaskRunner.java:364)
>         at java.lang.Thread.run(Thread.java:679)
> {code}



--
This message was sent by Atlassian JIRA
(v6.1#6144)