- 3371 Views
- 5 replies
- 4 kudos
Resolved! How can I look up the first ancestor (person,first_ancestor) of a record from a table that has (child,parent) records?
I have a table that looks like this:/* input */ -- | parent | child | -- | ------ | ----- | -- | 1 | 2 | -- | 2 | 3 | -- | 3 | 4 | -- | 5 | 6 | -- | 6 | 7 | -- | 8 | 9 | -- | 10 | 11 |and I...
- 3371 Views
- 5 replies
- 4 kudos
- 4 kudos
@Landan George​ Hey, I am looking into same issue, but when I execute what's suggested in the post for CTE_Recursive https://medium.com/globant/how-to-implement-recursive-queries-in-spark-3d26f7ed3bc9 I get errorError in SQL statement: AnalysisExcep...
- 4 kudos
- 2796 Views
- 1 replies
- 0 kudos
Parent Hierarchy Queries/ Path Function /Recursive CTE's
Problem Statement:We have a scenario where we get the data from the source in the format of (in actual 20 Levels and number of fields are more than 4 but for ease of understanding let’s consider below)The actual code involved 20 levels of 4-5 fields ...
- 2796 Views
- 1 replies
- 0 kudos
- 0 kudos
I don't think that we have anything similar as a built-in function. You'll need to write some custom code to achieve that.
- 0 kudos