Well I'll be darned. Thanks, Rajasekhar! That's why I created this site, so that I can learn from others. Not sure how I missed this in the documentation...

To my understanding of the function, the values of a and b will not change. They will always display the values at the time of the time slice. The values of a and b have to also correspond to actual values in the table. Vertica won't derive some arbitrary value for a and b based on a time slice. You...

Probably because they're an analytic database platform provider There are already a number of free graphical client tools that can be used to access the data. Try one of them.

I don't think so, at least not without a written agreement with Vertica... Note the bold red section below in the TERMS AND CONDITIONS... 1. Definitions. As used in this Agreement, the following terms will have the following meanings: Designated Use: the right to download from Vertica, install, load...

Hey, Great question! The answer is no... When you do a CTAS in Vertica, the IDENTITY property does not propagate to the new table: Example: dbadmin=> create table foo (col1 auto_increment, col2 varchar(100), primary key(col1)); CREATE TABLE dbadmin=> \d foo; List of Fields by Tables Schema | Table |...

Hi, In MySQL the group_concat function is used to returns a string result with the concatenated non-NULL values from a group. Example from MySQL: (mydbadmin@localhost) [jim]> select * from combine; +--------+ | name | +--------+ | raj | | sekhar | | nicely | +--------+ 3 rows in set (0.00 sec) (mydb...

Rajasekhar, In MySQL it's very easy to do that! Example: (mydbadmin@localhost) [jim]> select * from combine; +--------+ | name | +--------+ | raj | | sekhar | | nicely | +--------+ 3 rows in set (0.00 sec) (mydbadmin@localhost) [jim]> select group_concat(name) from combine; +--------------------+ | ...