Column lineage does not work for CAST to Parameterized Data Type

[azurewtl]

I guess the issus is that "Type()" is recognized as a subquery, instead of a type in "CAST(col AS Type())"

Input SQL:

INSERT
     OVERWRITE tbl_dst(col1, col2)
SELECT
     CAST(name AS VARCHAR) AS col1,
     CAST(age AS VARCHAR(35)) AS col2,
FROM
     tbl_src

Expected Output:

<default>.tbl_dst.col1 <- name
<default>.tbl_dst.col2 <- age

Current Output:
<default>.tbl_dst.col1 <- name

[reata]

You're right. We don't support parameterized data type yet. Also decimal(18, 0) doesn't work while decimal works. It's the same reason behind.

This is a bug we should fix.