Latest Activity


"Allow literal as parameter" setting and datatype mismatches

We are using a connection to HANA and running into the following error when aggregating some decimal data type fields using the coalesce function: select year_quarter, item_name, sum(quantity) quantity, sum(amount) amount from ( SELECT year_quarter, i...



CAST function cannot be delegated

Hi, I am using Denodo to connect to Hana calcViews. In my view, I need to convert a date into a text, which I do by the CAST function. However, at runtime I get the error: The CAST function with the SQL type="'VARCHAR" cannot be delegated to the data...