AbsaOSS / AbsaOSS/pramen

Add the ability to have metastore partitioning column as a string, not a date

Open
#424 0 comments 0 reactions 0 assignees View on GitHub
DS enhancement Pramen-Scala
Dominant language
Scala
Stars
31
Forks
4
Avg merge
1d 10m
Merged PRs (30d)
4

Description

## Background
Currently, information date format and type are ignored when the metastore persistence format is 'delta'.

For example, here the date format will be ignored:
```hocon
pramen.metastore.tables = [
{
name = "table1"
description = "Table 1 description"
format = "delta"
path = ${base.path}/table1

information.date.column = "info_date"
information.date.format = "yyyyMM"
}
]
```

while here it will work:
```hocon
pramen.metastore.tables = [
{
name = "table1"
description = "Table 1 description"
format = "parquet"
path = ${base.path}/table1

information.date.column = "info_date"
information.date.format = "yyyyMM"
}
]
```

(the only difference is the storage format)

## Feature
Add the ability to have metastore partitioning column as a string, not a date.

## Example
--

## Proposed Solution
Pramen writes Parquet partitions directly, it constructs the path. For Delta we rely on the type system. So I guess we need to treat any date format that is not 'yyyy-MM-dd' as having `string` type.

Code to look: https://github.com/AbsaOSS/pramen/blob/f61438dc012f738de9dab5b2eb198b9914922642/pramen/core/src/main/scala/za/co/absa/pramen/core/metastore/peristence/MetastorePersistenceDelta.scala#L35-L35

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.