Search found 49 matches
- Wed Mar 04, 2015 3:28 pm
- Forum: Vertica Database Administration
- Topic: TxtIndex schema?
- Replies: 1
- Views: 5825
TxtIndex schema?
What is the TxtIndex schema in Vertica 7.1.1? dbadmin=> \dn List of schemas Name | Owner | Comment ------------+---------+--------- v_internal | dbadmin | v_catalog | dbadmin | v_monitor | dbadmin | public | dbadmin | TxtIndex | dbadmin | test | dbadmin | (6 rows)
- Fri Feb 06, 2015 3:15 am
- Forum: Vertica Administration Tools
- Topic: LDAP authentication for the dbadmin user
- Replies: 0
- Views: 12892
LDAP authentication for the dbadmin user
Hi,
Is there a way to use LDAP authorization for the dbadmin user so that I can successfully run admintools? When I try to do this some features in admintools do not work.
Is there a way to use LDAP authorization for the dbadmin user so that I can successfully run admintools? When I try to do this some features in admintools do not work.
- Mon Dec 01, 2014 3:35 am
- Forum: Vertica Data Load
- Topic: Can I tune a COPY statement that uses the AUTO option?
- Replies: 0
- Views: 11826
Can I tune a COPY statement that uses the AUTO option?
Hi all, Is there a way that I can get faster load times when using the COPY command that invokes the AUTO option? I am using Informatica to load data into Vertica. When Informatica generates COPY command in Vertica they use the AUTO option and I have no way of specifying the DIRECT option in the ver...
- Mon Dec 01, 2014 3:13 am
- Forum: New to Vertica Database Administration
- Topic: Unable to reserve memory (X K) for the WOS
- Replies: 1
- Views: 5414
Unable to reserve memory (X K) for the WOS
Hi all,
I am getting a lot of messages like "Unable to reserve memory (17 K) for the WOS" in the error_messages system table.
Can someone explain why I might be seeing these and if there is a way to fix the issue (if it is an issue)?
Thank you.
I am getting a lot of messages like "Unable to reserve memory (17 K) for the WOS" in the error_messages system table.
Can someone explain why I might be seeing these and if there is a way to fix the issue (if it is an issue)?
Thank you.
- Fri Oct 31, 2014 8:36 pm
- Forum: Vertica SQL Functions
- Topic: now() <> sysdate
- Replies: 6
- Views: 27093
Re: now() <> sysdate
I was running the query in vsql. Odd, now when I run it today, it seems ok: [vertica@prod01 ~]$ vsql Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit vertica=> select now(), sysd...
- Thu Oct 30, 2014 10:50 pm
- Forum: Vertica Database Administration
- Topic: Estimate catalog size
- Replies: 1
- Views: 5086
- Thu Oct 30, 2014 10:21 pm
- Forum: Vertica SQL Functions
- Topic: now() <> sysdate
- Replies: 6
- Views: 27093
Re: now() <> sysdate
Thanks, Norbert!
However, why would the minutes and seconds be different? I don't think the timezone affects those quantities.
However, why would the minutes and seconds be different? I don't think the timezone affects those quantities.