Vertica does not provide a built-in event-driven startup hook to execute scripts automatically when the database starts. However, the provided Bash script can be used to detect when Vertica starts by… (View Post)

Please try the following: -- Create simple partitioned tableCREATE TABLE t (c INT NOT NULL) PARTITION BY (c);-- Insert initial dataINSERT INTO t SELECT 201907;-- Merge partitionsSELECT do_tm_task('me… (View Post)

This behavior is not necessarily related to the Vertica JDBC client, as DBeaver, using the same JDBC client, displays arrays in square brackets [], while DbVisualizer uses curly brackets {} for array… (View Post)

The requested post is attached. Configure JDBC clients to Work with Your Kerberos-Enabled Vertica Cluster: DbVisualizer, DBeaver, and Others Posted August 1, 2017 by Sarah Lemaire (View Post)

Projections that include all columns and rows of the anchor table can be considered superprojections in Vertica. Therefore, ranged projections, even if they include all columns, would not be counted … (View Post)