Using a Custom Column Option DELIMITER This example, redefines the default delimiter through the COLUMN OPTION parameter. Create a simple table. CREATE TABLE t( pk INT, col1 VARCHAR(10), col2 VARCHAR(10), col3 VARCHAR(10), col4 TIMESTAMP); Use the COLUMN OPTION parameter to change the col1 default ...

1 & 2 : Gap Filling and Interpolation (GFI) To fills in missing data points and adds new (missing) data points within a range of known data points to the output. Example The following table, which contains two input rows five seconds apart, at 3:00:00 and 3:00:05. => SELECT * FROM TickStore; ts | s...

Can you please issue the following command on all nodes in the cluster to verify that the Network Time Protocol Daemon (NTPD) is operating correctly and post the result.

Which version of Vertica you are using ? Can you try the commands below.
and

Sorry, I forgot a select clause. I have edited my previous reply. From the link that your refer, It look like K-Safety is 2 for the "Buddy Projections (Segmented Projections)" Topic. And you can check Buddy Projects with get_projections function. => SELECT get_projections('customer_dimension'); get_...

Hi nnani, You can use Local Temporary Tables to store a result set from a sub-query using CTAS and then update a target table from a local temporary table. Local Temporary Tables Local temporary tables are created in the V_TEMP_SCHEMA namespace and inserted into the user's search path transparently....

See below. Verify That NTP daemon is Running The network time protocol (NTP) daemon needs to be running on all of the hosts in the cluster to ensure their clocks are synchronized. The spread daemon relies on all of the nodes in the having their clocks synchronized for timing purposes. If your nodes ...