Are DATETIME columns required for tables tied to Indexing Databases?

Solved358 viewsindexing logger logger table logging
2
1 Comment

On the "Logger Table" documentation it mentions that "One column should be of type "DATETIME"". Does this apply to only logger tables in Cassandra or does this also apply to tables connected to indexing databases?

<Database>
<IndexingOptions enabled="true"></IndexingOptions>
<CQLOptions>
<Clustering>0</Clustering>
</CQLOptions>
</Database>

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2024
Micah Brown [SLC] [DevOps Advocate] commented

I’m working on an example & NuGet for a SCTE offloader to an indexing database where the SCTE information only includes a timestamp without a date. The table that it’s using for offloading to the indexing database is also not visible on whatever protocol will use it.

1 Answer

1
676 0 Comments

Hi Micah,

Since the introduction of the Param/Database/Partition@partitionsToKeep attribute, adding a column of type 'DateTime' is not required anymore. That feature was introduced in DataMiner 9.6.0 (See Internal RN 16738).

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2024