Check out Vertica's REGEXP functions. http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/RegularExpressions/RegularExpressionFunctions.htm%3FTocPath%3DSQL%20Reference%20Manual%7CSQL%20Functions%7CRegular%20Expression%20Functions%7C_____0 REGEXP_INSTR finds the sta...

Great post on other normal forms to consider when designing your database.

http://www.johnmyleswhite.com/notebook/ ... mal-forms/

*** kidding ***

Yes. I would recommend reading the SAS/Access Interface to Vertica for more information.
http://support.sas.com/documentation/cd ... 8iozn6.htm

When I looked at this a year ago I found that SSAS 2008 R2 doesn't play well with Vertica v6 in ROLAP mode. Here's the use case you will want to test, assuming you're using a more recent version of SSAS and Vertica. Create a Vertica table called CustomerTransaction with three columns (CustomerID, Tr...

There are a number of levers you can pull to speed up the load as well. Assuming that the network is the gating factor, you could stream the data through a gzip utility to convert it to gzip. The copy statement can read gzip data as long as you change the input from STDIN to STDIN GZIP. However, tha...

There's also the NULL as 'NULL' option for the copy command. [dbadmin@vertica tmp]$ cat test_file.txt 1|NULL|6 2|abcd|4 72|a|NULL NULL|hi|8 [dbadmin@vertica tmp]$ vsql Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with...

As for why it didn't show up in load_streams...did it finish in < 1 second? From the Vertica Docs: "The LOAD_STREAMS system table includes stream names for every COPY statement that takes more than 1-second to run. The 1-second duration includes the time to plan and execute the statement." The next ...