You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/10 03:00:08 UTC
[jira] [Updated] (TAJO-335) Unknown logical node type error occurs when a query includes some expressions

     [ https://issues.apache.org/jira/browse/TAJO-335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi updated TAJO-335:
------------------------------

    Component/s: planner/optimizer
                 operator/function/udf
    Description: 
When a query includes cast and constant expression, the query causes Unknown logical node type error.


{noformat}
tajo>  select cast (1 as text);
Unknown logical node type: EXPRS
tajo>  select cast ('1' as int2);
Unknown logical node type: EXPRS
{noformat}

{noformat}
tajo> \d table1;

table name: table1
table path: /tajo/table10
store type: CSV
number of rows: 0
volume: 60 B
Options: 
        'csvfile.delimiter'='|'

schema: 
id      INT4
name    TEXT
score   FLOAT4
type    TEXT

tajo> select cast(id as text) from table1;
Unknown EvalNode: CAST (table1.id (INT4(0)) AS TEXT)
{noformat}

  was:
Cast() does not work properly as follows:

{noformat}
tajo>  select cast (1 as text);
Unknown logical node type: EXPRS
tajo>  select cast ('1' as int2);
Unknown logical node type: EXPRS
{noformat}

{noformat}
tajo> \d table1;

table name: table1
table path: /tajo/table10
store type: CSV
number of rows: 0
volume: 60 B
Options: 
        'csvfile.delimiter'='|'

schema: 
id      INT4
name    TEXT
score   FLOAT4
type    TEXT

tajo> select cast(id as text) from table1;
Unknown EvalNode: CAST (table1.id (INT4(0)) AS TEXT)
{noformat}

       Priority: Critical  (was: Major)
        Summary: Unknown logical node type error occurs when a query includes some expressions  (was: cast() does not work properly)

> Unknown logical node type error occurs when a query includes some expressions
> -----------------------------------------------------------------------------
>
>                 Key: TAJO-335
>                 URL: https://issues.apache.org/jira/browse/TAJO-335
>             Project: Tajo
>          Issue Type: Bug
>          Components: operator/function/udf, planner/optimizer
>            Reporter: Keuntae Park
>            Assignee: Hyunsik Choi
>            Priority: Critical
>             Fix For: 0.8-incubating
>
>
> When a query includes cast and constant expression, the query causes Unknown logical node type error.
> {noformat}
> tajo>  select cast (1 as text);
> Unknown logical node type: EXPRS
> tajo>  select cast ('1' as int2);
> Unknown logical node type: EXPRS
> {noformat}
> {noformat}
> tajo> \d table1;
> table name: table1
> table path: /tajo/table10
> store type: CSV
> number of rows: 0
> volume: 60 B
> Options: 
>         'csvfile.delimiter'='|'
> schema: 
> id      INT4
> name    TEXT
> score   FLOAT4
> type    TEXT
> tajo> select cast(id as text) from table1;
> Unknown EvalNode: CAST (table1.id (INT4(0)) AS TEXT)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)