mosheg
Administrator
-
Re: Optimizing Vertica Schemas for a Low Latency Application
1) Flattened tables will run faster joins and will save the need to code joins, but not unions. 2) If the tables you need to run the union on, have partitions and have the same schema structure, you … (View Post)2 -
Re: Vertica Stored Procedure Scheduler?
Scheduled execution of stored procedures development is on the roadmap with no ETA yet, And is subject to change without notice. (View Post)1 -
Re: If the sql text is saved in a table how to search for particular text using like operator
In addition, Standard conforming strings must be ON to use Unicode-style string literals (U&'\nnnn'). For example: SET ESCAPE_STRING_WARNING TO OFF; -- Do not issue a warning when a bac… (View Post)1 -
Re: Need to add column with max value placed in the max date of each weekending
SET DATESTYLE TO DMY;\set StartDate '''01-Jan-2022'''\set EndDate '''01-FEB-2022'''CREATE TABLE t30 ASSELECT 'A' || CHR(RANDOMINT… (View Post)1 -
Re: Vertica Query to find and subtract skips in time
set datestyle to DMY;select *, datediff('second', start_time_utc, lag(end_time_utc) over (order by start_time_utc) ) as skip_time_sfrom skip_timeorder by user_name,row; user_name | start_da… (View Post)1
