Hi Kylin Team --
I'm hitting the below error when executing query with the time dimension in the where clause against a 35GB cube (No issues running otherwise). Same exact query works fine against Hive with the WHERE clause. Any ideas? Thanks, Regards, Error when scan from lower key � ;8 to upper key ����������������� on table KYLIN_PWNXRLXEZ7. while executing SQL: "SELECT CUSTOMER_DIM_T.PRN_CST_NM ,CURRENCY_DIM_T.SHRT_NM ,BRANCH_DIM_T.BR_NM ,COUNTRY_DIM_T.CTY_NM ,SUM(AML_TXN_FCT_CUB_T.USD_TXN_AMT) ,SUM(AML_TXN_FCT_CUB_T.AC_CCY_TXN_AMT) FROM DL_FINSERV_DEMO.AML_TXN_FCT_CUB_T as AML_TXN_FCT_CUB_T INNER JOIN DL_FINSERV_DEMO.CUSTOMER_DIM_T as CUSTOMER_DIM_T ON AML_TXN_FCT_CUB_T.FIRM_CST_KEY = CUSTOMER_DIM_T.KEY INNER JOIN DL_FINSERV_DEMO.BRANCH_DIM_T as BRANCH_DIM_T ON AML_TXN_FCT_CUB_T.TXN_BR_KEY = BRANCH_DIM_T.BR_KEY INNER JOIN DL_FINSERV_DEMO.COUNTRY_DIM_T as COUNTRY_DIM_T ON AML_TXN_FCT_CUB_T.RMTR_CTY_KEY = COUNTRY_DIM_T.CTY_KEY INNER JOIN DL_FINSERV_DEMO.CURRENCY_DIM_T as CURRENCY_DIM_T ON AML_TXN_FCT_CUB_T.RMTR_CCY_KEY = CURRENCY_DIM_T.KEY INNER JOIN DL_FINSERV_DEMO.DATE_DIM_T as DATE_DIM_T ON AML_TXN_FCT_CUB_T.TXN_BOOK_DT_KEY = DATE_DIM_T.DT_KEY WHERE DATE_DIM_T.DT_KEY >= date'2015-04-01' GROUP BY CUSTOMER_DIM_T.PRN_CST_NM ,CURRENCY_DIM_T.SHRT_NM ,BRANCH_DIM_T.BR_NM ,COUNTRY_DIM_T.CTY_NM LIMIT 5000" -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Error-when-scan-from-lower-key-tp3083.html Sent from the Apache Kylin mailing list archive at Nabble.com.
