Search found 54 matches

by fsalvelt
Wed Nov 16, 2016 7:38 pm
Forum: Vertica Database Administration
Topic: Hyper threading BIOS setting?
Replies: 2
Views: 20857

Hyper threading BIOS setting?

Howdy,

Is it recommended to enable/disable hyper threading in the BIOS of each Vertica node?

Just curious...
by fsalvelt
Wed Mar 11, 2015 9:37 pm
Forum: Vertica SQL
Topic: Syntax to remove a default value on a table column
Replies: 2
Views: 7834

Syntax to remove a default value on a table column

Hi, I can't figure out how to remove a default value from a table column. Say for example I have this table: dbadmin=> create table t (a int default 1); CREATE TABLE dbadmin=> select column_name, column_default from columns where table_name = 't'; column_name | column_default -------------+---------...
by fsalvelt
Fri Jun 13, 2014 6:48 pm
Forum: New to Vertica Database Administration
Topic: How do I run DBD on a single table?
Replies: 6
Views: 12763

Re: How do I run DBD on a single table?

norbertk, thanks for your response. I had the same question as Brett. When I try you suggestion in Vertica 7.0.1 I get an error in DBD.

I created a new topic for the error:

http://www.vertica-forums.com/viewtopic.php?f=3&t=1890
by fsalvelt
Fri Jun 13, 2014 6:15 pm
Forum: Vertica Database Administration
Topic: DBD: Design process may still be executing in the background
Replies: 1
Views: 6560

DBD: Design process may still be executing in the background

Hi, I am trying to run DBD but keep getting this error: ----- DBD Output Start --------------------------- Database Designer started. For large databases a design session could take a long time; allow it to complete uninterrupted. Use Ctrl+C if you must cancel the session. Setting up design session....
by fsalvelt
Mon May 05, 2014 12:43 pm
Forum: vSQL
Topic: Error with Variable Substitution
Replies: 2
Views: 16280

Error with Variable Substitution

Hi, Can someone see what i am doing wrong in the following: [dbadmin@vertica-db0]$ vsql -v test=dual -c "select * from :test" ERROR 4856: Syntax error at or near ":" at character 15 LINE 1: select * from :test ^ I am trying to do a simple variable substitution on the command line.
by fsalvelt
Wed Apr 23, 2014 5:04 pm
Forum: New to Vertica SQL
Topic: Find the last occurrence of a char in a string
Replies: 1
Views: 8805

Find the last occurrence of a char in a string

How can I find the last occurrence of a character in a string? For instance, I want to find the position of the last "s" in the following string:

abcdfshakfdbfkdsksbdw
by fsalvelt
Wed Oct 09, 2013 2:47 pm
Forum: New to Vertica SQL
Topic: Missing data using "between" with dates
Replies: 4
Views: 13722

Re: Missing data using "between" with dates

Yes, it was time. You guys were correct. I get it now, my date on the right was time 00:00:00 and it makes sense now to me that I would miss any times greater than that. I should have saw this. I feel dumb. Anyway, thanks!

Go to advanced search