Vertica Forum

Discussion List

• Vertica throwing exception for : Multiple SQL Statement Support

  Answered 37 views 1 comment 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Database and Node Uptime

  22 views 0 comments 0 points Started by Jim_Knicely September 2018 Vertica Tips
• Operating systems approved for vertica community 9.x cluster

  Accepted Answer 32 views 1 comment 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Vertica Clock Skewed

  42 views 1 comment 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Vertica differences between Azure and AWS?

  12 views 0 comments 0 points Started by ScottL September 2018 Vertica Forum
• Failed to install vertica driver in Azure window10

  42 views 2 comments 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Database is taking a long time to stop. Error: Notice 5940

  62 views 1 comment 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Mimicking Enumerated Types

  12 views 0 comments 0 points Started by Jim_Knicely September 2018 Vertica Tips
• Is it possible to use Vertica on a host which has LVM enabled? If so, how can you accomplish this.

  222 views 18 comments 0 points Most recent by Jim_Knicely September 2018Vertica Forum
• Updating multi billion row table with 200+ fields

  52 views 6 comments 0 points Most recent by abtsantosbenten September 2018Vertica Forum
• Changing the Field Separator in VSQL

  12 views 0 comments 0 points Started by Jim_Knicely September 2018 Vertica Tips
• Monitoring Resource Pool Cascade Events

  12 views 0 comments 0 points Started by Jim_Knicely September 2018 Vertica Tips
• advance checkpoint epochs on single node

  42 views 5 comments 0 points Most recent by Sharon_Cutter September 2018Vertica Forum
• Query Read Performance

  42 views 6 comments 0 points Most recent by verban September 2018Vertica Forum
• Same Table and Projection Name

  34 views 7 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• COPY WITH SOURCE + LOCAL

  42 views 3 comments 0 points Most recent by Ariel_Cary August 2018Vertica Forum
• Trend Micro ServerProtect for Linux Ver3.0

  12 views 0 comments 0 points Started by Kaito August 2018 Vertica Forum
• Setting the Table-Level Active Partition Count

  12 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• The Management Console shows "unknown" for the "host name" for two of the three nodes in the cluster

  Answered 12 views 1 comment 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Where can I download vertica-jdbc-7.2.3-14.jar

  23 views 1 comment 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Exporting to Parquet

  62 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Connection Load Balancing

  33 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Vertica database designer - "NON-OPTIMIZABLE" query

  12 views 3 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Cannot start database after upgrade vertica from 9.0.1-7 to 9.1.1

  132 views 15 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Dealing with Subquery Restrictions

  22 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Vertica Dimension Table query

  23 views 2 comments 0 points Most recent by JunaidKhan August 2018Vertica Forum
• Username is case sensitive after client authentication record is created

  52 views 8 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• export to Parquet : Error 3457

  435 views 15 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Ensure Data Integrity with Check Constraints

  2 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Listing Invalid Views

  23 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Maximum Number of Rows per Load

  12 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Setting the Max Memory Available by Query

  22 views 0 comments 0 points Started by Jim_Knicely August 2018 Vertica Tips
• Limit of 1 TB to compressed or uncompressed storage

  32 views 2 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Converting CHAR and VARCHAR to BINARY or VARBINARY

  32 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• Getting Help with Command-Line Tools

  22 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• What is the difference(new features) between Vertica 7.2 to Vertica 8.2 and vertica 8.2 to 9.1

  22 views 1 comment 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Cascading Schema Ownership

  42 views 0 comments 1 point Started by SarahL August 2018 Vertica Tips
• Change the Owner of a Schema

  22 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• Leaving a column out of 'select *'

  22 views 4 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• How to extract day from duration

  2 views 2 comments 0 points Most recent by marcothesane August 2018Vertica Forum
• ALTER SCHEMA OWNER

  305 views 3 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Inconsistent/slow runtimes due to high Scan execution times on individual nodes.

  42 views 0 comments 0 points Started by KKirkpatrick August 2018 Vertica Forum
• Vertica Extension - String Package supported in Vertica 9

  82 views 3 comments 0 points Most recent by elchen August 2018Vertica Forum
• Find the Number of Days Passed and Remaining in the Relative Year

  2 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• Bug in vertica/engine/api/start_database.py in 9.0.1 - start_list used before assignment

  32 views 2 comments 0 points Most recent by s_crossman August 2018Vertica Forum
• RJDBC UTF-8 encoding

  42 views 1 comment 0 points Most recent by DerekW August 2018Vertica Forum
• Displaying the Current Schema

  32 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• Referencing Multiple Related LONG VARCHAR Columns

  2 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips
• Optimizer - Wrong estimated # of rows

  52 views 11 comments 0 points Most recent by Jim_Knicely August 2018Vertica Forum
• Generate Random Integers, Including Negative Numbers

  2 views 0 comments 0 points Started by SarahL August 2018 Vertica Tips