Search found 49 matches

by Brett
Thu Dec 01, 2016 8:01 pm
Forum: Vertica SQL Functions
Topic: How to analyze statistics on all tables in a schema?
Replies: 1
Views: 406

How to analyze statistics on all tables in a schema?

I am trying to analyze the stats on all tables in a schema. Is this possible using the analyze statistics function? I tried the following: dbadmin=> SELECT analyze_statistics('hippies'); ERROR 2065: analyze_statistics: Invalid table/projection/column hippies dbadmin=> SELECT analyze_statistics('hipp...
by Brett
Tue Sep 27, 2016 2:09 pm
Forum: New to Vertica SQL
Topic: Count Distinct on more than one column?
Replies: 1
Views: 978

Count Distinct on more than one column?

Hey all, I can do a count distinct on one column, but not on two columns. dbadmin=> select count(distinct date_key) from sales_fact; count ------- 1826 (1 row) dbadmin=> select count(distinct location_key) from sales_fact; count ------- 1825 (1 row) dbadmin=> select count(distinct date_key, location...
by Brett
Sun Sep 13, 2015 12:15 am
Forum: Vertica SQL Functions
Topic: Use export_objects() to export more than one object?
Replies: 2
Views: 4307

Re: Use export_objects() to export more than one object?

Hmm. I read that doc several times in the past and think I forgot the syntax :oops: Thanks for your help in reminding me!
by Brett
Fri Sep 11, 2015 3:07 pm
Forum: Vertica SQL Functions
Topic: Use export_objects() to export more than one object?
Replies: 2
Views: 4307

Use export_objects() to export more than one object?

Hello,

Being that that the function to export objects is plural (export_objects) I thought we would be able to export more than one object at a time.

I tried this:

Code: Select all

dbadmin=> select export_objects('','table1', 'table2');
ERROR 3680:  Invalid input syntax for boolean: "table2"
No luck :x
by Brett
Fri Jun 12, 2015 3:38 pm
Forum: New to Vertica Database Development
Topic: WARNING 6046: The database is currently 0-safe
Replies: 2
Views: 2199

WARNING 6046: The database is currently 0-safe

Hello, I had a one node cluster running for a dev environment. I then added two more nodes. When I go into vsql, I get the following error: [dbadmin@vertica01 ~]$ vsql WARNING 6046: The database is currently 0-safe, which could result in catastrophic data loss in the event of a failure. Do not use k...
by Brett
Mon Apr 13, 2015 12:43 pm
Forum: Vertica Database Administration
Topic: Native Connection Load Balancing: ROUNDROBIN or RANDOM?
Replies: 3
Views: 2107

Native Connection Load Balancing: ROUNDROBIN or RANDOM?

Hi, With regard to "Native Connection Load Balancing" there are two options: 1. ROUNDROBIN : Chooses the next host from a circular list of currently up hosts in the database (i.e. node #1, node #2, node #3, etc. until it wraps back to node #1 again). Each host in the cluster maintains its own pointe...
by Brett
Sat Mar 28, 2015 11:33 am
Forum: General
Topic: Future of Vertica?
Replies: 6
Views: 2459

Future of Vertica?

It has come into question at my company as to what is the future of Vetrica? Is it the best tech we should being infesting in? We're thinking into the future. Will Vertica still be here 5 years from now?

Go to advanced search