Blog Posts tagged with -sql-

  • Oct 12, 2012

    User Defined Load Libraries in Vertica 6

    Vertica 6 introduces the concept of UDLs, User Defined Load libraries. These libraries are C++ routines created with the Vertica API allowing you to extend the functionality of the COPY (bulk loading) statement. Traditionally, the COPY statement loads data from text files or character streams. UDLs allow you to substitute an external function call for a stream name or file location, then load the results directly into a table. This sort of functionality is useful when you want to access complex data sources such as…

    • Non-Vertica databases
    • SOAP and RESTful Web Services
    • Hadoop/MapReduce processes
  • Jul 3, 2012

    Real World Vertica Performance at Full360 via Chef

    As a boutique, BI solutions integrator, Full360 sometimes receives requests from medium sized, prospective clients to do a proof of concept of our elasticBI platform, a stack consisting of Jaspersoft BI reporting combined with the Vertica columnar database.  Typically in these cases, the prospect is comparing several BI solutions, looking for the one that will best fit their needs.  The bigger players in the space often have more resources to throw at building a POC… usually part of a presales technical team. 

  • Apr 21, 2011

    The Parallel Cubiverse

    Using Essbase Studio to build two applications at once. Drill through becomes drill across when you use parent child constructions.

    So what I have been doing over the past several months is an introduction to an idea that I’ve never quite seen before, and although we staggered into it, now that it’s mostly done I’m seeing some greater beauty in it.