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

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

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');

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.

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

Hi all!

I put the DC tables names into an Excel spreadsheet and attached to this post.

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