You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by PBSLogitek <pa...@logitek.at> on 2019/03/18 14:31:38 UTC
Column cannot be inlined into the index because it's type doesn't
support inlining
I have a BigDecimal column on my entity which i need to index. Now i see
following message in the console
/Column cannot be inlined into the index because it's type doesn't support
inlining, index access may be slow due to additional page reads (change
column type if possible) [cacheName=ChannelPriceSourceCache,
tableName=CHANNELPRICESOURCE, idxName=AXCHANNEL_PRICE_SOURCE_MVIEW_IDX1,
idxType=SECONDARY, colName=QUANTITY_AMOUNT_FROM, columnType=DECIMAL/
What can i do ?
Thx
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Re: Column cannot be inlined into the index because it's type
doesn't support inlining
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Using fixed decimal point long should be just fine, though.
Regards,
--
Ilya Kasnacheev
вт, 19 мар. 2019 г. в 11:18, Patrick Brunmayr <Pa...@logitek.at>:
> Hello
>
> So it's not possible to index a money type ? Using double or float for
> money is strongly unrecommended
>
> Thx
>
>
>
>
>
> Patrick Brunmayr
> Software Architekt
> PBS Logitek Dienstleistungen GmbH
> Vogelweiderstrasse 37
> A-4600 Wels
>
> T: +43 59 614 2367
> F: +43 59 614 92367
>
> mail: Patrick.Brunmayr@logitek.at
>
> *http://www.logitek.at* <http://www.logitek.at/>
> Gerichtsstand: Wels, FN 103979k, UID-Nr. ATU25012900
> Von: Ilya Kasnacheev <il...@gmail.com>
> An: user@ignite.apache.org
> Datum: 18.03.2019 18:29
> Betreff: Re: Column cannot be inlined into the index because it's
> type doesn't support inlining
> ------------------------------
>
>
>
> Hello!
>
> Your best bet is to use LONG or DOUBLE, I guess.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 18 мар. 2019 г. в 17:31, PBSLogitek <*patrick.brunmayr@logitek.at*
> <pa...@logitek.at>>:
> I have a BigDecimal column on my entity which i need to index. Now i see
> following message in the console
>
> /Column cannot be inlined into the index because it's type doesn't support
> inlining, index access may be slow due to additional page reads (change
> column type if possible) [cacheName=ChannelPriceSourceCache,
> tableName=CHANNELPRICESOURCE, idxName=AXCHANNEL_PRICE_SOURCE_MVIEW_IDX1,
> idxType=SECONDARY, colName=QUANTITY_AMOUNT_FROM, columnType=DECIMAL/
>
> What can i do ?
>
> Thx
>
>
>
> --
> Sent from: *http://apache-ignite-users.70518.x6.nabble.com/*
> <http://apache-ignite-users.70518.x6.nabble.com/>
>
>
Antwort: Re: Column cannot be inlined into the index because it's type
doesn't support inlining
Posted by Patrick Brunmayr <Pa...@logitek.at>.
Hello
So it's not possible to index a money type ? Using double or float for
money is strongly unrecommended
Thx
Patrick Brunmayr
Software Architekt
PBS Logitek Dienstleistungen GmbH
Vogelweiderstrasse 37
A-4600 Wels
T: +43 59 614 2367
F: +43 59 614 92367
mail: Patrick.Brunmayr@logitek.at
http://www.logitek.at
Gerichtsstand: Wels, FN 103979k, UID-Nr. ATU25012900
Von: Ilya Kasnacheev <il...@gmail.com>
An: user@ignite.apache.org
Datum: 18.03.2019 18:29
Betreff: Re: Column cannot be inlined into the index because it's
type doesn't support inlining
Hello!
Your best bet is to use LONG or DOUBLE, I guess.
Regards,
--
Ilya Kasnacheev
пн, 18 мар. 2019 г. в 17:31, PBSLogitek <pa...@logitek.at>:
I have a BigDecimal column on my entity which i need to index. Now i see
following message in the console
/Column cannot be inlined into the index because it's type doesn't support
inlining, index access may be slow due to additional page reads (change
column type if possible) [cacheName=ChannelPriceSourceCache,
tableName=CHANNELPRICESOURCE, idxName=AXCHANNEL_PRICE_SOURCE_MVIEW_IDX1,
idxType=SECONDARY, colName=QUANTITY_AMOUNT_FROM, columnType=DECIMAL/
What can i do ?
Thx
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Column cannot be inlined into the index because it's type doesn't
support inlining
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Your best bet is to use LONG or DOUBLE, I guess.
Regards,
--
Ilya Kasnacheev
пн, 18 мар. 2019 г. в 17:31, PBSLogitek <pa...@logitek.at>:
> I have a BigDecimal column on my entity which i need to index. Now i see
> following message in the console
>
> /Column cannot be inlined into the index because it's type doesn't support
> inlining, index access may be slow due to additional page reads (change
> column type if possible) [cacheName=ChannelPriceSourceCache,
> tableName=CHANNELPRICESOURCE, idxName=AXCHANNEL_PRICE_SOURCE_MVIEW_IDX1,
> idxType=SECONDARY, colName=QUANTITY_AMOUNT_FROM, columnType=DECIMAL/
>
> What can i do ?
>
> Thx
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>