Search found 51 matches

by janice
Wed Sep 14, 2016 6:00 am
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 4575

Re: WTF? Vertica is no longer part of HP?

Jim, what is the future of Vertica?
by janice
Thu Sep 08, 2016 12:43 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 4575

Re: WTF? Vertica is no longer part of HP?

I have to weigh in on this ... I love the title "UK tech firm swoops on HP software unit..."

http://www.bbc.com/news/business-37303066
by janice
Wed Apr 20, 2016 9:23 pm
Forum: Vertica Database Administration
Topic: Recommended AWS Instance Type for Vertica???
Replies: 5
Views: 2495

Recommended AWS Instance Type for Vertica???

Hi all,

Recently I've been asked to perform some research into moving our DB into AWS. Has anyone here successfully done so? If so, could you please recommend which AWS instance types are appropriate for Vertica? Not too much documentation on this.

Thanks in advance!
by janice
Mon Mar 16, 2015 7:26 pm
Forum: New to Vertica Database Administration
Topic: Sequences Broken in 7.1.1?
Replies: 4
Views: 1757

Re: Sequences Broken in 7.1.1?

I upgraded to 7.1.1-9 and now the sequence works as expected! dbadmin=> SELECT version(); version ------------------------------------ Vertica Analytic Database v7.1.1-9 (1 row) dbadmin=> CREATE TABLE test (col1 INT); CREATE TABLE dbadmin=> CREATE SEQUENCE test_seq; CREATE SEQUENCE dbadmin=> INSERT ...
by janice
Mon Mar 16, 2015 6:52 pm
Forum: New to Vertica Database Administration
Topic: Sequences Broken in 7.1.1?
Replies: 4
Views: 1757

Re: Sequences Broken in 7.1.1?

Thank you, Sharon. I just opened a case with Vertica to get the patch. I wonder how that bug got by QA :evil:
by janice
Mon Mar 16, 2015 2:09 pm
Forum: New to Vertica Database Administration
Topic: Sequences Broken in 7.1.1?
Replies: 4
Views: 1757

Re: Sequences Broken in 7.1.1?

If I set the CACHE to 10,000, I can insert 5,000,000 records once. But on a second run, the sequence exceeds it's max value... dbadmin=> CREATE SEQUENCE test_seq CACHE 10000; CREATE SEQUENCE dbadmin=> INSERT INTO test SELECT test_seq.NEXTVAL FROM online_sales.online_sales_fact; OUTPUT --------- 5000...
by janice
Mon Mar 16, 2015 1:45 pm
Forum: New to Vertica Database Administration
Topic: Sequences Broken in 7.1.1?
Replies: 4
Views: 1757

Sequences Broken in 7.1.1?

Hello, It seems to me that sequences are broken in 7.1.1. dbadmin=> \d test; List of Fields by Tables Schema | Table | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key --------+-------+--------+------+------+---------+----------+-------------+------------- public | test | col1 |...

Go to advanced search