Search found 58 matches
- Fri Apr 14, 2017 8:46 pm
- Forum: General
- Topic: Vertica - All in!
- Replies: 4
- Views: 11091
Re: Vertica - All in!
Oh my. Now that's dedication!
- Thu Jan 12, 2017 6:01 pm
- Forum: New to Vertica SQL
- Topic: Question about Normalize function
- Replies: 1
- Views: 14108
Question about Normalize function
Hi,
If I use the NORMALIZE function prior to creating a predictive model, is there a way to put a new set of data through the same normalization in order to make predictions?
If I use the NORMALIZE function prior to creating a predictive model, is there a way to put a new set of data through the same normalization in order to make predictions?
- Mon Nov 14, 2016 9:13 pm
- Forum: New to Vertica Database Administration
- Topic: System table's column names are not uniform???
- Replies: 1
- Views: 19280
System table's column names are not uniform???
I'm curious ... How come a table's schema is identified by the TABLE_SCHEMA column in TABLES system table, while a table's schema name in the ALL_TABLES system table is identified by the SCHEMA_NAME column? dbadmin=> select distinct table_schema from tables; table_schema -------------- test public p...
- Thu Jul 14, 2016 2:08 pm
- Forum: New to Vertica SQL
- Topic: Convert DB2 date fields to Vertica format
- Replies: 1
- Views: 15976
Convert DB2 date fields to Vertica format
Hi all,
Anyone now an easy way to load dates into Vertica that come from a DB2 database? The format looks like this:
2016-19-21-03.21.22.70796
I have a data file that is full of these fields.
Anyone now an easy way to load dates into Vertica that come from a DB2 database? The format looks like this:
2016-19-21-03.21.22.70796
I have a data file that is full of these fields.
- Thu May 26, 2016 8:39 pm
- Forum: Vertica Database Administration
- Topic: Packages installed by default when creating a new DB?
- Replies: 1
- Views: 6535
Packages installed by default when creating a new DB?
Hi all, I just installed Vertica 7.2.3 and created a new database. I noticed that all of the following packages were installed automatically. Is there documentation online that explains the purpose of each package? ... Automatically installing extension packages Package: AWS Success: package AWS suc...
- Fri Apr 22, 2016 2:32 am
- Forum: Vertica SQL
- Topic: Can't add new column of type int using default of varchar
- Replies: 2
- Views: 18746
Re: Can't add new column of type int using default of varchar
Oh brother. I looked at that for hours today. I'm an idiot. Thanks, Jim...
- Thu Apr 21, 2016 3:01 pm
- Forum: Vertica SQL
- Topic: Can't add new column of type int using default of varchar
- Replies: 2
- Views: 18746
Can't add new column of type int using default of varchar
Howdy, I am trying to add a new column to a table that has a data type of int using another column in the table as the default value. That column in a varchar. Vertica won;t let me do this :evil: Is this a bug? dbadmin=> create table size (pk varchar(10)); CREATE TABLE dbadmin=> insert into size val...