Have you tried loading a sample of data and running Database Designer using that sample table and one or more queries as samples? Low cardinality columns may not impact distribution as much as you th… (View Post)

This should be set by system DNS at startup. Can you run "hostname -A" on the MC host and let us know whether the DNS name is old domain or new domain? (View Post)

Next thing to try is to compare base EXPLAIN plan vs plan using new projection, that is the plan using original projection: EXPLAIN SELECT <fields> FROM TABLE <rest of query>; compared to… (View Post)

Do you need a regex search? The following works, and you can also use SQL wildcard '%' to match: with test_sql_text as (select ' SELECT * FROM CE_EVENT_PRSNL WHERE UPDT_DT_TM > TO_D… (View Post)

Try the following in the container - the VERTICA_MEMDEBUG setting worked for another Mac user: [dbadmin@vertica log]$ export VERTICA_MEMDEBUG=2 [dbadmin@vertica log]$ rm -rf /home/dbadmin/docker/ [db… (View Post)