Search found 61 matches
- Wed Nov 07, 2012 2:01 pm
- Forum: Vertica SQL
- Topic: LAST_VALUE bug?
- Replies: 2
- Views: 6790
LAST_VALUE bug?
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 "...
- Wed Sep 12, 2012 2:52 pm
- Forum: New to Vertica
- Topic: BOOLEAN vs. INT
- Replies: 1
- Views: 5913
BOOLEAN vs. INT
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...
- Thu Aug 23, 2012 7:31 pm
- Forum: Vertica Error Codes
- Topic: ERROR 2792
- Replies: 1
- Views: 16374
ERROR 2792
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...
- Thu Aug 09, 2012 2:08 pm
- Forum: vSQL
- Topic: How to describe a System table
- Replies: 3
- Views: 11207
Re: How to describe a System table
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...
- Thu Aug 09, 2012 1:03 pm
- Forum: Vertica Error Codes
- Topic: Error: INTERNAL: VIAssert(list->length > 0) failed
- Replies: 4
- Views: 21532
Re: Error: INTERNAL: VIAssert(list->length > 0) failed
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...
- Thu Aug 09, 2012 12:46 pm
- Forum: vSQL
- Topic: How to describe a System table
- Replies: 3
- Views: 11207
How to describe a System table
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...
- Wed Aug 08, 2012 1:07 am
- Forum: Vertica SQL
- Topic: NULL vs. Empty String ''
- Replies: 4
- Views: 16298
Re: NULL vs. Empty String ''
Just curious, is there an option to let Vertica treat '' as a null?