Search found 21 matches
- Fri Nov 15, 2013 7:57 pm
- Forum: Vertica SQL
- Topic: DISTINCT vs. GROUP BY
- Replies: 2
- Views: 9235
Re: DISTINCT vs. GROUP BY
Thanks. They seem to generate the same explain plan... However, in the example below, the GROUP BY has a lower associated cost? dbadmin=> select count(*) from abc; count ----------- 365496300 (1 row) dbadmin=> explain select distinct a, b, c from abc; QUERY PLAN -------------------------------------...
- Fri Nov 15, 2013 4:30 pm
- Forum: New to Vertica Database Administration
- Topic: Why is the DATE data type 8 bytes?
- Replies: 0
- Views: 3767
Why is the DATE data type 8 bytes?
Hi, Why are dates in Vertica 8 bytes? dbadmin=> create table mydate (d date); CREATE TABLE dbadmin=> select table_name, column_name, data_type, data_type_length from columns where table_name = 'mydate'; table_name | column_name | data_type | data_type_length ------------+-------------+-----------+--...
- Fri Nov 15, 2013 4:21 pm
- Forum: Vertica SQL
- Topic: DISTINCT vs. GROUP BY
- Replies: 2
- Views: 9235
DISTINCT vs. GROUP BY
Is there a difference between DISTINCT and GROUP BY in queries where no aggregate functions are used? Does one perform better on very large data sets?
- Fri Jun 22, 2012 8:37 pm
- Forum: New to Vertica Database Administration
- Topic: The last_statement_duration_us column in the SESSIONS table
- Replies: 1
- Views: 5278
The last_statement_duration_us column in the SESSIONS table
Hi, I have a question about the last_statement_duration_us column in the SESSIONS table. Is this the duration it takes for the query to complete in Vertica or the time it takes to actually send the data off to the client? For instance, I have a query that returns 2.5 million rows. After running the ...
- Tue May 15, 2012 3:39 pm
- Forum: SQuirreL SQL Client
- Topic: SQuirrel and Vertica 5.1.x JDBC Issue!
- Replies: 1
- Views: 15929
SQuirrel and Vertica 5.1.x JDBC Issue!
I've been using DBeaver to connect to Vertica but thought I'd try SQuirrel. It seemed like an okay tool but after upgrading my JDBC driver to 5.1 the EXPLAIN command no longer works but it works fine in DBeaver. Is there an issue with SQuirrel?
Thanks,
Jeff
Thanks,
Jeff
- Tue May 15, 2012 3:31 pm
- Forum: DBeaver
- Topic: DBeaver Forum Link
- Replies: 4
- Views: 24188
DBeaver Forum Link
If you are using DBeaver here is a link to their forums: http://dbeaver.jkiss.org/forum/index.php Here is a link to an post on that site that helped me a few weeks back: Vertica - After a large query all subsequent queries error http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=255&sid=5b73c37f8483...
- Tue May 15, 2012 3:21 pm
- Forum: Vertica Installation
- Topic: Multiple Nodes as VMs on a Single Physical Box
- Replies: 7
- Views: 18456
Multiple Nodes as VMs on a Single Physical Box
Hi, This may be a dumb question, but is it possible to install Vertical on one physical server using multiple VMs for the nodes of a Vertica cluster? Note that this is just for a test playground kind of enviornment. For instance, I'm running Oracle Virtual Box and thought I could create three VMs an...