Re: Division by floating number literal in hive 2.3.5 results in implicit conversion to integer

2020-04-27 Thread Kwanghee Park
SELECT CAST(1.0 AS DOUBLE)/2.0 FROM EXAMPLE; SELECT DOUBLE(1.0)/2.0 FROM EXAMPLE; On Tue, Apr 28, 2020 at 5:31 AM Arup Malakar wrote: > > 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 wrote: > >> Hi

Re: Division by floating number literal in hive 2.3.5 results in implicit conversion to integer

2020-04-27 Thread Kwanghee Park
SELECT DOUBLE(1.0/2.0) FROM EXAMPLE; On Tue, Apr 28, 2020 at 2:36 PM Kwanghee Park wrote: > SELECT CAST(1.0 AS DOUBLE)/2.0 FROM EXAMPLE; > SELECT DOUBLE(1.0)/2.0 FROM EXAMPLE; > > On Tue, Apr 28, 2020 at 5:31 AM Arup Malakar wrote: > >> >> Would anyone know if it could be related to calcite ver

Count bug in Hive 3.0.0.3.1

2020-04-27 Thread Deepak Krishna
Hi team, We came across a bug related to count function. We are using hive 3.0.0.3.1 with Tez 0.9.0.3.1. PFA the queries to replicate the issue. Please register this as a bug and let us know if we can support in anyway to fix the issue. It would also be helpful to know if there are any other w

Re: Request write access to the Hive wiki

2020-04-27 Thread Jiajie Zhong
Ping again. Did someone could grant permission to me to change the HIVE wiki? Best Wish — Jiajie > On Apr 25, 2020, at 18:29, Jiajie Zhong wrote: > > Hi folks, > > I reading HIVE doc and find some death link to it, > I want to update it so request write access to the Hive wiki > My confluenc

Re: Division by floating number literal in hive 2.3.5 results in implicit conversion to integer

2020-04-27 Thread Arup Malakar
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 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