anoop s nair created SPARK-52734:
------------------------------------
Summary: Support for Oracle-style Hierarchical Queries using
CONNECT BY PRIOR in Spark SQL
Key: SPARK-52734
URL: https://issues.apache.org/jira/browse/SPARK-52734
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 4.0.0
Reporter: anoop s nair
Apache Spark SQL currently lacks native support for Oracle-style hierarchical
queries, specifically the {{CONNECT BY PRIOR}} syntax. This proposal aims to
introduce support for such recursive hierarchical queries, enabling users to
express and traverse parent-child relationships directly within SQL, without
resorting to manual DataFrame-based recursive joins or external graph
processing libraries.
The {{CONNECT BY PRIOR}} clause is widely used in Oracle for querying
hierarchical data such as organizational charts, category trees,
bill-of-material structures, etc. By adding support for this syntax and
execution pattern in Spark SQL, we can improve compatibility with legacy Oracle
systems and offer more intuitive ways for users to query recursive
relationships.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
