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)