Vertica Forum

Got questions? Use the Vertica forum to get expert advice and connect with other Vertica users. Looking for more? Check out our Vertica Community: https://my.vertica.com/big-data-analytics-community-content/

crash in ResegmentMerge after upgrade to 9.2

phil2 195 views 16 comments 0 points Most recent by Jim_Knicely June 11Vertica Forum
Date/Time Functions are working wrong

manasa95 69 views 0 comments 0 points Started by manasa95 June 11 Vertica Forum
Date/Time Functions are working wrong

manasa95 70 views 0 comments 0 points Started by manasa95 June 11 Vertica Forum
Need to add more storage to Vertica db

bhup521 100 views 2 comments 0 points Most recent by LenoyJ June 11Vertica Forum
I have issue installing Vertica on Cluster

dongtuuyenblackpeony 97 views 1 comment 0 points Most recent by LenoyJ June 11Vertica Forum
tampered license after upgrading 8.0.1 to 8.1.1

Accepted Answer niasar 121 views 5 comments 0 points Most recent by niasar June 10Vertica Forum
How to improve INSERT...SELECT * FROM table - 70GB data

abtsantosbenten 109 views 1 comment 0 points Most recent by Akash_Manakshe June 10Vertica Forum
Why does SELECT * run faster than SELECT <column_list> for this query? Is this a bug?

abtsantosbenten 152 views 2 comments 0 points Most recent by abtsantosbenten June 7Vertica Forum
Does vertica 7.2 version support OEL 7.X versions?

hdk0310 95 views 0 comments 0 points Started by hdk0310 June 7 Vertica Forum
To avoid sending repeated errors using SNMP

Kaito 97 views 0 comments 0 points Started by Kaito June 7 Vertica Forum
HCatalog installaton on Vertica issue (9.0.1-4 version)

DeepDigger 113 views 0 comments 0 points Started by DeepDigger June 6 Vertica Forum
Total Table Row Count Report by Schema

Jim_Knicely 124 views 0 comments 0 points Started by Jim_Knicely June 6 Vertica Tips
how can one monitor daily growth of individual tables

dgrumann 127 views 2 comments 0 points Most recent by Jim_Knicely June 4Vertica Forum
How to update column

Testudinateklev 125 views 5 comments 0 points Most recent by Testudinateklev June 4Vertica Forum
Cannot getting empty result in case

mgvertica 114 views 2 comments 0 points Most recent by Jim_Knicely June 3Vertica Forum
NULL predicate does not behave according to the SQL standard (and e.g. PostgreSQL)

lukaseder 128 views 1 comment 0 points Most recent by Jim_Knicely June 3Vertica Forum
Class Not Found - com.vertica.spark.datasource.DefaultSource

Answered bala_8383 600 views 9 comments 0 points Most recent by LenoyJ May 31Vertica Forum
ERROR 8617: Request size too big (MaxParsedQuerySizeMB)

vasmez81 311 views 3 comments 0 points Most recent by Jim_Knicely May 28Vertica Forum
Vertica Hot-fix Notice 9.2.1-1 May 28, 2019

Vertiguy 147 views 0 comments 0 points Started by Vertiguy May 28 Vertica Forum
vertica certifications

Imran_Shabbir 158 views 9 comments 0 points Most recent by JosephShaw May 27Vertica Forum
Why did the query finish despite error "Join did not fit in memory"

abtsantosbenten 129 views 0 comments 0 points Started by abtsantosbenten May 25 Vertica Forum
Set the Spread Daemon Timeout Back to the Default Value

Jim_Knicely 128 views 0 comments 0 points Started by Jim_Knicely May 24 Vertica Tips
Monitor the Current Value of Node Spread Daemon Timeouts

Jim_Knicely 125 views 0 comments 0 points Started by Jim_Knicely May 24 Vertica Tips
Min and Max Values for Spread Daemon Timeout

Jim_Knicely 128 views 0 comments 0 points Started by Jim_Knicely May 24 Vertica Tips
Adjusting Spread Daemon Timeouts

Jim_Knicely 134 views 0 comments 0 points Started by Jim_Knicely May 24 Vertica Tips
Using Streams in Vertica in a Node js environment

Kray 125 views 0 comments 0 points Started by Kray May 22 Vertica Forum
How to unload One BIG table (containing 200 - 300 Million records) into multiple files

gkaushik 149 views 1 comment 0 points Most recent by chaima May 22Vertica Forum
Evaluate true/false on string saved expression

Answered dimitrys 129 views 1 comment 0 points Most recent by Jim_Knicely May 22Vertica Forum
Vertica 7 JDBC support

ssabrewolf 3.1K views 8 comments 0 points Most recent by quincybatten May 22Vertica Forum
Loading data from non-AWS S3

Answered gytis 315 views 3 comments 0 points Most recent by mbeauchemin May 21Vertica Forum
VerticaClient and odbc

elghali 140 views 0 comments 0 points Started by elghali May 21 Vertica Forum
Sessions are not aborting after Select close_session command as well.

hdk0310 160 views 4 comments 0 points Most recent by hdk0310 May 21Vertica Forum
Include the ALTER and DROP privileges in a GRANT ALL Statement

Jim_Knicely 147 views 0 comments 0 points Started by Jim_Knicely May 20 Vertica Tips
Unexpected EOF on socket error when creating a HCatalog schema (Cloudera Docker VM)

schwanke 273 views 1 comment 0 points Most recent by elghali May 20Vertica Forum
Error while extracting from DbDataReader slowly using Vetica ADO.Net

Edgar_Chavolla 286 views 1 comment 0 points Most recent by elghali May 20Vertica Forum
Watch Out for Data Induced “Cross” Joins

Jim_Knicely 139 views 0 comments 0 points Started by Jim_Knicely May 18 Vertica Tips
Using third party modules like pandas in python udx

Question krmvsingh 153 views 0 comments 0 points Started by krmvsingh May 17 Vertica Forum
Before You Upgrade to Vertica 9.1 or 9.2

SarahL 994 views 9 comments 0 points Most recent by jennie May 17Vertica Forum
Direct Output to /dev/null in VSQL

Jim_Knicely 149 views 0 comments 0 points Started by Jim_Knicely May 16 Vertica Tips
NULL Values do not Count Against Your Vertica License!

Jim_Knicely 139 views 0 comments 0 points Started by Jim_Knicely May 16 Vertica Tips
cannot access database because of MaxClientSessions = 0;

avi120 152 views 3 comments 0 points Most recent by Jim_Knicely May 16Vertica Forum
Add a Column to All of a Table’s Projections

Jim_Knicely 142 views 0 comments 0 points Started by Jim_Knicely May 15 Vertica Tips
View the Query Plan for a COPY Statement

Jim_Knicely 142 views 0 comments 0 points Started by Jim_Knicely May 15 Vertica Tips
In which 8.1.x version was LISTAGG introduced?

Accepted Answer ophers 159 views 2 comments 0 points Most recent by Ariel_Cary May 15Vertica Forum
Details on 9.2.1 wide varchar improvements (VLTS)

Sharon_Cutter 148 views 0 comments 0 points Started by Sharon_Cutter May 14 Vertica Forum
Vertica Hot-fix Notice 9.1.1-9 May 8, 2019

Vertiguy 161 views 0 comments 0 points Started by Vertiguy May 14 Vertica Forum
How to escape characters like backslash (\) in kafkasource

esangrame 150 views 0 comments 0 points Started by esangrame May 14 Vertica Forum
Close All Sessions for a User with a Single Command

Jim_Knicely 167 views 0 comments 0 points Started by Jim_Knicely May 9 Vertica Tips
Problems migrating vertica

kaisersoset 168 views 2 comments 0 points Most recent by Jim_Knicely May 9Vertica Forum
Reading GZIP files from S3 into Vertica

SarahL 1K views 10 comments 0 points Most recent by Jim_Knicely May 8Vertica Tips