Thanks alot for the help
This works perfectly
Search found 5 matches
- Mon Aug 14, 2017 9:51 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 36179
- Fri Aug 11, 2017 9:23 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 36179
Re: Managing Disk space by deleting the older records when the disk is 60% full
Thanks for the reply. We have continuous flow of data in our application. so we are planning to partition based on "PARTITION BY EXTRACT(MONTH FROM eventTime)*100 + EXTRACT(DAY FROM eventTime);" where eventTime is dateTime format. Please let me know if you need more information.
- Thu Aug 10, 2017 4:08 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 36179
Re: Managing Disk space by deleting the older records when the disk is 60% full
Thanks for the reply. Could you please help me out how to get oldest partition in a table.
- Wed Aug 09, 2017 8:43 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 36179
Re: Managing Disk space by deleting the older records when the disk is 60% full
We have 6 tables and we want to delete data from all the tables appropriately.
- Mon Aug 07, 2017 4:26 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 36179
Managing Disk space by deleting the older records when the disk is 60% full
Hi,
I am using vertica for an application which has continuous flow of data. So I want to manage the disk space by creating a cron job which will delete the older records once the disk is 60% full. Could someone please help me to achieve the same.
I am using vertica for an application which has continuous flow of data. So I want to manage the disk space by creating a cron job which will delete the older records once the disk is 60% full. Could someone please help me to achieve the same.