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!!!
Search found 96 matches
- Tue Nov 26, 2013 10:04 pm
- Forum: Vertica and the Operating System
- Topic: How to delete millions of files in a directory quickly?
- Replies: 1
- Views: 14063
- Thu Nov 14, 2013 2:52 pm
- Forum: Vertica Database Administration
- Topic: Can't update table stats
- Replies: 2
- Views: 5250
Re: Can't update table stats
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...
- Wed Nov 13, 2013 4:59 pm
- Forum: Vertica Database Administration
- Topic: Can't update table stats
- Replies: 2
- Views: 5250
Can't update table stats
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...
- Wed Oct 30, 2013 1:58 pm
- Forum: Vertica SQL Functions
- Topic: REPLICATE function?
- Replies: 2
- Views: 15527
REPLICATE function?
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 ----------...
- Sun Oct 27, 2013 3:43 pm
- Forum: New to Vertica
- Topic: INSERT IGNORE
- Replies: 3
- Views: 9872
Re: INSERT IGNORE
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!
Make sure to check for table dups or handle (i.e. eliminate) them in the ETL process. That's what we do now!
- Tue Oct 15, 2013 1:30 pm
- Forum: Vertica Database Administration
- Topic: Change DB Default Time Zone
- Replies: 2
- Views: 8228
Re: Change DB Default Time Zone
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.
- Mon Oct 14, 2013 2:37 pm
- Forum: Vertica Database Administration
- Topic: Change DB Default Time Zone
- Replies: 2
- Views: 8228
Change DB Default 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...