Search found 13 matches

by shaz001
Tue Apr 22, 2014 6:45 pm
Forum: Vertica Database Development
Topic: Vertica date/time function format
Replies: 1
Views: 3960

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...
by shaz001
Thu Apr 17, 2014 1:47 pm
Forum: Vertica Installation
Topic: Where to find Vertica 6.1 32 bit database software
Replies: 2
Views: 1664

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.
by shaz001
Thu Apr 17, 2014 3:37 am
Forum: Vertica Installation
Topic: Where to find Vertica 6.1 32 bit database software
Replies: 2
Views: 1664

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.
by shaz001
Mon Apr 14, 2014 5:39 pm
Forum: Vertica Database Administration
Topic: Copy schema statistics
Replies: 5
Views: 1519

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...
by shaz001
Mon Apr 14, 2014 2:15 am
Forum: Vertica Database Administration
Topic: Copy schema statistics
Replies: 5
Views: 1519

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
by shaz001
Mon Mar 03, 2014 8:06 pm
Forum: Vertica Database Administration
Topic: Granting privileges on v_monitor and v_catalog schemas
Replies: 4
Views: 2200

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
by shaz001
Mon Feb 10, 2014 3:49 pm
Forum: Vertica Database Development
Topic: Errors while running DBD
Replies: 4
Views: 2592

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,

Go to advanced search