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

I am trying to install on VMWare images on 32bit windows machine, but its always getting installed as 64 and giving error.

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.

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

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

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

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,