Hi guys, Check out the query below. I don't understand the results of the "Last order by col1" and "Last order by col2" columns. Shouldn't "Last order by col1" be equal to "E" and "Last order by col2" be equal to "A"?!?! dbadmin=> SELECT col1, dbadmin-> col2, dbadmin-> first_value(col1) over () AS "...

Hi, Are there any recommendations for using the BOOLEAN data type over an INT data type to represent true or false type columns? I see that the BOOLEAN data type has a smaller footprint (size 1 vs size 8): dbadmin=> CREATE TABLE boolean_test (c1 BOOLEAN, c2 INT); CREATE TABLE dbadmin=> \d boolean_te...

Hello, Is there a way around the error "ERROR 2792: Correlated subquery with aggregate function COUNT is not supported". Simple example: vert01=> create table test (c1 int, c2 int); CREATE TABLE dbadmin=> select c1, c2, (select count(c2) from test t2 where t2.c1 = t1.c1 and t2.c2 = 0) c2_sum from te...

Cool, thanks! The system_columns table has what I'm looking for: dbadmin=> select column_name, data_type from system_columns where table_name = 'sessions'; column_name | data_type ----------------------------+--------------- node_name | varchar(128) user_name | varchar(128) client_hostname | varchar...

Becky, Thanks for your interest in this odd error... Here is a script to use to create the tables with data... the queries I used are at the bottom. create table emp (ename varchar(100), sal int, dname varchar(100)); create table dept (dname varchar(100)); insert into dept values ('ACCOUNTING'); ins...

Hi guys, How do I describe a system table in vsql with the \d meta command? dbadmin=> \dS sessions; List of tables Schema | Name | Kind | Description | Comment -----------+----------+--------+-----------------------------+--------- v_monitor | sessions | system | Information on each Session | (1 row...

Just curious, is there an option to let Vertica treat '' as a null?