While running a view which casts the integer data stored as varchar vertica gets below error - ('22V02', '[22V02] ERROR 2827: Could not convert "" from column eoscar_acdv.A_credit_limit to an int8\n (2827) (SQLExecDirectW)')
Environment
Vertica Analytics Database: All versions
Situation
While running a view which casts the integer data stored as varchar vertica gets below error -
('22V02', '[22V02] ERROR 2827: Could not convert "" from column eoscar_acdv.A_credit_limit to an int8\n (2827) (SQLExe
Find complete article on support portal
