with num_rows as ( select sc.schema_name, p.anchor_table_name as table_name, sum(sc.total_row_count - sc.deleted_row_count) as rows from v_monitor.storage_containers sc join v_catalog.projections p o… (View Post)

The following does NOT cover situations with deleted rows: select table_schema, table_namefrom v_catalog.tablesEXCEPTselect anchor_table_schema, anchor_table_namefrom v_monitor.column_storage; (View Post)

I've tried the following syntax on Vertica 10.x and it works. SELECT STRING_TO_ARRAY('[95.717,95.718,95.717,95.717,95.717]', ','); STRING_TO_ARRAY----------------------------… (View Post)

As mentioned in the other thread, a COMMIT statement suppose to end a transaction and to make all changes that occurred during the transaction permanent and visible to other users. When DML statement… (View Post)

1) Vertica provides functions to encrypt and decrypt data using Voltage SecureData. Some of its advantages: A. The encrypted values have the same overall format as the unencrypted data, so you do not… (View Post)