Search found 21 matches

by JeffSatler
Fri Nov 15, 2013 7:57 pm
Forum: Vertica SQL
Topic: DISTINCT vs. GROUP BY
Replies: 2
Views: 2027

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 -------------------------------------...
by JeffSatler
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: 609

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 ------------+-------------+-----------+--...
by JeffSatler
Fri Nov 15, 2013 4:21 pm
Forum: Vertica SQL
Topic: DISTINCT vs. GROUP BY
Replies: 2
Views: 2027

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?
by JeffSatler
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: 920

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 ...
by JeffSatler
Tue May 15, 2012 3:39 pm
Forum: SQuirreL SQL Client
Topic: SQuirrel and Vertica 5.1.x JDBC Issue!
Replies: 1
Views: 1736

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
by JeffSatler
Tue May 15, 2012 3:31 pm
Forum: DBeaver
Topic: DBeaver Forum Link
Replies: 4
Views: 4767

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...
by JeffSatler
Tue May 15, 2012 3:21 pm
Forum: Vertica Installation
Topic: Multiple Nodes as VMs on a Single Physical Box
Replies: 7
Views: 5901

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...

Go to advanced search