Search found 1825 matches
- Tue Mar 13, 2012 3:41 pm
- Forum: Vertica SQL
- Topic: Splitting up strings of data
- Replies: 3
- Views: 15285
Splitting up strings of data
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...
- Thu Mar 08, 2012 3:09 pm
- Forum: Vertica Database Administration
- Topic: Database size?
- Replies: 6
- Views: 19424
Re: Database size?
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 ...
- Thu Mar 08, 2012 1:25 pm
- Forum: Vertica Database Administration
- Topic: Separating data from temp storage
- Replies: 2
- Views: 7045
Re: Separating data from temp storage
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...
- Tue Mar 06, 2012 4:06 pm
- Forum: SQuirreL SQL Client
- Topic: Setting up SQuirreL
- Replies: 8
- Views: 38300
Setting up SQuirreL
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:
Here is a link to a great blog post by Tom Gendron that'll help you set up SQuirreL:
- Mon Mar 05, 2012 11:09 pm
- Forum: New to Vertica Database Administration
- Topic: Vertica Log File
- Replies: 1
- Views: 13208
Re: Vertica Log File
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...
- Thu Mar 01, 2012 4:54 pm
- Forum: Vertica SQL
- Topic: Case insenesitive comparisons (ILIKE)
- Replies: 0
- Views: 10463
Case insenesitive comparisons (ILIKE)
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...
- Wed Feb 29, 2012 2:14 pm
- Forum: ODBC
- Topic: Queries made with ODBC are really slow...
- Replies: 1
- Views: 7008
Re: Queries made with ODBC are really slow...
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...