If you need to "split" a string into parts, there is a neat built-in function appropriately named SPLIT_PART which can help you do that. The function has the syntax: SPLIT_PART ( string , delimiter , field ) where string is the argument string, delimiter is what separates the parts of the string and...

I asked myself this question a while back. Finding the answer wasn't as easy and satisfying as I expected. Are you looking for the total amount of disk space being used or for the size of your raw uncompressed data which Vertica uses to determine your license compliance? I'll show you the methods I ...

By default Vertica will store temp files that are generated by sort, group by, join, and several other operations in the same location as the data files. Because temp files and data files have different disk I/O access patterns, it is a good idea to separate the two into their own storage areas to h...

Some folks at my company are using the SQuirreL client tool to connect to Vertica.

Here is a link to a great blog post by Tom Gendron that'll help you set up SQuirreL:

• http://tomgendron.wordpress.com/2011/08 ... ql-client/

Hi, The log file in vertica is called vertica.log . It is located on the server in the directory defined as /catalog-path/database-name/node-name_catalog . You can verify the location of your log file via the admintools utility. Go to the Configuration Menu/View Database menu selection and then choo...

Hi, The LIKE SQL predicate is case sensitive. Example: dbadmin=> create table test (name varchar(100)); CREATE TABLE dbadmin=> insert into test values ('Jim'); OUTPUT -------- 1 (1 row) dbadmin=> insert into test values ('jim'); OUTPUT -------- 1 (1 row) dbadmin=> select name from test where name li...

Hi there, Make sure your ODBC connection's transaction isolation level is the same as your Vertica database server. The default isolation level for an ODBC connection is "Serializable" whereas the default isolation level for the Vertica database is "Read Committed". Try changing your ODBC setting to...