Nico Kruber created FLINK-22405: ----------------------------------- Summary: Support fixed-lengh chars in the LeadLag built-in function Key: FLINK-22405 URL: https://issues.apache.org/jira/browse/FLINK-22405 Project: Flink Issue Type: Improvement Components: Table SQL / API Affects Versions: 1.12.2 Reporter: Nico Kruber
LeadLag aggregate function does not support type: ''CHAR'', as in the following example (a CAST to VARCHAR works around this). Technically, there should be no reason though to support STRING/VARCHAR but not CHAR: {code:sql} CREATE TEMPORARY VIEW test_cardinality AS SELECT * FROM ( VALUES ('Alice', 'al...@test.com', ARRAY [ 'al...@test.com' ], 'Test Ltd'), ('Alice', 'al...@test.com', ARRAY [ 'al...@test.com' ], 'Test Ltd'), ('Alice', 'al...@test2.com', ARRAY [ 'al...@test.com', 'al...@test2.com' ], 'Test Ltd')) AS t ( name, email, aliases, company ); {code} {code:sql} SELECT name, LEAD(company, 0) AS company FROM test_cardinality WHERE CARDINALITY(aliases) >= 2 GROUP BY name; {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)