• News

    BlueCross BlueShield Replaced Full Analytic Stack

    1

    Watch as Doug Porter, Senior Vice President and CIO of BlueCross BlueShield Association, discusses how the company is using the Vertica Analytic Platform. Doug discusses how they decided on Vertica as a solution against Netezza or Teradata, and how they moved their full analytic stack to Vertica because of the amazing performance.

  • News

    Distributed Execution, Live Aggregate Projections, and Database Designer from Data @Scale Boston

    0

    Facebook hosted Data @Scale Boston November 12th along with its one-year celebration of its Kendall Square Office. Local companies such as DataXu, Vertica, VoltDB, Twitter, and Facebook presented during this talk. Derrick Rice, Nga Tran, and Vivek Bharathan of Vertica gave great presentations about the data movement challenges in distributed computing, Vertica’s Live Aggregate Projections,…

  • Best Practices

    Top Five Ways to Run a Great Vertica Evaluation

    0

    A great post came out of vertica.com last week on the top 5 ways to run a great Vertica evaluation. These best practices really give excellent explanations into the ways that an evaluation can succeed. This post follows a previous read on the top 5 ways to botch a Vertica evaluation. Read more at vertica.com.

  • Development

    How to convert a string to a table in Vertica

    1

    Sometimes when working with BI tools you will need to pass a table of parameters to a Vertica query. One way to do this is to serialize the table into a text string, pass the text string as a parameter to Vertica, and then convert the text string back to a table inside of Vertica….

  • Minor, Releases

    Vertica 7.1.1 Released

    0

    The next service pack of Vertica (7.1.1) was released yesterday. This applies to both Community and Enterprise Editions. The release provides updated Place and Pulse extensions, ODBC & JDBC drivers, Management Console, R Language Pack, and Hadoop Coonectors. New features include catalog client authentication, Spanish text support for Pulse, and more.

  • Database Design

    Web Based Training

    0

    Vertica is offering free access to web-based training content. This training covers installation and setup, storage architecture, and analytic functions. Check out more at the Web Based Training site.

  • Administration

    Optimizing for Merge Join

    0

    In an earlier post, join operations were introduced followed by hash join operations. The other operator, merge join, may sometimes be needed in situations when a spill to disk occurs. In these situations, resources are being wasted. One approach may be optimizing for merge join. In this post, a query was optimized and tested for…

  • Administration

    Amazing Getter Functions in Vertica – Part 1

    1

    Ever wondered, If it was easy for you to query database for essential parameters of the database without querying the system tables. Many facts you wanted to know about the database without typing the complete query is actually possible with Vertica. Vertica provides awesome get functions to make your life easy when working with Vertica.

  • Administration

    Introduction to Locks

    0

    While lock events aren’t common, there can be times where a lock can block another transaction causing it to potentially fail. Blocking typically occurs when a transaction such as INSERT, UPDATE, or DELETE does not get committed within a transaction. This post will cover the different types of locks, show an illustration of a READ…

  • Conferences

    How Vertica Met Facebook’s 35TB/hour Ingest SLA

    2

    There were many interesting technical sessions at the 2014 Vertica Big Data Conference. However, I feel that the most captivating session was on loading 35TB per hour. Just the sheer number of nodes in the clusters, amount of data ingested, and use cases made for a truly educational session. This session covered how Vertica was…

  • Administration

    Added Column Encoding Types

    0

    Vertica 7.1 introduces two new encoding types: BZIP_COMP and GZIP_COMP. These types allow for bzip2 and gzip compression on table columns. While these encodings give high compression, they also require more resources to process.

  • Administration

    First Look at Live Aggregate Projections

    0

    One of the newest features of Vertica 7.1 is Live Aggregate Projections. These projections are designed to improve query performance for frequently used queries containing aggregates, as the physical data will already be aggregated. This reduces the necessary operations required at query time. However, this benefit has a cost at load time as aggregation has…

  • News

    Vertica 7.1 Dragline Released

    0

    Vertica 7.1 has been officially released with some exciting new features. The Community Edition will be released at a later date and the AWS AMI has not yet been updated. As drivers are being provided as part of the full client package, only 7.1.x client drivers are compatible with version 7.1.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.