Search found 49 matches
- 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: 17430
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...
- Tue Sep 27, 2016 2:09 pm
- Forum: New to Vertica SQL
- Topic: Count Distinct on more than one column?
- Replies: 1
- Views: 17779
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...
- Sun Sep 13, 2015 12:15 am
- Forum: Vertica SQL Functions
- Topic: Use export_objects() to export more than one object?
- Replies: 2
- Views: 20580
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 Thanks for your help in reminding me!
- Fri Sep 11, 2015 3:07 pm
- Forum: Vertica SQL Functions
- Topic: Use export_objects() to export more than one object?
- Replies: 2
- Views: 20580
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:
No luck
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"
- 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: 22078
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...
- Mon Apr 13, 2015 12:43 pm
- Forum: Vertica Database Administration
- Topic: Native Connection Load Balancing: ROUNDROBIN or RANDOM?
- Replies: 3
- Views: 9342
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...
- Sat Mar 28, 2015 11:33 am
- Forum: General
- Topic: Future of Vertica?
- Replies: 6
- Views: 14630
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?