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...

Hi!

No for Vertica 8.0.6.

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 ---...

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...

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...

Hi!

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.

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...