You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 周湘伦 <ja...@gmail.com> on 2017/09/26 03:16:05 UTC
When i query with kylin,it reminds me: Not a valid value
Hi,all
When i query with kylin,some error occured:
10:45:41.302 [Query e147b8bb-ec9d-48c1-bde8-904c764468f2-200] ERROR
org.apache.kylin.dict.TrieDictionary - Not a valid value: 20170918
Define as follows：
ID Column Encoding Length Shard By
2 TBL_BILL_GENERAL.SETT_DATE dict[v1] 0 false
DataSource define:
SETT_DATE char(8)
This error can also occur if the corresponding fields in the table do not
have this data,then i deleted those values that are not present in the
table.
However, there are still errors in the correct field that has data such as
sett_date.
How can i solve the problem?
Best regards.
Re: When i query with kylin,it reminds me: Not a valid value
Posted by 周湘伦 <ja...@gmail.com>.
OK,thank you.
2017-10-08 14:34 GMT+08:00 Li Yang <li...@apache.org>:
> Although the log level is ERROR, this is actually expected behavior when
> querying a value not exists in your table. I'm downgrading the log level.
>
> On Tue, Sep 26, 2017 at 11:16 AM, 周湘伦 <ja...@gmail.com> wrote:
>
> > Hi,all
> > When i query with kylin,some error occured:
> > 10:45:41.302 [Query e147b8bb-ec9d-48c1-bde8-904c764468f2-200] ERROR
> > org.apache.kylin.dict.TrieDictionary - Not a valid value: 20170918
> >
> > Define as follows：
> >
> > ID Column Encoding Length Shard By
> >
> > 2 TBL_BILL_GENERAL.SETT_DATE dict[v1] 0 false
> >
> > DataSource define:
> > SETT_DATE char(8)
> >
> > This error can also occur if the corresponding fields in the table do not
> > have this data,then i deleted those values that are not present in the
> > table.
> >
> > However, there are still errors in the correct field that has data such
> as
> > sett_date.
> >
> > How can i solve the problem?
> > Best regards.
> >
>
Re: When i query with kylin,it reminds me: Not a valid value
Posted by Li Yang <li...@apache.org>.
Although the log level is ERROR, this is actually expected behavior when
querying a value not exists in your table. I'm downgrading the log level.
On Tue, Sep 26, 2017 at 11:16 AM, 周湘伦 <ja...@gmail.com> wrote:
> Hi,all
> When i query with kylin,some error occured:
> 10:45:41.302 [Query e147b8bb-ec9d-48c1-bde8-904c764468f2-200] ERROR
> org.apache.kylin.dict.TrieDictionary - Not a valid value: 20170918
>
> Define as follows：
>
> ID Column Encoding Length Shard By
>
> 2 TBL_BILL_GENERAL.SETT_DATE dict[v1] 0 false
>
> DataSource define:
> SETT_DATE char(8)
>
> This error can also occur if the corresponding fields in the table do not
> have this data,then i deleted those values that are not present in the
> table.
>
> However, there are still errors in the correct field that has data such as
> sett_date.
>
> How can i solve the problem?
> Best regards.
>