snuyanzin commented on PR #22143:
URL: https://github.com/apache/flink/pull/22143#issuecomment-1584147817
@liuyongvs thanks for your response
I tried to do it with datagen (since recently it supports `null-rate`), so I
tried this
```sql
CREATE TABLE t (
a BIGINT,
b ARRAY<MAP<INT, STRING>>
) WITH (
'connector' = 'datagen',
'fields.a.null-rate' = '0.5',
'fields.b.null-rate' = '0.5',
'fields.b.element.null-rate' = '0.5'
);
```
and then this query (you've mentioned)
```sql
SELECT a, b, ARRAY_CONTAINS(b, MAP[1, 'a']) FROM t;
```
for about 5 min I was not able to get any exception...
About test in the PR:
I'm a bit skeptic about it because it explicitly sets entry of map to
`NULL`. What functionality allows to that?
I do not remember any SQL function allowing to do that. Key and value yes
however not the whole entry
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
