Vertica Quick Tip: Extract Time from a Date

Soniya Shah, Information Developer
April 16, 2018

This blog post was authored by Jim Knicely. There are multiple ways to extract just the time from date in Vertica. Which method you choose depends on your preferred result data type. dbadmin=> SELECT * FROM public.test; sysdate | just_time_as_time | just_time_as_varchar ----------------------------+-------------------+---------------------- 2018-04-16 10:17:16.906347 | 10:17:16.906347 | 10:17:16:906347 (1 row) dbadmin=> \d public.test List...

Hierarchical Partitioning

Soniya Shah, Information Developer
April 16, 2018

This blog post was authored by Shrirang Kamat. This document demonstrates how you can use hierarchical partitions, introduced in Vertica 9.0, to solve a few example use cases. For more information, see Hierarchical Partitioning. Partitioning a table helps with managing the information life cycle. Since data for partitions is segregated into different ROS containers, predicates...