SQL

Discussion List

• 
  Bug: UNION ALL of CTEs produces invalid UTF-8 when one CTE references the other (25.1.0-5)

  Question shane_breeze 48 views 0 comments 0 points Started by shane_breeze April 13 General Discussion
• 
  GREATEST ignoring NULL?

  Answered Pieter_Sheth-Vo 1.5K views 3 comments 0 points Most recent by Bryan_H August 2025General Discussion
• 
  Faster way to create materialized view from catenated queries

  Question Pieter_Sheth-Vo 262 views 0 comments 0 points Most recent by Pieter_Sheth-Vo January 2025General Discussion
• 
  Sending Datetime or Datetime2 values via linked server in SQL Server - rounded to millisecond

  Answered kamil_kosno 7.3K views 3 comments 0 points Most recent by SruthiA October 2023General Discussion
• 
  Query with 2 NOT LIKE conditions returns 0 results

  Answered ✓ angelompcunha 35.3K views 16 comments 0 points Most recent by VValdar October 2023General Discussion
• 
  Pivot from columns to rows?

  Answered yardenpel 6.4K views 2 comments 0 points Most recent by VValdar September 2023General Discussion
• 
  'interpolate previous value' expression order does not matter?

  Answered ✓ ftobin 5.5K views 2 comments 0 points Most recent by ftobin September 2023General Discussion
• 
  Is there any linter for vsql scripts?

  Answered vhermecz 10.9K views 4 comments 0 points Most recent by vhermecz June 2023General Discussion
• 
  Why this procedure does not insert data into the table, although it is performed successfully, I can

  Answered Anelya 3.8K views 1 comment 0 points Most recent by Bryan_H May 2023General Discussion
• 
  Hi! How to solve this error

  Answered ✓ Anelya 6.4K views 1 comment 0 points Most recent by SruthiA May 2023General Discussion
• 
  How can we uniquely identify each record in Vertica database in absence of primary key?

  Answered chowdarypradeep 13.4K views 4 comments 0 points Most recent by marcothesane February 2023General Discussion
• 
  How to load data type fixed width support thai language

  Answered ✓ xinx 4.6K views 1 comment 0 points Most recent by mosheg December 2022General Discussion
• 
  least/greatest with 'in' fails

  Answered ✓ ftobin 13.8K views 4 comments 0 points Most recent by SruthiA September 2022General Discussion
• 
  Create a new table from another Table without data and new primary key

  Answered ✓ Jay_B 8.3K views 2 comments 0 points Most recent by Jay_B April 2022General Discussion
• 
  Finding similar roles assigned

  Answered shekhar8249 7.6K views 2 comments 0 points Most recent by DaveT February 2022General Discussion
• 
  Combining multiple S3EXPORT calls into a single call

  Answered ✓ neo_i_am_the_one 13.7K views 4 comments 0 points Most recent by neo_i_am_the_one December 2021General Discussion
• 
  Last day of last completed quarter

  Answered ✓ pratheek238 13.9K views 4 comments 0 points Most recent by pratheek238 November 2021General Discussion
• 
  Does Vertica CASE statement (syntax form 2) recognize NULL values?

  Answered Pieter_Sheth-Vo 5.2K views 1 comment 0 points Most recent by Jim_Knicely September 2021General Discussion
• 
  Is there a corresponding antlr4 file to implement Vertica SQL parsing？

  Question erphia 7.6K views 2 comments 0 points Most recent by erphia August 2021General Discussion
• 
  Remove empty and null values from table

  Answered szymon_k 6.6K views 1 comment 0 points Most recent by SruthiA July 2021General Discussion
• 
  How to alter table to have uuid?

  Answered iddpanganiban 7.8K views 2 comments 0 points Most recent by iddpanganiban July 2021General Discussion
• 
  Bug in WHERE clause?

  Answered ✓ peter_krammer 17K views 5 comments 0 points Most recent by marcothesane May 2021Product Feedback
• 
  REGR_SLOPE PRECISION

  SruthiA 1.6K views 0 comments 1 point Most recent by SruthiA April 2021Tips from the Team
• 
  Server closed the connection unexpectedly while loading data from CSV using Alteryx Designer

  Answered Satya 30.3K views 9 comments 1 point Most recent by Satya September 2020General Discussion
• 
  Need to Find the Occurrence of an Alphabet in a String

  Answered ✓ JayantaB 31.8K views 6 comments 0 points Most recent by JayantaB August 2020General Discussion
• 
  Delete specific word using regexp_replace

  Answered shashank_p 34.7K views 10 comments 0 points Most recent by shashank_p June 2020General Discussion
• 
  How do I create an alias for a built-in function?

  Answered bloopie 14.5K views 4 comments 0 points Most recent by LenoyJ June 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 5K views 1 comment 0 points Most recent by mosheg May 2020General Discussion