Vertica Forum

Discussion List

• 
  Is it safe to use -F option on start_db of admintools?

  Answered ✓ hrao 37.3K views 13 comments 0 points Most recent by Sharon_Cutter March 2019General Discussion
• 
  Vertica ERROR: join inner did not fit in memory

  Answered mpedroso 10.6K views 3 comments 0 points Most recent by Sharon_Cutter March 2019General Discussion
• 
  Setting config parameter does not work

  alisalem 4.5K views 1 comment 0 points Most recent by s_crossman March 2019General Discussion
• 
  Arithmetic Bit-shifting

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  most efficient way to insert huge amount of data into vertica

  phil2 2.1K views 0 comments 0 points Most recent by phil2 March 2019General Discussion
• 
  super projections

  Answered sreeblr 4.6K views 1 comment 0 points Most recent by Nithesh March 2019General Discussion
• 
  Convert an Integer to a Binary

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Join Big tables (Pre-Proj, Flattened tables, ...)

  verban 29.7K views 11 comments 0 points Most recent by verban March 2019General Discussion
• 
  partitions limit per projection

  nirka 7.1K views 2 comments 0 points Most recent by nirka March 2019General Discussion
• 
  extract schema from parquet file

  ningzhong 2.4K views 0 comments 0 points Most recent by ningzhong March 2019General Discussion
• 
  Avoid Query going to other Nodes if segment upper and lower bound is provided.

  esangrame 22K views 8 comments 0 points Most recent by esangrame March 2019General Discussion
• 
  Spark Connector Read

  PaulWu 11.5K views 2 comments 0 points Most recent by Connyrt-emp1 March 2019General Discussion
• 
  Why some queries don't appear in Vertica's query history

  abtsantosbenten 4.6K views 1 comment 0 points Most recent by Jim_Knicely March 2019General Discussion
• 
  Are These Two String Values Like Each Other?

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Self join not permitted in Updates

  Navin_C 17.8K views 6 comments 0 points Most recent by parthmalhan March 2019General Discussion
• 
  Identify a Tables Primary Key Columns

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Integration of Vertica with Hive LLAP

  OlivierA 9.4K views 3 comments 0 points Most recent by kguan March 2019General Discussion
• 
  Removed a node from a cluster when the node no longer exists.

  jeff 4.5K views 1 comment 0 points Most recent by Jim_Knicely March 2019General Discussion
• 
  Can we load Excel (.xlsx or .xls) file directly to Vertica Table?

  haroon 9.1K views 2 comments 0 points Most recent by haroon March 2019General Discussion
• 
  Kafka streaming to Flex table with columns

  Answered mdkarkeys 7.1K views 2 comments 0 points Most recent by mdkarkeys March 2019General Discussion
• 
  Revoke Access to Multiple System Tables from Multiple Users with a New Role

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely March 2019Tips from the Team
• 
  Loading data Vertica to Vertica

  Answered ✓ mpedroso 20K views 7 comments 0 points Most recent by scottpedersoli March 2019General Discussion
• 
  MySQL INSERT ... ON DUPLICATE KEY UPDATE - need vertica analogue

  vertica_one_love 25.3K views 9 comments 0 points Most recent by Jim_Knicely March 2019General Discussion
• 
  Query running during Vertica node down will complete very slow.

  sittisakj 2K views 0 comments 0 points Most recent by sittisakj March 2019General Discussion
• 
  Explain plan shows incorrect rows even after collecting 100% statistics

  arun_aiyadurai 4.5K views 1 comment 0 points Most recent by Jim_Knicely February 2019General Discussion
• 
  SystemConfigController ERROR - configuration

  Mario 9.6K views 3 comments 0 points Most recent by Mario February 2019General Discussion
• 
  Revoke Access From Just One System Table

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely February 2019Tips from the Team
• 
  Vertica Eon Mode from Enterprise Mode

  hdk0310 19.7K views 7 comments 0 points Most recent by hdk0310 February 2019General Discussion
• 
  kafkaCheckBrokers function issues

  Answered ✓ mdkarkeys 11.6K views 2 comments 0 points Most recent by mdkarkeys February 2019General Discussion
• 
  Single Sign-On for Support: New Login for Passport Users

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] February 2019General Discussion