Hi jbaskin, You can set the MaxClientSessions parameter to 0 to disable any new connections and close any current sessions with the CLOSE_SESSION function. Use this statement in vsql to set the MaxClientSessions parameter to 0: SELECT SET_CONFIG_PARAMETER ('MaxClientSessions', 0); And here is a link...

Hi wlam, I don't think the syntax for this statement is correct: select x,y,z from foo timeseries XX as '30 second' over (partition by x,y order by z) That is, you can't select z if it's not part of the partition column list... Example: dbadmin=> select * from ts_test order by 1, 2, 3; item | price ...

fsavalt: You can't add comments on table columns. The comments for columns need to be on the table's projection columns. For instance: dbadmin=> CREATE TABLE title (title_key int); CREATE TABLE dbadmin=> SELECT projection_name FROM projection_storage WHERE anchor_table_name = 'title'; projection_nam...

Great discussion "Playdom Ups Its Game By Analyzing Customer Behavior Data" @ http://www.tableausoftware.com/learn/st ... ht-playdom

Hi Josh, There isn't a built in function like ISNUMERIC, but you can create your own. Example: dbadmin=> create function isnumeric(x varchar) return varchar dbadmin-> as dbadmin-> begin dbadmin-> return REGEXP_COUNT(x, '^[0-9.-]+$'); dbadmin-> dbadmin-> end; CREATE FUNCTION dbadmin=> select col1, is...

Hi,

Have you tried signing up again? Vertica seems pretty good about getting folks hooked up with CE.

Thanks!

wlam, I'm not sure exactly sure how Vertica determines the very first start time stamp for a given time slice. However, I think it is important to note that there isn't one single starting point for all time slices... There appears to be an absolute start time stamp for each distinct slice_length an...