Howdy,
Is it recommended to enable/disable hyper threading in the BIOS of each Vertica node?
Just curious...
Search found 54 matches
- Wed Nov 16, 2016 7:38 pm
- Forum: Vertica Database Administration
- Topic: Hyper threading BIOS setting?
- Replies: 2
- Views: 23480
- Wed Mar 11, 2015 9:37 pm
- Forum: Vertica SQL
- Topic: Syntax to remove a default value on a table column
- Replies: 2
- Views: 7922
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 -------------+---------...
- 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: 12982
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
I created a new topic for the error:
http://www.vertica-forums.com/viewtopic.php?f=3&t=1890
- 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: 6646
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....
- Mon May 05, 2014 12:43 pm
- Forum: vSQL
- Topic: Error with Variable Substitution
- Replies: 2
- Views: 17136
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.
- 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: 8974
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
abcdfshakfdbfkdsksbdw
- Wed Oct 09, 2013 2:47 pm
- Forum: New to Vertica SQL
- Topic: Missing data using "between" with dates
- Replies: 4
- Views: 13879
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!