Whenever we are loading the data via dbt model, and column data type for casting is defined as int but the value of data is in bigint then it throws Gandiva Expection and did not tell in which column issue persists.
So could you please help me in resolving this issue if we could get the column name in the logs then it would be easy to debug the issue.
dbt Model - SELECT “emp_unique_key” AS “emp_unique_key”,
“payroll_element_classification” AS “payroll_element_classification”,
CAST(“salary_item_value” AS decimal(15,5)) AS “salary_item_value”,
CAST(“gross_salary” AS decimal(15,5)) AS “gross_salary”
FROM asdfd
Error - ERROR: SYSTEM ERROR: GandivaException: Failed to cast the string 58125.000 to int64_t