[jira] [Created] (TAJO-245) This query causes this error msg 'org.apache.tajo.algebra.FunctionExpr cannot be cast to org.apache.tajo.algebra.ColumnReferenceExpr'

["Seungun Choe (JIRA)" <ji...@apache.org>]

Seungun Choe created TAJO-245:
---------------------------------

             Summary: This query causes this error msg 'org.apache.tajo.algebra.FunctionExpr cannot be cast to org.apache.tajo.algebra.ColumnReferenceExpr'
                 Key: TAJO-245
                 URL: https://issues.apache.org/jira/browse/TAJO-245
             Project: Tajo
          Issue Type: Bug
            Reporter: Seungun Choe


{code}
SELECT
                col1, col2, col3, 
                CASE
                  WHEN split_part(split_part(col4,'id=', 2), '&', 1) IS NOT NULL THEN ''
                  ELSE
                    CASE
                      WHEN col4 like '/%' THEN split_part(col4,'/', 2)
                      ELSE split_part(col4,'/', 1)
                    END
                END AS col4, split_part(split_part(col4,'id=', 2), '&', 1) AS id
        FROM table1
        WHERE tmp='asdf';
{code}

error msg
{code}
org.apache.tajo.algebra.FunctionExpr cannot be cast to org.apache.tajo.algebra.ColumnReferenceExpr
{code}



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