Tables

Discussion List

• 
  COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE.

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

  Answered ✓ srijan 628 views 1 comment 0 points Most recent by Vertica_Curtis March 2025General Discussion
• 
  Query with 2 NOT LIKE conditions returns 0 results

  Answered ✓ angelompcunha 34.4K views 16 comments 0 points Most recent by VValdar October 2023General Discussion
• 
  Multiple Parquets for One Table

  Question Closed jzhang 1.7K views 0 comments 0 points Most recent by jzhang February 2023General Discussion
• 
  Finding similar roles assigned

  Answered shekhar8249 7.4K views 2 comments 0 points Most recent by DaveT February 2022General Discussion
• 
  Create tables partition

  Answered Sophie_bd 4.5K views 1 comment 0 points Most recent by Jim_Knicely December 2021General Discussion
• 
  Vertica external table(S3 based) performance issues.

  mt_25 63.5K views 20 comments 0 points Most recent by reli February 2021General Discussion
• 
  Specifying length of VARCHAR

  Answered Pieter_Sheth-Vo 29.7K views 8 comments 0 points Most recent by vivekbarad December 2020General Discussion
• 
  Insert random values in Fact Table

  Answered franciscoCA 8.2K views 2 comments 0 points Most recent by mosheg November 2020General Discussion
• 
  Server closed the connection unexpectedly while loading data from CSV using Alteryx Designer

  Answered Satya 29.8K views 9 comments 1 point Most recent by Satya September 2020General Discussion
• 
  query plan is different between select from table and select from view

  sma 8K views 2 comments 1 point Most recent by sma July 2020General Discussion
• 
  DATE values insertion into Vertica table through python

  Answered tnr 5.5K views 1 comment 1 point Most recent by Bryan_H June 2020General Discussion
• 
  populating null rows in table column based on matching IDs via join or otherwise

  Answered mpc83 4.9K views 1 comment 0 points Most recent by mosheg May 2020General Discussion
• 
  What are some best practices for updating table statistics?

  Answered rjs_docs 5K views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Selectively retaining data from data collectors

  Answered kxu 5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Potential impact of frequent Vertica updates on SCD2 historization of dimensional tables?

  Answered Min_Yun_Chan 5K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  Best practices when combining multiple fact tables?

  Answered rjs_docs 5K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Purge_Table operations taking long time.

  esangrame 8.5K views 2 comments 1 point Most recent by marcothesane July 2019General Discussion