Search found 1825 matches
- Wed Apr 18, 2012 8:55 pm
- Forum: New to Vertica Database Administration
- Topic: Single User Mode
- Replies: 3
- Views: 8040
Re: Single User Mode
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...
- Wed Apr 18, 2012 8:46 pm
- Forum: Vertica SQL
- Topic: TIMESERIES clause
- Replies: 4
- Views: 10835
Re: TIMESERIES clause
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 ...
- Wed Apr 18, 2012 2:01 pm
- Forum: New to Vertica
- Topic: Add table column comments...
- Replies: 1
- Views: 8654
Re: Add table column comments...
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...
- Wed Apr 18, 2012 1:03 pm
- Forum: Vertica Links
- Topic: Disney's Playdom and Vertica
- Replies: 0
- Views: 5733
Disney's Playdom and Vertica
Great discussion "Playdom Ups Its Game By Analyzing Customer Behavior Data" @ http://www.tableausoftware.com/learn/st ... ht-playdom
- Mon Apr 16, 2012 2:26 pm
- Forum: Vertica SQL
- Topic: ISNUMERIC Function?
- Replies: 3
- Views: 21358
Re: ISNUMERIC Function?
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...
- Fri Apr 13, 2012 11:35 pm
- Forum: Vertica Community Edition
- Topic: Still not contacted!
- Replies: 1
- Views: 14970
Re: Still not contacted!
Hi,
Have you tried signing up again? Vertica seems pretty good about getting folks hooked up with CE.
Thanks!
Have you tried signing up again? Vertica seems pretty good about getting folks hooked up with CE.
Thanks!
- Fri Apr 13, 2012 2:25 pm
- Forum: Vertica SQL
- Topic: time_slice
- Replies: 7
- Views: 17234
Re: time_slice
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...