General Discussion

Discussion List

• 
  How to speed up multiple join query

  Answered HyeontaeJu 28K views 4 comments 0 points Most recent by marcothesane August 2020General Discussion
• 
  About CSV output using vsql command

  Answered ✓ yamakawa 19.8K views 7 comments 0 points Most recent by yamakawa September 2020General Discussion
• 
  What's difference LIKE and ILIKE ??

  Answered HyeontaeJu 4.7K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Any support for delta parquet format ?

  Answered Navin_C 4.1K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Need Vertica JDBC code for tweaking

  Answered Navin_C 4.1K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  vbr backup timestamp

  Answered mpo 4.2K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Does the vertica support fullText Search?

  Answered HyeontaeJu 4.2K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Unable to access Impala parquet file

  Answered avinash1 26.5K views 6 comments 0 points Most recent by poojan September 2020General Discussion
• 
  How to backup the vertica data to Amazon S3?

  Answered HyeontaeJu 4.1K views 1 comment 0 points Most recent by LenoyJ August 2020General Discussion
• 
  Vertica DB data storage from OBR

  ashish4raj 4.2K views 1 comment 0 points Most recent by siddyash September 2020General Discussion
• 
  Change default precision and scale for NUMERIC fields

  Answered smontiel 2.1K views 3 comments 0 points Most recent by SruthiA September 13General Discussion
• 
  Inquiries on the LINEAR_REG function

  Answered jquan 4.2K views 1 comment 0 points Most recent by SruthiA August 2020General Discussion
• 
  How to use subquery fetch data in Vertica

  Answered gg1234 4.2K views 1 comment 0 points Most recent by Siddhi_Lal_Kaye September 2020General Discussion
• 
  How can I check what projections all tables in the schema have?

  Answered ✓ HyeontaeJu 6.6K views 2 comments 0 points Most recent by HyeontaeJu August 2020General Discussion
• 
  What's the mean the word "cost" that is printed by Query plan?

  Answered ✓ HyeontaeJu 6.7K views 2 comments 0 points Most recent by HyeontaeJu August 2020General Discussion
• 
  How to upload my profile picture?

  Answered ✓ HyeontaeJu 6.6K views 2 comments 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Hi, i am trying to calculate a rolling twelve month average for BMI.

  Answered estone 17K views 6 comments 0 points Most recent by marcothesane August 2020General Discussion
• 
  Adding design table query is not working

  Answered ✓ HyeontaeJu 9.1K views 3 comments 0 points Most recent by HyeontaeJu August 2020General Discussion
• 
  How to make a Design Table using Management Console's Design?

  Answered HyeontaeJu 6.6K views 3 comments 0 points Most recent by HyeontaeJu August 2020General Discussion
• 
  Bulk loading slow when source file has about 3 million rows

  Answered raulk89 52.4K views 20 comments 0 points Most recent by An_kir August 2020General Discussion
• 
  How To replace view : too long view_definition

  Answered ✓ yamakawa 4.2K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  How can I CAST a numeric column to a NUMERIC with different precision and/or scale?

  Answered smontiel 7K views 2 comments 0 points Most recent by smontiel August 2020General Discussion
• 
  SQL Error [2788] [0A000]: [Vertica]VJDBC ERROR: operator <> is not supported

  Answered gg1234 12.8K views 4 comments 0 points Most recent by mosheg August 2020General Discussion
• 
  Merge ERROR: Column is of type date but expression is of type varchar

  Answered joergschaber 8.6K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Is there a way to set queuetimeout at query or session level?

  Answered ✓ brocha 4.3K views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  CI/CD with two env on Vertica

  Answered acrespi 11.8K views 4 comments 0 points Most recent by acrespi September 2020General Discussion
• 
  Dropping partitions

  Answered JunaidKhan 4.2K views 1 comment 0 points Most recent by marcothesane August 2020General Discussion
• 
  Need to Find the Occurrence of an Alphabet in a String

  Answered ✓ JayantaB 26.7K views 6 comments 0 points Most recent by JayantaB August 2020General Discussion
• 
  Mapping new Address - Fails in my setup

  Answered msanjib 9.5K views 3 comments 1 point Most recent by Hibiki August 2020General Discussion
• 
  What privileges my role has? how to check?

  Answered ✓ Sankarmn 14.4K views 4 comments 1 point Most recent by Sankarmn August 2020General Discussion