51zero / 51zero/eel-sdk

JsonSource should support path expressions

Open
#240 2 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Scala
Stars
147
Forks
32
PR merge metrics
No merged PRs in 30d

Description

# JsonSource should support path expressions

# Scenario

- If I have defined a structure like the following:
```sql
struct Person {
name:String,
age: Int,
sex: String
}
```
- I should be able to specify a projection like so:
```scala
withProjection("person.name", "person.age")
```

- The above returns scalar values for name and age.
- Likewise I think it should work for **withPredicate**
- Jackson has has processor for drilling into nested types using path expressions which are similar to XPath
- You could put forward a case that this syntax should be the language for other formats that support nested types, Avro, Parquet and Orc

Contributor guide

No contributing guide indexed for this repository

Research direction

Look at the JsonSource class and its withProjection and withPredicate methods. Understand how Jackson's path expression processor works for nested types. Check similar handling in Avro, Parquet, and Orc formats within the SDK. The goal is to extend support for path expressions like 'person.name' to return scalar values from nested structures.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, scala
Domain
data-engineering, tooling
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.