If the table where you store the votes gets a new row each time a vote is made, consider a Live Aggregate Projection that contains SUM(vote) GROUP BY (<whatever_makes_sense>). This way, you don… (View Post)

This smells like a rounding problem ... As a test: Try to put into the select list of the query: , txnYesterday.AverageBasketSizeEUR, agg90Days.avg90DayAverageBasketSizeEUR + 4 * agg90Days.stddev90Da… (View Post)

Very probably, you have a messed up order in the WHEN MATCHED THEN UPDATE or the WHEN NOT MATCHED THEN INSERT branches of the statement - or both. It does not happen by name, but by order of columns.… (View Post)

How do you materialize a WITH clause? By creating a temp table behind the scenes. A CREATE LOCAL TEMPORARY TABLE foo ... is a DDL statement. DDL statements cause an implicit COMMIT. A COMMIT ends the… (View Post)

Cleanest way would be: A batch file: REM copyexample.bat@ECHO OFFset VSQL_USER=dbadminset VSQL_PASSWORD=passwordset VSQL_HOST=marcos-ubuntuset VSQL_DATABASE=sbx"C:\Program Files\Vertica Systems\… (View Post)