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/

Anyone use Microsoft OLAP Cubes here?

scottysak 241 views 1 comment 0 points Most recent by Jim_Knicely April 8Vertica Forum
Live Aggregate Projections to calculate EPS in a system

akumargarai 229 views 1 comment 0 points Most recent by Jim_Knicely April 7Vertica Forum
validation failed. Could not verify the time on hosts

abderahmen 243 views 1 comment 0 points Most recent by abderahmen April 5Vertica Forum
Truncating a Timestamp

Jim_Knicely 217 views 0 comments 0 points Started by Jim_Knicely April 4 Vertica Tips
Vertica client 9.0.1 potential memory leak

Question pegazik 238 views 0 comments 0 points Started by pegazik April 4 Vertica Forum
Vertica client 9.0.1 potential memory leak

pegazik 228 views 0 comments 0 points Started by pegazik April 4 Vertica Forum
Partition a Table By More Than One Column

Jim_Knicely 231 views 0 comments 0 points Started by Jim_Knicely April 3 Vertica Tips
Accept the EULA When Installing Vertica

Jim_Knicely 220 views 0 comments 0 points Started by Jim_Knicely April 3 Vertica Tips
Does Vertica support IPv6?

Leonid_1 305 views 2 comments 0 points Most recent by mosheg April 2Vertica Forum
Vertica does not allow me to create Eon mode database

Accepted Answer raphael_costa 264 views 7 comments 0 points Most recent by raphael_costa April 2Vertica Forum
Fun April Fool’s Day Trick Using Directed Queries

Jim_Knicely 243 views 0 comments 1 point Started by Jim_Knicely April 1 Vertica Tips
Syntax to convert Datetime to Date

NewtoVertica 356 views 1 comment 1 point Most recent by abtsantosbenten March 31Vertica Forum
vertica backups failing with assertion error

sarafumes 306 views 3 comments 0 points Most recent by SruthiA March 29Vertica Forum
Steps for restore from s3

sarafumes 259 views 2 comments 0 points Most recent by sarafumes March 29Vertica Forum
Properly Identifying Identifiers

Jim_Knicely 229 views 0 comments 0 points Started by Jim_Knicely March 29 Vertica Tips
Display a Query Title in VSQL

Jim_Knicely 230 views 0 comments 0 points Started by Jim_Knicely March 29 Vertica Tips
Run the Same Query Over and Over Again in VSQL

Jim_Knicely 229 views 0 comments 0 points Started by Jim_Knicely March 29 Vertica Tips
Pulse Package

opper20 333 views 6 comments 0 points Most recent by s_crossman March 29Vertica Forum
Data Distribution in nodes

saipasupulati 228 views 0 comments 0 points Started by saipasupulati March 28 Vertica Forum
vsql returns error on using with statement

hanans 228 views 1 comment 0 points Most recent by Jim_Knicely March 27Vertica Forum
export to parquet permission denied

honghu 302 views 6 comments 0 points Most recent by honghu March 27Vertica Forum
Clock syncrhonisation limits in a cluster?

Answered qcope 274 views 2 comments 0 points Most recent by qcope March 27Vertica Forum
got exception when using databaseMetaData.getTables

Answered ganpanlin 677 views 2 comments 0 points Most recent by vasmez81 March 26Vertica Forum
MAPLOOKUP working in select clause but not in where clause

nikhil_viz 471 views 0 comments 0 points Started by nikhil_viz March 26 Vertica Forum
Find out When Vertica was Last Updated

Jim_Knicely 243 views 0 comments 0 points Started by Jim_Knicely March 25 Vertica Tips
Conversion between timestamp and timestamptz

savioceg 246 views 1 comment 0 points Most recent by Jim_Knicely March 25Vertica Forum
Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

Jim_Knicely 260 views 0 comments 0 points Started by Jim_Knicely March 20 Vertica Tips
Using sed to Handle Empty String NULL Values Enclosed in Control Characters

Jim_Knicely 259 views 0 comments 0 points Started by Jim_Knicely March 20 Vertica Tips
Vertica monitoring user to access all system tables

hdk0310 263 views 2 comments 0 points Most recent by hdk0310 March 20Vertica Forum
admintools returns "Bus error" message

AliBenMahmoud 247 views 1 comment 0 points Most recent by SruthiA March 19Vertica Forum
Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

Jim_Knicely 289 views 0 comments 0 points Started by Jim_Knicely March 19 Vertica Tips
VerticaError connection attempt failed:could not send SSL negotiation packet: Socket is not connect

Answered mpedroso 277 views 2 comments 0 points Most recent by mpedroso March 17Vertica Forum
Ran out of WOS memory during LOAD

ashishtomer 276 views 2 comments 0 points Most recent by Jim_Knicely March 15Vertica Forum
LDAP Intergration

jnitin123 268 views 1 comment 0 points Most recent by chaima March 15Vertica Forum
Tracking the Current Transaction Start Date and Time

Jim_Knicely 246 views 0 comments 0 points Started by Jim_Knicely March 14 Vertica Tips
increasing thread_count on Vertica

jumanji 271 views 0 comments 0 points Started by jumanji March 14 Vertica Forum
Question about error "join inner did not fit in memory"

llecocq 4.6K views 12 comments 0 points Most recent by Jim_Knicely March 14Vertica Forum
Inserting into a table backed by pre-join projection HASH JOIN problem

Grega_Kešpret 282 views 2 comments 0 points Most recent by Jim_Knicely March 14Vertica Forum
Time taken to complete Copycluster in Vertica?

Nithesh 258 views 3 comments 0 points Most recent by Sharon_Cutter March 13Vertica Forum
Simple ASCII Charting Using SQL

Jim_Knicely 248 views 0 comments 1 point Started by Jim_Knicely March 13 Vertica Tips
Vertica DB performance question

dzhao 279 views 1 comment 0 points Most recent by qinchaofeng March 13Vertica Forum
Set All User’s Default Roles to All of their Granted Roles

Jim_Knicely 288 views 1 comment 1 point Most recent by qinchaofeng March 13Vertica Tips
【Share my blog】

qinchaofeng 259 views 0 comments 0 points Started by qinchaofeng March 13 Vertica Forum
Select by date range and projections for best performance

Answered Alex 279 views 2 comments 0 points Most recent by qinchaofeng March 13Vertica Forum
Explanation on the projections <table_name>_pk

Isabelle_Vela 250 views 0 comments 0 points Started by Isabelle_Vela March 12 Vertica Forum
Is it safe to use -F option on start_db of admintools?

Accepted Answer hrao 484 views 13 comments 0 points Most recent by Sharon_Cutter March 12Vertica Forum
Vertica ERROR: join inner did not fit in memory

Answered mpedroso 299 views 3 comments 0 points Most recent by Sharon_Cutter March 12Vertica Forum
Setting config parameter does not work

alisalem 238 views 1 comment 0 points Most recent by s_crossman March 12Vertica Forum
Arithmetic Bit-shifting

Jim_Knicely 248 views 0 comments 0 points Started by Jim_Knicely March 12 Vertica Tips
most efficient way to insert huge amount of data into vertica

phil2 270 views 0 comments 0 points Started by phil2 March 12 Vertica Forum