Mike Ramnarine

Tag: SQL

  • Vertica Error 4115 and new tables

    I’m in the process of creating data tables to be populated by our load system. This will be updated periodically, so using a MERGE statement makes sense. After creating the table and attempting to merge I receive the following error: ERROR 4115:  No super projection found for table table_name But isn’t a super projection created…

  • Storage and Dataloading in Vertica

    Column based stores are optimized for reading, but Vertica boasts quick write times and no locking issues. How does it manage this? Vertica uses its memory as a write optimized store before commiting data to disk in the main read optimized store. Data loading There are two commands for inserting data into the database. The…

  • Introduction to Vertica

    Looks like I’ll be spending some time using Vertica, a relatively new SQL technology. My main contact with databases has been with MySQL. There is information but far less than I’m use to. So I’m going to document my process. I’ve been looking for a writing challenge. It’ll be good to have a reminder and hopefully help the…