Search found 149 matches

by jpcavanaugh
Mon Dec 17, 2012 2:01 pm
Forum: New to Vertica Database Administration
Topic: How to Generate Custom data files
Replies: 3
Views: 7297

Re: How to Generate Custom data files

What error if any are you getting when you do this?
by jpcavanaugh
Fri Dec 14, 2012 3:17 pm
Forum: New to Vertica Database Administration
Topic: Limit rows by user?
Replies: 5
Views: 9576

Re: Limit rows by user?

Can you lock down the main table and only give users access to views which limit correctly?
by jpcavanaugh
Wed Dec 12, 2012 5:16 pm
Forum: Vertica SQL
Topic: P-Value function/calculation
Replies: 1
Views: 5163

Re: P-Value function/calculation

Can you try using R to find this? Remember, R runs in the database in version 6+
by jpcavanaugh
Wed Dec 05, 2012 9:46 am
Forum: PHP
Topic: ODBC driver on MacOS
Replies: 1
Views: 15814

Re: ODBC driver on MacOS

Try setting this to see if it makes a difference.

DYLD_LIBRARY_PATH=:/Library/ODBC/vertica/lib
by jpcavanaugh
Fri Nov 30, 2012 9:17 pm
Forum: Vertica Migration
Topic: Replication problems!
Replies: 1
Views: 14956

Re: Replication problems!

If the table has a PK, look into ANSI Merge
by jpcavanaugh
Fri Nov 30, 2012 1:30 pm
Forum: Vertica Database Development
Topic: Change PARTITION in Vertica 5.1
Replies: 1
Views: 5639

Re: Change PARTITION in Vertica 5.1

I do not believe you could add partitioning on a table after it was created before version 6.

Go to advanced search