Vertica Forum

Discussion List

• 
  GROUPING() on current time in HAVING clause in subquery and outer query grouping

  Answered ✓ timurib 12.2K views 4 comments 0 points Most recent by Jim_Knicely July 2018General Discussion
• 
  [Vertica][VJDBC](3007) ERROR: DDL statement interfered with this statement

  vincent_wu 44.9K views 9 comments 0 points Most recent by Jim_Knicely July 2018General Discussion
• 
  Why does sql query give more results than expected?

  David_P_1 4.5K views 1 comment 0 points Most recent by Jim_Knicely July 2018General Discussion
• 
  What's wrong with our memory settings?

  pm2018 7K views 2 comments 0 points Most recent by pm2018 July 2018General Discussion
• 
  how to copy a file from Host machine to vertica VM

  Anand 6.9K views 2 comments 0 points Most recent by s_crossman July 2018General Discussion
• 
  use same vertica vm after OS change

  Anand 7K views 2 comments 0 points Most recent by Anand July 2018General Discussion
• 
  Upgrading from vertica 8.0 to 9.0 - Machine learning package fails to install

  Arvind_Sugurr 7.1K views 2 comments 0 points Most recent by Arvind_Sugurr June 2018General Discussion
• 
  Announcing Vertica in Eon Mode for Amazon Linux 2, now available in AWS Marketplace

  [Deleted User] 2K views 0 comments 1 point Most recent by [Deleted User] June 2018General Discussion
• 
  can not create an access policy. keep getting "Cannot reserve JVM while holding global locks"

  Answered mbw 4.6K views 1 comment 0 points Most recent by Ben_Vandiver June 2018General Discussion
• 
  Changing the Data Type of a Column in an External Table

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Partition Swap

  LazyDBA 7K views 2 comments 0 points Most recent by LazyDBA June 2018General Discussion
• 
  NULL Equals NULL with NULLSEQUAL

  [Deleted User] 2.6K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Limiting a User’s Open Session Count

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Disable Purge

  naresh_way2 9.5K views 3 comments 0 points Most recent by Jim_Knicely June 2018General Discussion
• 
  Create Type command in Vertica

  he437580 7.1K views 2 comments 0 points Most recent by he437580 June 2018General Discussion
• 
  fromExprRelids.size()

  vcarusi 7.1K views 2 comments 0 points Most recent by vcarusi June 2018General Discussion
• 
  Vertica Quick Tip: Handling NULL Equality in a WHERE Clause

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Last Good Epoch/Ancient History Mark not advancing

  TimNooren 32.5K views 11 comments 0 points Most recent by Jim_Knicely June 2018General Discussion
• 
  Restore Failed (Password file is not read/write protected).

  andre_silva 5K views 1 comment 0 points Most recent by Jim_Knicely June 2018General Discussion
• 
  Technical white paper: Benchmarks prove you need an analytical database for Big Data

  JaredZh 2K views 0 comments 0 points Most recent by JaredZh June 2018General Discussion
• 
  HOW TO INSTALL VERTICA S3EXPORT -- Data movement from vertica to S3

  ishangaur 4.6K views 1 comment 0 points Most recent by Jim_Knicely June 2018General Discussion
• 
  Faster CTAS Statements

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Analyze Statistics at the Schema Level (Part 2): Quick Tip

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] June 2018Tips from the Team
• 
  Silent Installation for Vertica Driver (ODBC)

  Kaito 17.1K views 6 comments 0 points Most recent by Kaito June 2018General Discussion
• 
  Where to see query execution error detail

  Anand 7.5K views 2 comments 0 points Most recent by Anand June 2018General Discussion
• 
  Restore database in another directory

  andre_silva 6.9K views 2 comments 0 points Most recent by andre_silva June 2018General Discussion
• 
  view all query log - v_monitor.query_profiles

  nirka 8K views 2 comments 0 points Most recent by nirka June 2018General Discussion
• 
  Vaccum in Vertica?

  andre_silva 7.6K views 2 comments 0 points Most recent by andre_silva June 2018General Discussion
• 
  Analyze Statistics at the Schema Level (Part 1): Quick Tip

  [Deleted User] 2.5K views 0 comments 1 point Most recent by [Deleted User] June 2018Tips from the Team
• 
  System table - DISK_STORAGE

  Tim_1 9.5K views 3 comments 0 points Most recent by Jim_Knicely June 2018General Discussion