Hi, Is there any support for "Enumerated Types" in Vertica? If not, is there a work around? For example, in MySQL I can create a table with an ENUM data type: (myadmin@localhost) [fsalvelt]> create table e (ecol enum('Bill', 'Sam', 'Jack')); Query OK, 0 rows affected (0.10 sec) Then I can only inser...

Hi guys, If I round a number to "3" decimal places, I still have 5 digits to the right of the decimal: dbadmin=> select round(123.12345, 3); round ----------- 123.12300 (1 row) If I round to "3.0" decimal places, I only have 3 digits to the right of the decimal: dbadmin=> select round(123.12345, 3.0...

Thanks. I've given up on trying to do updates and inserts. We are truncating most tables and just reloading all the data every day.

Hi all, We're trying to use Talend 5.1 to load data into Vertica. Unfortunately we're getting terrible performance with the Vertica SCD component. In fact, we're seeing only about 4 rows per second being inserted/updated into our dimension table! And what's really bad is that we're copying data on t...

Thanks, jpcavanaugh! About the dc_projections_used table, you said: (any access, not just select) There seems to be two distinct values for the io_type column of the dc_projections_used table. dbadmin=> select distinct io_type from dc_projections_used; io_type --------- output input (2 rows) Are the...

Hi, Notice that the following two calls to the COALESCE function in MySQL work as I would expect: MySQL> select coalesce(date '2012-12-12', '1', null, 1); +-------------------------------------------+ | coalesce(date '2012-12-12', '1', null, 1) | +-------------------------------------------+ | 2012-...

Good afternoon!

I work at a firm that would like to know when certain tables in our warehouse schema were last accessed and who did the accessing. Other than scouring the log file is there a way in Vertica to find out which tables a user ran SELECT statements against and when?

Thanks