This means your one of hbase scanner execute failed, you can check logs in regionserver for more detailed infomation.
2016-01-07 3:46 GMT+08:00 sdangi <sda...@datalenz.com>: > 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. >
