Support AND operator as alias of list intersect/array intersect function like Duckdb

apache / datafusion

Apache DataFusion SQL Query Engine

https://datafusion.apache.org/

Apache License 2.0

6.27k stars 1.18k forks source link

Support AND operator as alias of list intersect/array intersect function like Duckdb #8483

Open jayzhan211 opened 11 months ago

jayzhan211 commented 11 months ago

Is your feature request related to a problem or challenge?

Support list intersect operators like Duckdb. https://duckdb.org/docs/sql/functions/nested

Example: [1,2,3] && [4,5] -> array_intersect([1,2,3], [4,5])

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

Veeupup commented 11 months ago

@jayzhan211 Hi! I can help with this ticket~

viirya commented 11 months ago

If I get the context correct, do you mean to support And (&&) as alias of array_intersect like Duckdb? I modified the issue title to make it more correct/understandable.