Search found 118 matches
- Mon Sep 23, 2013 8:38 pm
- Forum: New to Vertica Database Administration
- Topic: Assign Resource Pool Usage By Time
- Replies: 3
- Views: 7488
Assign Resource Pool Usage By Time
Hey all, I was wondering if we can assign resource pools to a set of users based on time. For instance, I want a set of users from 9-5PM to have a default resource pool with some pretty hefty settings, while at all other times, to have a default resource pool with very limited resource settings. Is ...
- Thu Sep 19, 2013 8:15 am
- Forum: Vertica Database Administration
- Topic: Eporting just projection definitions
- Replies: 10
- Views: 17987
Re: Eporting just projection definitions
Thanks! Perfect solution provided by the community again! I didn't know that the export_objects function work on projections. I thought it only worked on tables
- Wed Sep 18, 2013 12:26 am
- Forum: Vertica Database Administration
- Topic: Eporting just projection definitions
- Replies: 10
- Views: 17987
Eporting just projection definitions
Hey,
How do I export just the projection definitions for a table and not the create table statement? I know I can use the export_objects function, but that includes the table create in the output...
SELECT export_objects('', 'table_name');
How do I export just the projection definitions for a table and not the create table statement? I know I can use the export_objects function, but that includes the table create in the output...
SELECT export_objects('', 'table_name');
- Fri Aug 23, 2013 8:06 pm
- Forum: Vertica Migration
- Topic: SQL Server to Vertica Migration
- Replies: 3
- Views: 18726
Re: SQL Server to Vertica Migration
We ended up just dumping everything to text files, and then loading them into Vertica with the COPY command. It was the fastest way we found.
- Fri Aug 23, 2013 8:31 am
- Forum: Vertica Migration
- Topic: SQL Server to Vertica Migration
- Replies: 3
- Views: 18726
Re: SQL Server to Vertica Migration
Hey, We did a conversion from SQL Server to Vertica... It's not all that easy. There is no equivalent datatype in Vertica for the ntext and image datatypes. The max size for a VARCHAR is 65000. If you have anything bigger you have to break the data up into separate columns. But in a database like Ve...
- Wed Aug 14, 2013 6:18 pm
- Forum: Vertica Database Administration
- Topic: Complete List of Data Collector Tables
- Replies: 5
- Views: 11730
Re: Complete List of Data Collector Tables
Hi all!
I put the DC tables names into an Excel spreadsheet and attached to this post.
I put the DC tables names into an Excel spreadsheet and attached to this post.
- Wed Aug 14, 2013 5:40 pm
- Forum: Vertica Database Administration
- Topic: Complete List of Data Collector Tables
- Replies: 5
- Views: 11730
Re: Complete List of Data Collector Tables
Thanks guys!!! I think both queries produce the same results... Exactly what I needed! dbadmin=> select count(*) from (select table_name, table_description from v_internal.vs_system_tables where table_name ilike 'dc_%') foo; count ------- 149 (1 row) dbadmin=> select count(*) from (SELECT DISTINCT t...