Search found 58 matches

by beth
Fri Apr 14, 2017 8:46 pm
Forum: General
Topic: Vertica - All in!
Replies: 4
Views: 10732

Re: Vertica - All in!

Oh my. Now that's dedication!
by beth
Thu Jan 12, 2017 6:01 pm
Forum: New to Vertica SQL
Topic: Question about Normalize function
Replies: 1
Views: 13752

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?
by beth
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: 18906

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...
by beth
Thu Jul 14, 2016 2:08 pm
Forum: New to Vertica SQL
Topic: Convert DB2 date fields to Vertica format
Replies: 1
Views: 15589

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.
by beth
Thu May 26, 2016 8:39 pm
Forum: Vertica Database Administration
Topic: Packages installed by default when creating a new DB?
Replies: 1
Views: 6306

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...
by beth
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: 18378

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... :oops: :oops: :oops:
by beth
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: 18378

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...

Go to advanced search