lilu created KYLIN-3493:
---------------------------

             Summary: error: group dimensions on tableau with kylin
                 Key: KYLIN-3493
                 URL: https://issues.apache.org/jira/browse/KYLIN-3493
             Project: Kylin
          Issue Type: Bug
            Reporter: lilu


when I try to Group dimensions on tableau +kylin,the error occurs ,if there 
someone can help ?how to resovle this problem ?

 

[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: 
Encountered "\'" at line 1, column 182. Was expecting one of: "WITH" ... "+" 
... "-" ... "NOT" ... "EXISTS" ... <UNSIGNED_INTEGER_LITERAL> ... 
<DECIMAL_NUMERIC_LITERAL> ... <APPROX_NUMERIC_LITERAL> ... 
<BINARY_STRING_LITERAL> ... <PREFIXED_STRING_LITERAL> ... <QUOTED_STRING> ... 
<UNICODE_STRING_LITERAL> ... "TRUE" ... "FALSE" ... "UNKNOWN" ... "NULL" ... 
<LBRA

 

SELECT (CASE WHEN ("JSD_R_USERS_ORDER_ALL_INC_V"."NAME" IN ('[634wcd2]旺财贷', 
'[634wcd4]旺财贷', '[634wcd5]旺财贷', '[634wcd]旺财贷')) THEN 'ss' WHEN 
("JSD_R_USERS_ORDER_ALL_INC_V"."NAME" IN ('[293UfcRZ] ----', '[29XzFQDg] ----', 
'[2MXpUawV] ----')) THEN 'ssaq' ELSE "JSD_R_USERS_ORDER_ALL_INC_V"."NAME" END) 
AS "X_______"

FROM "YJY_TRAINING"."JSD_R_USERS_ORDER_ALL_INC_V" "JSD_R_USERS_ORDER_ALL_INC_V"

GROUP BY (CASE WHEN ("JSD_R_USERS_ORDER_ALL_INC_V"."NAME" IN ('[634wcd2]旺财贷', 
'[634wcd4]旺财贷', '[634wcd5]旺财贷', '[634wcd]旺财贷')) THEN 'ss' WHEN 
("JSD_R_USERS_ORDER_ALL_INC_V"."NAME" IN ('[293UfcRZ] ----', '[29XzFQDg] ----', 
'[2MXpUawV] ----')) THEN 'ssaq' ELSE "JSD_R_USERS_ORDER_ALL_INC_V"."NAME" END)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to