You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "lilu (JIRA)" <ji...@apache.org> on 2018/08/13 06:18:00 UTC

[jira] [Created] (KYLIN-3493) error: group dimensions on tableau with kylin

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)