Vertica Forum

Discussion List

• Default a Column’s Value

  12 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Joining 3 tables efficiently

  43 views 2 comments 0 points Most recent by atomix October 2018Vertica Forum
• Parse json file with Arrays

  63 views 10 comments 0 points Most recent by Ariel_Cary October 2018Vertica Forum
• Vertica and OBIEE 12c

  52 views 10 comments 0 points Most recent by siddyash October 2018Vertica Forum
• Need to compare column value and identify outlier records which shows huge spike in data

  22 views 2 comments 0 points Most recent by rahul_vertica_infy October 2018Vertica Forum
• Back and restore from 8.0.1 to 9.0.1

  42 views 3 comments 0 points Most recent by ankitdm October 2018Vertica Forum
• Query Tuning Question

  Accepted Answer 32 views 4 comments 0 points Most recent by Sharon_Cutter October 2018Vertica Forum
• backup size estimation using vbr

  22 views 2 comments 0 points Most recent by RaghavA October 2018Vertica Forum
• Display View Column Data Types

  13 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Space characters in Vertica table

  12 views 0 comments 0 points Started by BipinTelkar October 2018 Vertica Forum
• Insert Text Into Text

  3 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• kafka vertica streaming in ssl

  Answered 22 views 1 comment 0 points Most recent by SruthiA October 2018Vertica Forum
• Unable to write spark dataframe to vertica

  22 views 4 comments 0 points Most recent by Connyrt-emp1 October 2018Vertica Forum
• How to give user access to external table of parquet data on S3

  43 views 6 comments 0 points Most recent by Terry_Caudill October 2018Vertica Forum
• Reset Your Session

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Export To Parquet Default Directory Permission

  22 views 3 comments 0 points Most recent by Jim_Knicely October 2018Vertica Forum
• Upgrade to 9.0.1 - difficulties transitioning from "SOURCE HDFS(...)" to direct HDFS

  82 views 5 comments 0 points Most recent by Sharon_Cutter October 2018Vertica Forum
• Failed to initialize SSL

  55 views 11 comments 0 points Most recent by colin_loghin October 2018Vertica Forum
• Vertica and the Tableau Conference 2018 – New Orleans, LA

  12 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Forum
• Row rejected due to materialized type error on column

  116 views 5 comments 0 points Most recent by chaima October 2018Vertica Forum
• Conveniently Display Key Projection Info

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Fails on writing nulls to Binary fields in User Defined Parser

  13 views 0 comments 0 points Started by tvictor October 2018 Vertica Forum
• Prejoin projection is deprecated > Flattened Tables

  73 views 2 comments 0 points Most recent by Jim_Knicely October 2018Vertica Forum
• column pruning inside transform UDF

  22 views 0 comments 0 points Started by phil2 October 2018 Vertica Forum
• Checking the Validity of a Table Audit

  12 views 1 comment 1 point Most recent by Jim_Knicely October 2018Vertica Tips
• Problem integrating vertica with obiee

  2 views 0 comments 0 points Started by mpedroso October 2018 Vertica Forum
• Generate an Auto-Incrementing Alphabetical Series Using SQL

  12 views 0 comments 1 point Started by Jim_Knicely October 2018 Vertica Tips
• Viewing Previously Generated Explain Plans

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Vertica In-Memory database capability

  13 views 0 comments 0 points Started by A_S October 2018 Vertica Forum
• Display Null Query Result With an Alternate Text

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• evaluate scalar UDF in plan rewriter

  12 views 2 comments 0 points Most recent by Ariel_Cary October 2018Vertica Forum
• rename database

  53 views 3 comments 0 points Most recent by Jim_Knicely October 2018Vertica Forum
• Enforce encryption

  22 views 3 comments 0 points Most recent by SruthiA October 2018Vertica Forum
• ERROR: MIN/MAX window function error

  5 views 0 comments 0 points Started by Hari_rao October 2018 Vertica Forum
• Special Date/Time Formatting

  12 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Update Management Console Vertica IP to other node without loosing the messages & logs

  Accepted Answer 2 views 1 comment 0 points Most recent by robinem October 2018Vertica Forum
• Change the VSQL Result Set Border

  12 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• JSON Payload Parsing & Querying

  186 views 8 comments 0 points Most recent by martinc123 October 2018Vertica Forum
• Database Designer

  294 views 11 comments 1 point Most recent by thiago_rodrigo October 2018Vertica Forum
• Find Which System Tables Have a Particular Column Name

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Vertica - Export table with IDENTITY

  22 views 1 comment 0 points Most recent by marcothesane October 2018Vertica Forum
• Setting Data Retention in Vertica

  12 views 1 comment 0 points Most recent by Jim_Knicely October 2018Vertica Forum
• Vertica Learning Channel Playlist Videos

  23 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Forum
• Find Which Tables Have a Particular Column Name

  2 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• SELECT all data such that a single-node query plan is maintained

  32 views 2 comments 0 points Most recent by gjorgjevski October 2018Vertica Forum
• Database Storage - Raw and Compressed Size

  13 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips
• Vertica MC and CVE-2014-3625 - Directory traversal vulnerability in Pivotal Spring Framework

  12 views 0 comments 0 points Started by Neil_3 October 2018 Vertica Forum
• Benchmark for Update Query

  12 views 0 comments 0 points Started by Kaito October 2018 Vertica Forum
• Display Last SQL Run Time

  12 views 0 comments 0 points Started by Jim_Knicely October 2018 Vertica Tips