Product Documentation

FairCom Database Engine Partitioned Files

Previous Topic

Next Topic

Partition by Timestamp Rule Modified to Support GMT/UTC Time

When an attempt to read data from a partitioned file on a machine whose time zone differs from the time zone on the machine that stored the data, the data was not found. This happened as the function that maps the partition key, a timestamp, to a partition number, converts the timestamp to year, month, and day using the local time zone. To provide a consistent mapping of timestamp values to year, month, and day (which determines the partition number), an additional option has been added using GMT instead of the local time zone to convert the timestamp value.

TOCIndex