Would anyone know if it could be related to calcite versions and any possible workarounds?
On Thu, Apr 23, 2020 at 6:16 PM Arup Malakar <amala...@gmail.com> wrote: > Hi Hive Users, > > I noticed that with cbo on the query: "SELECT 1.0/2.0 FROM example limit > 1" returns 0 > > hive> SET hive.cbo.enable=true; SELECT 1.0/2.0 FROM example limit 1; >> 0 >> > > > With cbo disabled it returns 0.5 as expected: > > hive> SET hive.cbo.enable=false; SELECT 1.0/2.0 FROM example limit 1; >> 0.5 >> > > Not referring to a table returns 0.5 as expected as well: > > hive> select 1.0/2.0; >> 0.5 >> > > > This is how the explain plan looks like: > > hive> SET hive.cbo.enable=true; EXPLAIN extended SELECT 1.0/2.0 FROM >> example limit 1; >> OK >> STAGE DEPENDENCIES: >> Stage-0 is a root stage >> STAGE PLANS: >> Stage: Stage-0 >> Fetch Operator >> limit: 1 >> Processor Tree: >> TableScan >> alias: example >> GatherStats: false >> Select Operator >> expressions: 0 (type: int) >> outputColumnNames: _col0 >> Limit >> Number of rows: 1 >> ListSink > > > I have tested that it is not an issue in 2.1.1 and 3.0, but only in 2.3.6. > I couldn't find a corresponding JIRA that fixes it though. Does anyone know > if there is a JIRA that fixes this (so that I can backport) or any other > suggestion? > > -- > Arup Malakar > -- Arup Malakar