Hello,

Does anyone have a recommendation on how to delete millions of files in a directory and in sub folders under that directory?

I tried using the rm -rf command but it takes FOREVER!!!

Oops, yeah, the row count is zero. So does Vertica not keep stats on tables for no rows? I thought maybe the stats would simply be "no rows" But I guess that doesn't make sense...

I can't figure out how to update the statistics for one of my tables. This one: dbadmin=> SELECT DISTINCT projection_schema, anchor_table_name FROM projections WHERE has_statistics = 'f'; projection_schema | anchor_table_name -------------------+------------------------------------- primary1 | big_d...

Is there a REPLICATE function in Vertica similar to the one in MS SQL Server? Example from my SQL Server DB: USE AdventureWorks2012; GO SELECT [Name] , REPLICATE('0', 4) + [ProductLine] AS 'Line Code' FROM [Production].[Product] WHERE [ProductLine] = 'T' ORDER BY [Name]; GO Name Line Code ----------...

Brett, you are in luck! Vertica doesn't error when you insert records that violate a primary or unique key

Make sure to check for table dups or handle (i.e. eliminate) them in the ETL process. That's what we do now!

Thanks, Jim! Is there a way to change the time zone without restarting the DB? I'm mainly interested in fixing the timestamps in the vertica.log file so that they are in the appropriate time zone.

Hello, Is there a way that I can change the default time zone of a database? Somehow my DB is using US/Pacific but I want it to use US/Eastern. dbadmin=> show time zone; name | setting ----------+------------ timezone | US/Pacific (1 row) dbadmin=> set timezone US/Eastern; SET dbadmin=> show time zo...