egasimov commented on issue #2936: URL: https://github.com/apache/drill/issues/2936#issuecomment-2312770836
Hey @cgivre , Thank you for response. I have really appreciated it. Requirement for the SQL query is to check and filter the those rows whose nested array field(_purchased_items_) have at least one of the values provided in the IN clause and return the original rows(without duplicating the entries). When **FLATTEN** used in the query, after the filter operations, we will again need to **GROUP BY** or **DISTINCT** to remove duplicate rows form result. Wdyt, Is there any other way to accomplish the same goal but in optimized way ? :thinking: -- 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: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org