walterddr commented on issue #12306:
URL: https://github.com/apache/pinot/issues/12306#issuecomment-1905073303
could you attach the explain plan result for this query.
This is actually a problem b/c the mv column is not exactly semantically
"relational algebra" it is a short-handed representation of saying "it should
behave as an array (with some extra op) when xxx and should behave as a set
(with some extra op) when yyy"
so there's really no convention or compatibility fix.
for this specific query
```
select id, mvc from (
select id, arraytomv(mv) as mvc from mytable group by id, mvc) embd
where mvc = 'a'
```
the where clause is not because it is not suppose to be pushed into the
inner query, but the question on whether we should applied it as a filter
before/after the group-by.
agree we definitely need some redesign to make sure this behavior is clear.
even if it means some of the existing syntax wont make sense. for example: in
this case, UNNEST must be explicitly specify and mvc should be treated as
normal ARRAY type. then the confusion should go away
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
