Search found 15 matches
- Wed Aug 23, 2017 7:09 pm
- Forum: New to Vertica
- Topic: Grouping Millis by Date and Hour
- Replies: 2
- Views: 18975
Re: Grouping Millis by Date and Hour
Hi! dbadmin=> select dbadmin-> mill, dbadmin-> to_timestamp(mill / 1000) as ts, dbadmin-> to_char(to_timestamp(mill / 1000), 'YYYY-MM-DD HH24:MI') as yh dbadmin-> from ts; mill | ts | yh ---------------+-------------------------+------------------ 1484261834099 | 2017-01-13 00:57:14.099 | 2017-01-13...
- Mon Aug 14, 2017 7:16 pm
- Forum: New to Vertica SQL
- Topic: NULL AS 'string' option of the copy command does not work with fcsvparser()
- Replies: 3
- Views: 21905
Re: NULL AS 'string' option of the copy command does not work with fcsvparser()
Hi!
No for Vertica 8.0.6.
No for Vertica 8.0.6.
- Fri Aug 11, 2017 11:38 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 37371
Re: Managing Disk space by deleting the older records when the disk is 60% full
Hi! Thanks for the reply. For nothing, you are welcome. Please let me know if you need more information. It's enough. Ok, lets say out table name is MyTable and table is partitioned by column eventTime (just for example): dbadmin=> select eventTime from MyTable order by eventTime desc; eventTime ---...
- Thu Aug 10, 2017 7:39 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 37371
Re: Managing Disk space by deleting the older records when the disk is 60% full
Hi! Could you please help me out how to get oldest partition in a table. No problem, but I need more info: How do you determine older records ? Can you post a tail of (some) table definition? (tail means all after columns definition) For example: dbadmin=> select export_tables('', 'MyTable'); export...
- Wed Aug 09, 2017 9:29 pm
- Forum: Vertica SQL
- Topic: Managing Disk space by deleting the older records when the disk is 60% full
- Replies: 8
- Views: 37371
Re: Managing Disk space by deleting the older records when the disk is 60% full
Hi! Pseudo algorithm: size = get_disk_size() used = get_disk_usage() ratio = used / size while ratio > 0.6: for each table in db drop an oldest partition used = get_disk_usage() ratio = used / size Dropping Partitions: https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Pa...
- Tue Aug 08, 2017 11:50 pm
- Forum: Vertica Database Administration
- Topic: Remove a node that's never coming back
- Replies: 6
- Views: 28088
Re: Remove a node that's never coming back
Hi!
Jim:
jaspot:
P.S.:
@Jim
I just quoted Vertica docs (with reference/link), nothing more.
Jim:
Not sure the 6.1 docs apply to later releases of Vertica (i.e. 8.1.x)...
jaspot:
We had an eight node cluster on Vertica 6,...
P.S.:
@Jim
I just quoted Vertica docs (with reference/link), nothing more.
- Tue Aug 08, 2017 9:29 pm
- Forum: Vertica Database Administration
- Topic: Remove a node that's never coming back
- Replies: 6
- Views: 28088
Re: Remove a node that's never coming back
Hi! Vertica 6 Removing Hosts from a Cluster : https://my.vertica.com/docs/6.1.x/HTML/index.htm#10282.htm Procedure to Remove Hosts From one of the hosts in the cluster, run update_vertica with the –R switch, where -R specifies a comma-separated list of hosts to remove from an existing HP Vertica clu...