The Vertica Forum recently got a makeover! Let us know what you think by filling out this short survey.
How can I count the number of values that appear in a given interval?
Hi folks! I would like to partition a row into intervals (say 3-hour intervals), and count the number of entries in each interval. It looks like the time_slice function is the one I'm looking for, but it's not clear to me how to write the query. Any help would be very much appreciated! Josiah