You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by sdangi <sd...@datalenz.com> on 2016/01/06 20:46:45 UTC
Error when scan from lower key
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.
Re: Error when scan from lower key
Posted by hongbin ma <ma...@apache.org>.
yes, and check the kylin.log before or after, maybe there's some other
clues.
On Thu, Jan 7, 2016 at 9:47 AM, yu feng <ol...@gmail.com> wrote:
> 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 <sd...@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.
> >
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
Re: Error when scan from lower key
Posted by yu feng <ol...@gmail.com>.
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 <sd...@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.
>