AbsaOSS / AbsaOSS/enceladus

Spark date handling settings can mess up dates in Standardization-Conformance combined job

Open
#2,189 0 comments 0 reactions 0 assignees View on GitHub
bug Conformance priority: high Standardization
Dominant language
Scala
Stars
33
Forks
16
PR merge metrics
No merged PRs in 30d

Description

## Describe the bug
While #2175/#2184 solves for the ability to process dates prior to 1900 in Enceladus 3 (without code change), the way how it is done actually introduced a possible bug of messing up the dates.
In case a pair of different settings (LEGACY-CORRECTED) is used for read and write a combined job of Standardization&Conformance will mess up the dates.

## To Reproduce
Steps to reproduce the behavior OR commands run:
1. Have a dataset with timestamps pre 1900 from ambiguous interval
2. Run Standardization & Conformance job with settings read LEGACY, write CORRECTED
3. Dates will be messed up

## Expected behavior
Data should remain correct

## Additional context
Consider adding the information of used date reading standard into the _INFO file.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the Standardization and Conformance combined job with pre-1900 timestamps and LEGACY read versus CORRECTED write settings. Trace how the date-reading and date-writing standards are applied, then verify that dates remain correct and assess whether the used reading standard can be recorded in the _INFO file.

Written by the indexing model from the issue text.

Assessment

Tech stack
scala, spark
Domain
data-engineering
Issue type
Bug
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.