General Discussion

Discussion channel for questions, answers, and conversations among Vertica users and employees.

Insert into varchar column

Mike_Gong_1 14.3K views 5 comments 0 points Most recent by [Deleted User] June 2013
Where is the the 32-bits Linux client?

Guillaume_Pless 14.1K views 5 comments 0 points Most recent by Guillaume_Pless June 2013
Can Smallish ref tables have full data on each node? To improve join performance?

Jim_Knoll 9.2K views 3 comments 0 points Most recent by [Deleted User] June 2013
ERROR 4588: Request size too big. Please try to simplify the query

Mireille_Esteph 7.1K views 2 comments 0 points Most recent by Mireille_Esteph June 2013
Pad Extra Columns in Bulk Insert

Ravi_Vijay 4.4K views 1 comment 0 points Most recent by [Deleted User] June 2013
Can I limit amount of data stored in a schema?

Sean_O_Riordan 4.4K views 1 comment 0 points Most recent by [Deleted User] June 2013
Can't use derived column name in SQL predicate

Pradeep_Dash 4.5K views 1 comment 0 points Most recent by Bhawana June 2013
about foreign key

Mike_Gong_1 4.7K views 1 comment 0 points Most recent by [Deleted User] June 2013
How to define character set?

Mike_Gong_1 7K views 2 comments 0 points Most recent by Mike_Gong_1 June 2013
Computed field in Select clause

Zacharia_Mathew 11.8K views 4 comments 0 points Most recent by Zacharia_Mathew_1 June 2013
Optimize projection for delete

Guillaume 11.8K views 4 comments 0 points Most recent by Guillaume June 2013
Problem with two R UDFs

Jüri_Kuusik 4.6K views 1 comment 0 points Most recent by Jüri_Kuusik June 2013
not able to delete data

Ravi_Vijay 7.1K views 2 comments 0 points Most recent by Ravi_Vijay June 2013
Management console access in community edition

saumya_tamma 6.8K views 2 comments 0 points Most recent by saumya_tamma June 2013
Spread issue when creating database on CentOS - issue/workaround

[Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] June 2013
Upgrade Path: Is skipping a version fatal?

Jack_Kidwell 4.4K views 1 comment 0 points Most recent by [Deleted User] June 2013
phantom rows in grants system table

Pietro_La_Torre 16.5K views 6 comments 0 points Most recent by [Deleted User] June 2013
where are the SMEs?

pete_adams 11.6K views 4 comments 0 points Most recent by [Deleted User] June 2013
Install Vertica RPM in Amazon EC2

Mike_Gong_1 7K views 2 comments 0 points Most recent by Mike_Gong_1 June 2013
Resource Management best practices for “ WOS Full; failover to DIRECT” message

eli_revach 33.9K views 13 comments 0 points Most recent by eli_revach June 2013
Setting memory limits for ENABLE_JOIN_SPILL

Shyam_Katti 9.7K views 3 comments 0 points Most recent by [Deleted User] June 2013
SELECT CLAUSE in UDF

Navin_C 4.4K views 1 comment 0 points Most recent by [Deleted User] May 2013
Vertica - database as a service

eli_revach 9.3K views 3 comments 0 points Most recent by mcgoverntheory May 2013
No exceptions on violating queries via JDBC

Max_1 21.5K views 8 comments 0 points Most recent by Max_1 May 2013
Need IF ELSE functionality workaround

Navin_C 20.7K views 5 comments 0 points Most recent by Navin_C May 2013
how vertica know the values come from the same row since each column are stored in different files

Vincent_1 4.4K views 1 comment 0 points Most recent by [Deleted User] May 2013
how can vertica know the position of a row in each columns

Vincent_1 4.5K views 1 comment 0 points Most recent by [Deleted User] May 2013
R-function kmeans

Karin_1 9.3K views 3 comments 0 points Most recent by [Deleted User] May 2013
Hi What is the datatype need to use for storing date , time along with meridain indicator

Satyagopal_Voor 4.4K views 1 comment 0 points Most recent by wwong2 May 2013
Vertica-R: is it mandatory to login using superuser to create Library?

mayank_gupta 4.4K views 1 comment 0 points Most recent by [Deleted User] May 2013