Thanks, Alessandro Solimando Got it, very clear explanation. My main question here becomes that calcite doesn't support double mod.
Regards! Aron Tao Alessandro Solimando <[email protected]> 于2020年10月15日周四 下午10:32写道： > Hi Aron Tao, > Calcite adheres to SQL standard in that respect (citing): > > The data types NUMERIC, DECIMAL, INTEGER and SMALLINT are collectively > > referred to > > as exact numeric types. > > > > The data types FLOAT, REAL, and DOUBLE PRECISION are collectively referred > > to as approx- > > imate numeric types. > > > In practice the way we represent a number can lead to an exact (scale + > precision) or an approximate (base + mantissa) representation, which suits > very different needs. > > Best regards, > Alessandro > > On Thu, 15 Oct 2020 at 16:16, JiaTao Tao <[email protected]> wrote: > > > In calcite, you can not mod doubles. In Java, you can, in C you can't use > > "%" to mod doubles, but you can use fmod. > > > > Regards! > > > > Aron Tao > > > > > > JiaTao Tao <[email protected]> 于2020年10月15日周四 下午10:00写道： > > > > > org.apache.calcite.sql.type.SqlTypeName#APPROX_TYPES > > > org.apache.calcite.sql.type.SqlTypeName#NUMERIC_TYPES > > > > > > Regards! > > > > > > Aron Tao > > > > > >
