Add the ability to have metastore partitioning column as a string, not a date
- Lingua principale
- Scala
- Stelle
- 31
- Fork
- 4
- Merge medio
- 1g 10m
- PR unite (30g)
- 4
Descrizione
## 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
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Valutazione
Questa issue non è ancora stata valutata.