Search found 13 matches
- Tue Apr 22, 2014 6:45 pm
- Forum: Vertica Database Development
- Topic: Vertica date/time function format
- Replies: 1
- Views: 21020
Vertica date/time function format
Hi, I'm trying to insert current date, and current time into the following table and seems having formatting issues. Could you provide examples how to format to enter values into DATE and TIMESTAMP columns using CAST or TO_CHAR functions. create table t1 (dt DATE, ts TIMESTAMP); insert into (CURRENT...
- Thu Apr 17, 2014 1:47 pm
- Forum: Vertica Installation
- Topic: Where to find Vertica 6.1 32 bit database software
- Replies: 2
- Views: 15188
Re: Where to find Vertica 6.1 32 bit database software
I am trying to install on VMWare images on 32bit windows machine, but its always getting installed as 64 and giving error.
- Thu Apr 17, 2014 3:37 am
- Forum: Vertica Installation
- Topic: Where to find Vertica 6.1 32 bit database software
- Replies: 2
- Views: 15188
Where to find Vertica 6.1 32 bit database software
Hi,
I don't see an option for Vertica 32 bit database software download at my.vertica.com. Could you please provide the link to download 32 bit database software.
I don't see an option for Vertica 32 bit database software download at my.vertica.com. Could you please provide the link to download 32 bit database software.
- Mon Apr 14, 2014 5:39 pm
- Forum: Vertica Database Administration
- Topic: Copy schema statistics
- Replies: 5
- Views: 9538
Re: Copy schema statistics
Could you provide an example of the script or commands that can be used to Generate statistics xml file for every table in that schema? 1. Generate statistics xml file for every table in that schema 2. Concatenate all the xml file in same sequence using shell scripting/Linux commands The whole thing...
- Mon Apr 14, 2014 2:15 am
- Forum: Vertica Database Administration
- Topic: Copy schema statistics
- Replies: 5
- Views: 9538
Copy schema statistics
Hi,
How to copy a schema statistics to other Vertica db? There is a command "export_statistics" but I don't see an option there for schema.
Version: 6.1.2
Regards,
Shazor
How to copy a schema statistics to other Vertica db? There is a command "export_statistics" but I don't see an option there for schema.
Version: 6.1.2
Regards,
Shazor
- Mon Mar 03, 2014 8:06 pm
- Forum: Vertica Database Administration
- Topic: Granting privileges on v_monitor and v_catalog schemas
- Replies: 4
- Views: 10008
Granting privileges on v_monitor and v_catalog schemas
Hi,
How to grant SELECT privileges on v_monitor and v_catalog tables to user? Some of the system tables are not accessible and getting the following error message?
select * from active_events;
ERROR: Permission denied for relation active_events
How to grant SELECT privileges on v_monitor and v_catalog tables to user? Some of the system tables are not accessible and getting the following error message?
select * from active_events;
ERROR: Permission denied for relation active_events
- Mon Feb 10, 2014 3:49 pm
- Forum: Vertica Database Development
- Topic: Errors while running DBD
- Replies: 4
- Views: 24287
Re: Errors while running DBD
Hi,
Awaiting for your reply. I need more details on where all "fail" parameters need to be modified. Is it something on OS or within Vertica DB.
Thanks,
Awaiting for your reply. I need more details on where all "fail" parameters need to be modified. Is it something on OS or within Vertica DB.
Thanks,