AbsaOSS / AbsaOSS/enceladus

Add ability to configure how Spark handles dates in parquet files.

Open
#2,175 3 comments 0 reactions 1 assignee Claimed by @TebaleloS View on GitHub
Conformance feature priority: medium run scripts Standardization under discussion
Dominant language
Scala
Stars
33
Forks
16
PR merge metrics
No merged PRs in 30d

Description

## Background
With Spark 3 new option were added how to work with dates pre 1900 in parquet files
The settings are:
`spark.sql.parquet.datetimeRebaseModeInRead`
`spark.sql.parquet.datetimeRebaseModeInWrite`
`spark.sql.parquet.int96RebaseModeInRead`
`spark.sql.parquet.int96RebaseModeInWrite`

[Details here](https://spark.apache.org/docs/3.2.0/sql-data-sources-parquet.html).

## Feature
Allow setting of the options for Enceladus jobs
```[tasklist]
### Tasks
- [ ] ~Add command line options to be able to set the **read** options. Set a default behavior either to `EXCEPTION` or `LEGACY`.~
- [ ] ~Modify the helper scripts to recognize these settings~
- [ ] ~Add an `reference.conf`/`application.conf` setting to be applied to write options. The default should be `LEGACY`~
- [ ] Modify the helper scripts to be able to easily send the Spark settings into the `spark submit` - the defaults remain the same as described above
```

## To discuss
* The command line option names
* The command line defaults
* The write configuration names

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.