[jira] [Created] (KYLIN-4503) Kylin query failing with Upper in query

["raghu ram reddy (Jira)" <ji...@apache.org>]

raghu ram reddy created KYLIN-4503:
--------------------------------------

             Summary: Kylin query failing with Upper in query
                 Key: KYLIN-4503
                 URL: https://issues.apache.org/jira/browse/KYLIN-4503
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v3.0.1
            Reporter: raghu ram reddy


This query fails  with below error, when we use "UPPER" function in where clause.

IF we remove the second where condition from query "AND 
UPPER(CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048))) LIKE '%TEST%'", it works fine.

Query:

SELECT TRIM(FACT."COLLEGE_NAME") AS "College Name ",
CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048)) AS "RN392 ",
UPPER(CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048))) AS "RN543 " 
FROM NAVIANCE_COLLEGE_TRANSFORM_03262020.COLLEGE_APPLICATION_FACT FACT 
WHERE TRIM(FACT."COLLEGE_NAME") LIKE '%Test name%' AND 
UPPER(CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048))) LIKE '%TEST%' 
GROUP BY TRIM(FACT."COLLEGE_NAME"),
CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048)),
UPPER(CAST(TRIM(FACT."COLLEGE_NAME") as VARCHAR(2048))) 
ORDER BY TRIM(FACT."COLLEGE_NAME") ASC LIMIT 250

ERROR:

Caused by: java.lang.NullPointerException

at org.apache.kylin.cube.CubeSegment.getDictResPath(CubeSegment.java:322)

at org.apache.kylin.cube.CubeManager$DictionaryAssist.getDictionary(CubeManager.java:1189)

at org.apache.kylin.cube.CubeManager.getDictionary(CubeManager.java:1126)

at org.apache.kylin.cube.CubeSegment.getDictionary(CubeSegment.java:354)

at org.apache.kylin.cube.kv.CubeDimEncMap.getDictionary(CubeDimEncMap.java:87)

at org.apache.kylin.dict.BuiltInFunctionTransformer.translateFunctionTupleFilter(BuiltInFunctionTransformer.java:92)

at org.apache.kylin.dict.BuiltInFunctionTransformer.transform(BuiltInFunctio



--
This message was sent by Atlassian Jira
(v8.3.4#803005)