Query

Discussion List

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

  Question shane_breeze 39 views 0 comments 0 points Started by shane_breeze April 13 General Discussion
• 
  Query Progress

  Answered Rocky 4.8K views 2 comments 0 points Most recent by bmurrell March 31General Discussion
• 
  Updating table statistics?

  Answered rjs_docs 6.6K views 3 comments 0 points Most recent by marcothesane January 2025General Discussion
• 
  Help to understand the slow running qury

  Answered shafeer 1.4K views 2 comments 0 points Most recent by shafeer November 2024General Discussion
• 
  Create Function issue in the Vertica

  Answered Phantom 2K views 2 comments 0 points Most recent by Phantom July 2024General Discussion
• 
  How to escape Special characters while using export to delimited.

  Answered srijanch0810 7.6K views 5 comments 0 points Most recent by mosheg April 2024General Discussion
• 
  to_date function returns wrong result

  Answered martinc123 23.5K views 7 comments 0 points Most recent by Bryan_H September 2023General Discussion
• 
  METADATA POOL - Insufficient resources

  Question federico 1.3K views 0 comments 0 points Most recent by federico April 2023General Discussion
• 
  Vertica v12.0.3 -- Too many Ros Containers over TEMPORARY TABLE

  Answered federico 6.8K views 2 comments 0 points Most recent by federico March 2023General Discussion
• 
  How to load data type fixed width support thai language

  Answered ✓ xinx 4.5K views 1 comment 0 points Most recent by mosheg December 2022General Discussion
• 
  Optimizing DISTANCE using projections

  Answered zun 10.6K views 3 comments 0 points Most recent by Hibiki October 2022General Discussion
• 
  Using variables in Query

  Answered yehudit 4.9K views 1 comment 0 points Most recent by Bryan_H July 2022General Discussion
• 
  Finding similar roles assigned

  Answered shekhar8249 7.5K views 2 comments 0 points Most recent by DaveT February 2022General Discussion
• 
  Inconsistency in vertica query results

  Answered pegazik 19.7K views 6 comments 0 points Most recent by yun_hoe_kim February 2022General Discussion
• 
  Last day of last completed quarter

  Answered ✓ pratheek238 13.8K views 4 comments 0 points Most recent by pratheek238 November 2021General Discussion
• 
  Time slots to dates

  Answered ✓ pestrid 16.7K views 5 comments 0 points Most recent by pestrid September 2021General Discussion
• 
  Same query executes 2 times in a row

  Answered ✓ zadvovl 14.5K views 4 comments 0 points Most recent by zadvovl December 2020General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 14.5K views 4 comments 0 points Most recent by Pieter_Sheth-Vo December 2020General Discussion
• 
  Insert random values in Fact Table

  Answered franciscoCA 8.3K views 2 comments 0 points Most recent by mosheg November 2020General Discussion
• 
  Any way to get query data dynamically while its executing.

  Answered ✓ sahil_kumar 26.9K views 8 comments 0 points Most recent by mosheg May 2020General Discussion
• 
  About the performance of the query

  Answered ✓ yamakawa 8K views 2 comments 0 points Most recent by yamakawa April 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
• 
  Can you send a query to multiple subclusters?

  Answered GaryG 4.9K views 1 comment 0 points Most recent by skeswani April 2020General Discussion
• 
  When to resegment/broadcast?

  Answered kxu 11.3K views 3 comments 0 points Most recent by cp00634326 April 2020General Discussion
• 
  Different effects when dropping/adding nodes between Eon and Enterprise Modes?

  Question GaryG 2K views 0 comments 1 point Most recent by GaryG April 2020General Discussion
• 
  Selectively retaining data from data collectors

  Answered kxu 5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Where can I find documentation for query performance and resource pools?

  Answered rjs_docs 8K views 2 comments 0 points Most recent by rjs_docs April 2020General Discussion
• 
  Hints with pre-ANSI joins

  Answered kxu 5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  How many projections used per query?

  Answered DreaBrandford 8.1K views 2 comments 0 points Most recent by DaveT April 2020General Discussion
• 
  SELECT statement performance improvements?

  Answered rjs_docs 5K views 1 comment 0 points Most recent by twall April 2020General Discussion