Vertica Forum

Query planning & performance when using views

Antoine_Niek 421 views 0 comments 0 points Started by Antoine_Niek June 2013
enterprise edition

yamy_Vissel 324 views 5 comments 0 points Most recent by [Deleted User] June 2013
Step: "Waiting for 1 of 3 site" Taking too much time.

Roberto_Argenta 312 views 6 comments 0 points Most recent by Gennadiy June 2013
How do I load a trusted CA certificate for LDAPS (LDAP over TLS) authentication?

Michael_Johnson_1 337 views 0 comments 0 points Started by Michael_Johnson_1 June 2013
Can't create database

Ken_Lee 1K views 24 comments 0 points Most recent by Sri_1 June 2013
Configuring HDFS connector for Horton Works distribution

Hans_Lutz 312 views 0 comments 0 points Started by Hans_Lutz June 2013
Unaligned output, no messages, retain headers

nick_ursa 302 views 1 comment 0 points Most recent by Jason_Blais June 2013
Bad grammar in an error message: "Could not write to [....]: Volume [...] is has insufficient space.

boxed 316 views 0 comments 0 points Started by boxed June 2013
Bad grammar in an error message: "Could not write to [....]: Volume [...] is has insufficient space.

boxed 343 views 0 comments 0 points Started by boxed June 2013
Performance of Views compared to tables

Manu_Manohar 355 views 2 comments 0 points Most recent by Manu_Manohar June 2013
Analyze_histogram and statistics in Vertica 6.1

Sam_2 368 views 1 comment 0 points Most recent by [Deleted User] June 2013
Error: Database errors occurred: server closed the connection unexpectedly

vijayakumar 350 views 2 comments 0 points Most recent by Praveen_1 June 2013
How do I unload a Vertica table to a flat file?

Cece_Shetline_V 490 views 4 comments 0 points Most recent by Steve_O_Hara June 2013
Mysql to Vertica

Chris_Parker 404 views 4 comments 0 points Most recent by Steve_O_Hara June 2013
Small table: Too many ROS containers exist for the following projections

Katrin_Pfistere 447 views 2 comments 0 points Most recent by Katrin_Pfistere June 2013
Best way to estimate ETA for a refresh request

Shawn_Ferris 367 views 2 comments 0 points Most recent by Shawn_Ferris June 2013
Insert into varchar column

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

Guillaume_Pless 392 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 352 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 423 views 2 comments 0 points Most recent by Mireille_Esteph June 2013
Pad Extra Columns in Bulk Insert

Ravi_Vijay 333 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 312 views 1 comment 0 points Most recent by [Deleted User] June 2013
Can't use derived column name in SQL predicate

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

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

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

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

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

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

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

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

[Deleted User] 344 views 0 comments 0 points Started by [Deleted User] June 2013
Upgrade Path: Is skipping a version fatal?

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

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

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

Mike_Gong_1 377 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 526 views 13 comments 0 points Most recent by eli_revach June 2013
Setting memory limits for ENABLE_JOIN_SPILL

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

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

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

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

Navin_C 3.1K 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 312 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 342 views 1 comment 0 points Most recent by [Deleted User] May 2013
R-function kmeans

Karin_1 346 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 314 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 325 views 1 comment 0 points Most recent by [Deleted User] May 2013
Revoking a node from the vertica cluster failed

Jian_Zhou 333 views 2 comments 0 points Most recent by Jian_Zhou May 2013
Install Vertica in AWS EC2

Mike_Gong_1 312 views 1 comment 0 points Most recent by [Deleted User] May 2013
Target Memory Determination for Queries in Concurrent Environments

bennyflint 314 views 2 comments 0 points Most recent by [Deleted User] May 2013
Table reorganize background process is "stuck"

David_1 345 views 2 comments 0 points Most recent by [Deleted User] May 2013