[
https://issues.apache.org/jira/browse/KYLIN-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Callum Antonio updated KYLIN-4503:
----------------------------------
Due Date: 24/Jun/20
> 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
> Priority: Blocker
>
> 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)
