General Discussion

Archives for May 2019

Cannot getting empty result in case

mgvertica 3.4K views 2 comments 0 points Most recent by Jim_Knicely June 2019General Discussion
Cannot getting empty result in case

Answered mgvertica 3.7K views 2 comments 0 points Most recent by mgvertica June 2019General Discussion
NULL predicate does not behave according to the SQL standard (and e.g. PostgreSQL)

lukaseder 2.3K views 1 comment 0 points Most recent by Jim_Knicely June 2019General Discussion
Why does SELECT * run faster than SELECT <column_list> for this query? Is this a bug?

abtsantosbenten 3.4K views 2 comments 0 points Most recent by abtsantosbenten June 2019General Discussion
Why did the query finish despite error "Join did not fit in memory"

abtsantosbenten 1.2K views 0 comments 0 points Started by abtsantosbenten May 2019 General Discussion
Using Streams in Vertica in a Node js environment

Kray 1.2K views 0 comments 0 points Started by Kray May 2019 General Discussion
Evaluate true/false on string saved expression

Answered dimitrys 2.4K views 1 comment 0 points Most recent by Jim_Knicely May 2019General Discussion
How to unload One BIG table (containing 200 - 300 Million records) into multiple files

gkaushik 2.5K views 1 comment 0 points Most recent by chaima May 2019General Discussion
VerticaClient and odbc

elghali 1.2K views 0 comments 0 points Started by elghali May 2019 General Discussion
vertica certifications

Imran_Shabbir 15.9K views 12 comments 0 points Most recent by Oliverwang July 2020General Discussion
Unable to Import Existing Vertica Cluster via Management Console

verban 48.4K views 31 comments 0 points Most recent by verban September 2020General Discussion
Using third party modules like pandas in python udx

Answered krmvsingh 2.4K views 1 comment 0 points Most recent by SruthiA August 2019General Discussion
cannot access database because of MaxClientSessions = 0;

avi120 5.2K views 3 comments 0 points Most recent by Jim_Knicely May 2019General Discussion
In which 8.1.x version was LISTAGG introduced?

Answered ✓ ophers 3.7K views 2 comments 0 points Most recent by Ariel_Cary May 2019General Discussion
Details on 9.2.1 wide varchar improvements (VLTS)

Sharon_Cutter 1.2K views 0 comments 0 points Started by Sharon_Cutter May 2019 General Discussion
Sessions are not aborting after Select close_session command as well.

hdk0310 5.9K views 4 comments 0 points Most recent by hdk0310 May 2019General Discussion
How to escape characters like backslash (\) in kafkasource

esangrame 1.2K views 0 comments 0 points Started by esangrame May 2019 General Discussion
Problems migrating vertica

kaisersoset 3.5K views 2 comments 0 points Most recent by Jim_Knicely May 2019General Discussion
"memory_inuse_kb" of 'general' resource pool keeps increasing

Answered gjorgjevski 2.3K views 1 comment 0 points Most recent by SruthiA June 2019General Discussion
Export Parquet files to HDFS

elchen 3.8K views 2 comments 0 points Most recent by SruthiA May 2019General Discussion
Error while writing to vertica from spark using Vertica spark connector

Arunrajva 19.4K views 10 comments 0 points Most recent by Arunrajva May 2019General Discussion
Restoring Vertica to a cluster with different IPs

bergman 2.4K views 1 comment 0 points Most recent by DaveT May 2019General Discussion
Stats not reflected in System tables

esangrame 4.5K views 3 comments 0 points Most recent by esangrame May 2019General Discussion
timestamptz time is off by one hour

bf4688 1.3K views 0 comments 0 points Started by bf4688 May 2019 General Discussion
Query to generate rows dynamically

Answered ✓ aniruddha20 13.1K views 6 comments 0 points Most recent by Jim_Knicely May 2019General Discussion