https://pinot.apache.org/ logo
#general
Title
# general
r

RK

06/11/2021, 8:17 AM
Hi everyone , How to convert a string into double in pinot with sum.functiom .I have tried these 2 queries but getting this error. In my pinot schema file I have data type as string for this field so I m not able to take sum. While wring the transformation in config file I have assign default value as null for this field so it has both non null values and null where data is not available.i guess it is not able to cast the null values into double /decimal. Any way to ignore nulls . I have tried where gross_amount is not null but didn't work. Kindly suggest
x

Xiang Fu

06/11/2021, 10:42 AM
I think you have “null” value in the string which failed the conversion
can you try to filter out the null value
select … from myTable where gross_amout <> ‘null’
r

RK

06/11/2021, 10:58 AM
Yes I have nulls in table.ok let me try with <>. I was using is not null.
@User Worked.