copy

ignoring duplicates during COPY

Question prad33p2301 148 views 0 comments 0 points Started by prad33p2301 July 18 General Discussion

Skipping the columns during data load to Vertica using COPY command

Answered Phantom 1.5K views 1 comment 0 points Most recent by marcothesane March 13General Discussion

COPY's usage with complex types - ARRAY

Answered xpegenaute 2.1K views 1 comment 0 points Most recent by marcothesane November 2023General Discussion

Using filler with COPY..FAVROPARSER?

Answered ✓ yurmix 13.9K views 5 comments 0 points Most recent by yurmix February 2022General Discussion

COPY format for ISO8601 date time value

Answered kamil_kliczbor 6.6K views 2 comments 0 points Most recent by marcothesane September 2021General Discussion

Copy statement fails in 10.1, works in 9.0

Answered mark_d_drake 6.3K views 2 comments 0 points Most recent by Hibiki July 2021General Discussion

Storing source file names when loading data

Question Bryan_H 1.3K views 0 comments 0 points Started by Bryan_H May 2021 Tips from the Team

Copy with Delayed_Creation Failed

Michael_Pacocha 28.7K views 11 comments 0 points Most recent by Nimmi_gupta March 2021General Discussion

copy from local, autogenerate line number

Answered ✓ alexisos 23.8K views 9 comments 0 points Most recent by alexisos February 2021General Discussion

Vertica: Cannot allocate sufficient memory for copy statement

Answered PavanVejju 33.2K views 8 comments 0 points Most recent by SruthiA January 2021General Discussion

Copy entire Vertica database or restore backup into database of different name

Answered Pieter_Sheth-Vo 9K views 3 comments 0 points Most recent by SruthiA November 2020General Discussion

Replication VBR deleted the data

Answered veerkumar 9K views 3 comments 0 points Most recent by viganog October 2020General Discussion

COPY: Error occurred during ZLIB decompression. ZLIB error code: -3, Message: invalid block type

Answered karthik 8.1K views 2 comments 0 points Most recent by karthik October 2020General Discussion

LOAD a CSV

Answered yeifer 17.5K views 6 comments 0 points Most recent by marcothesane August 2020General Discussion

vertica constraint enforcement and deduplication

Answered ✓ rajatpaliwal86 17.1K views 6 comments 0 points Most recent by rajatpaliwal86 May 2020General Discussion

Does vertica text index creation needs X Exclusive lock on the source table

Answered ✓ rajatpaliwal86 10.8K views 2 comments 0 points Most recent by Jim_Knicely April 2020General Discussion

Does Vertica provide upsert support while loading data?

Answered vmnnn 7.4K views 2 comments 0 points Most recent by vmnnn April 2020General Discussion

How to pack decimal value for Native file specification

Answered adyner 4.2K views 1 comment 0 points Most recent by swalkaus April 2020General Discussion

Can you warm a subcluster's depot from data loaded by another subcluster?

Answered GaryG 4.1K views 1 comment 0 points Most recent by skeswani April 2020General Discussion

Resource and time to copy schema & tables into another cluster?

Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by dsprogis April 2020General Discussion

VerticaCopyStream and "REJECTED DATA AS TABLE"

Answered ✓ adyner 17.4K views 6 comments 0 points Most recent by adyner April 2020General Discussion

Cannot allocate sufficient memory for COPY statement (536870912 requested, 268435456 permitted)

Answered rajatpaliwal86 9.9K views 3 comments 0 points Most recent by SruthiA October 2019General Discussion

Accessing path of loaded file from S3

Answered atomix 11.7K views 4 comments 0 points Most recent by marcothesane September 2019General Discussion

using COPY command to skip column

Answered elghali 7.6K views 2 comments 0 points Most recent by viganog September 2019General Discussion

JSON Column in Regular Table Not copying properly to Flex Table

mc123 6.9K views 2 comments 0 points Most recent by twall July 2019General Discussion

Discussion List