Set Up Time Synchronization

Use NTP or some other time-synchronization mechanism to keep all hosts synchronized. Time variances can cause inconsistent query results when using Date/Time Functions or when using a network authentication protocol, like Kerberos.

To verify that the Network Time Protocol Daemon (NTPD) is operating correctly, issue the following command on all nodes in the cluster:

/usr/sbin/ntpq -c rv | grep stratum

A stratum level of 16 indicates that NTP is not synchronizing correctly.

Note: The above links were current as of the last publication of the Vertica documentation and could change between releases.