"CASE 1 WHEN 1 THEN true WHEN 2 THEN 'string' ELSE NULL END"
I am working on a project based on Flink SQL, but found that I can`t rename column after casting, the code is as below:
cast(json_type as INTEGER) as xxx
And the following exception is reported:
CalciteContextException: From line 4, column 6 to line 11, column 38: Illegal mixing of types in CASE or COALESCE statement
I want to know that does Flink do not support this function because I think it is a common case? Is there a way to accomplish this function?
Thank a lot.