copy

Discussion List

• 
  VERTICA COPY QUERY Via AWS S3 bucket

  Answered ✓ srijanch0810 542 views 1 comment 0 points Most recent by srijanch0810 July 2025General Discussion
• 
  COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE.

  Question srijan 231 views 0 comments 0 points Most recent by srijan March 2025General Discussion
• 
  GETTING ERROR[2202B] on running COPY command from s3 object

  Answered ✓ srijan 680 views 1 comment 0 points Most recent by Vertica_Curtis March 2025General Discussion
• 
  ignoring duplicates during COPY

  Answered prad33p2301 1.7K views 2 comments 0 points Most recent by Sergey_Cherepan_1 November 2024General Discussion
• 
  Skipping the columns during data load to Vertica using COPY command

  Answered Phantom 2.4K views 1 comment 0 points Most recent by marcothesane March 2024General Discussion
• 
  COPY's usage with complex types - ARRAY

  Answered xpegenaute 2.9K views 1 comment 0 points Most recent by marcothesane November 2023General Discussion
• 
  Using filler with COPY..FAVROPARSER?

  Answered ✓ yurmix 17.1K views 5 comments 0 points Most recent by yurmix February 2022General Discussion
• 
  COPY format for ISO8601 date time value

  Answered kamil_kliczbor 8K 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 7.7K views 2 comments 0 points Most recent by Hibiki July 2021General Discussion
• 
  Storing source file names when loading data

  Question Bryan_H 1.6K views 0 comments 0 points Most recent by Bryan_H May 2021Tips from the Team
• 
  Copy with Delayed_Creation Failed

  Michael_Pacocha 35.3K views 11 comments 0 points Most recent by Nimmi_gupta March 2021General Discussion
• 
  copy from local, autogenerate line number

  Answered ✓ alexisos 29.3K views 9 comments 0 points Most recent by alexisos February 2021General Discussion
• 
  Vertica: Cannot allocate sufficient memory for copy statement

  Answered PavanVejju 40.1K 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 11K views 3 comments 0 points Most recent by SruthiA November 2020General Discussion
• 
  Replication VBR deleted the data

  Answered veerkumar 11K 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 9.5K views 2 comments 0 points Most recent by karthik October 2020General Discussion
• 
  LOAD a CSV

  Answered yeifer 21.5K views 6 comments 0 points Most recent by marcothesane August 2020General Discussion
• 
  vertica constraint enforcement and deduplication

  Answered ✓ rajatpaliwal86 20.9K 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 12.9K views 2 comments 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  Does Vertica provide upsert support while loading data?

  Answered vmnnn 9K views 2 comments 0 points Most recent by vmnnn April 2020General Discussion
• 
  How to pack decimal value for Native file specification

  Answered adyner 5K 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 5K 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 5K views 1 comment 0 points Most recent by dsprogis April 2020General Discussion
• 
  VerticaCopyStream and "REJECTED DATA AS TABLE"

  Answered ✓ adyner 21.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 11.9K views 3 comments 0 points Most recent by SruthiA October 2019General Discussion
• 
  Accessing path of loaded file from S3

  Answered atomix 14.4K views 4 comments 0 points Most recent by marcothesane September 2019General Discussion
• 
  using COPY command to skip column

  Answered elghali 9K views 2 comments 0 points Most recent by viganog September 2019General Discussion
• 
  JSON Column in Regular Table Not copying properly to Flex Table

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