kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xiaojia (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-1299) kylin odbc
Date Mon, 11 Jan 2016 07:48:39 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-1299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15091561#comment-15091561
] 

xiaojia commented on KYLIN-1299:
--------------------------------



你好:
       在tableau中,我是将一个日期列拖放至筛选器上,做为筛选条件,此时会弹出我之前邮件中第一张截图,选相对日期,比如选今天向前推,前三天,
此时就会报之前发的第二张图片中上的错误。tableau执行SQL如下,DT3为做为筛选条件的日期列字段:
SELECT SUM("KYLIN_VIEW_TVAD_SUMMARY"."OCCU") AS "TEMP_Calculation_DADHBBFAAIIHFCDDCJ__BDCGHFEDBE__A_"
FROM "BD_WAREHOUSE"."KYLIN_VIEW_TVAD_SUMMARY" "KYLIN_VIEW_TVAD_SUMMARY"
  LEFT JOIN "BD_WAREHOUSE"."KYLIN_TV_DIM_CITY_V_KYLIN" "KYLIN_TV_DIM_CITY_V_KYLIN" ON ("KYLIN_VIEW_TVAD_SUMMARY"."CITY"
= "KYLIN_TV_DIM_CITY_V_KYLIN"."CITY")
  LEFT JOIN "BD_WAREHOUSE"."KYLIN_TV_DIM_PLAT_NEW_V" "KYLIN_TV_DIM_PLAT_NEW_V" ON ("KYLIN_VIEW_TVAD_SUMMARY"."PLAT_ID"
= "KYLIN_TV_DIM_PLAT_NEW_V"."PLAT_ID")
  LEFT JOIN "BD_WAREHOUSE"."KYLIN_TV_DIM_DATE_CUBE_V_KYLIN" "KYLIN_TV_DIM_DATE_CUBE_V_KYLIN"
ON ("KYLIN_VIEW_TVAD_SUMMARY"."DT" = "KYLIN_TV_DIM_DATE_CUBE_V_KYLIN"."DT1")
  LEFT JOIN "BD_WAREHOUSE"."KYLIN_TV_DIM_CHANNEL_CID_V" "KYLIN_TV_DIM_CHANNEL_CID_V" ON ("KYLIN_VIEW_TVAD_SUMMARY"."C_ID"
= "KYLIN_TV_DIM_CHANNEL_CID_V"."C_ID")
WHERE (("KYLIN_VIEW_TVAD_SUMMARY"."C_ID" = 1) AND (("KYLIN_TV_DIM_DATE_CUBE_V_KYLIN"."DT3"
>= {fn TIMESTAMPADD(SQL_TSI_DAY,-2,)}) AND ("KYLIN_TV_DIM_DATE_CUBE_V_KYLIN"."DT3" <
{fn TIMESTAMPADD(SQL_TSI_DAY,1,)})) AND ("KYLIN_TV_DIM_CITY_V_KYLIN"."N_NAME" = '中国')
AND ((("KYLIN_TV_DIM_PLAT_NEW_V"."PLAT_NAME" >= 'Gpad') AND ("KYLIN_TV_DIM_PLAT_NEW_V"."PLAT_NAME"
<= 'PC')) OR (("KYLIN_TV_DIM_PLAT_NEW_V"."PLAT_NAME" >= 'ipad App') AND ("KYLIN_TV_DIM_PLAT_NEW_V"."PLAT_NAME"
<= 'iphone H5'))) AND ("KYLIN_VIEW_TVAD_SUMMARY"."POSITION" = 'oad'))
HAVING (COUNT(1) > 0)








> kylin odbc
> ----------
>
>                 Key: KYLIN-1299
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1299
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: xiaojia
>         Attachments: 1.png, 2.png
>
>
> When I use tableau connection kylin, use date types of data as filter is, that will be
submitted to the following error:
> Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: Encountered
", )" at line 1, column 1494. Was expecting one of: ")" ... "," "+" ... "," "-" ... "," 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message