Search found 27 matches

by clv100
Fri Feb 05, 2016 3:25 pm
Forum: Vertica Upgrade
Topic: Upgrade 6.0 to 7.1 - database is slower
Replies: 1
Views: 15364

Upgrade 6.0 to 7.1 - database is slower

We recently upgraded our DEV vertica database from 6.0 to 7.1. After some trial and error and some help from HP Vertica, we followed all the upgrade steps from 6.0 to 6.1, 6.1 to 7.0 and 7.0 to 7.1. We also applied the latest hotfix. However, in testing our production processing against our DEV envi...
by clv100
Fri Jan 08, 2016 8:51 pm
Forum: General
Topic: Lazy Projection
Replies: 2
Views: 7226

Re: Lazy Projection

Thank you for the information!
by clv100
Thu Jan 07, 2016 6:08 pm
Forum: General
Topic: Lazy Projection
Replies: 2
Views: 7226

Lazy Projection

Can anyone explain what the term "lazy" projection means? Thanks!
by clv100
Thu Oct 24, 2013 8:18 pm
Forum: New to Vertica Database Administration
Topic: Row Counts for Tables Discrepancies
Replies: 13
Views: 25277

Re: Row Counts for Tables Discrepancies

Just as an update: Per Vertica, we ended up backing the table up(verifying that there were no dupes first), dropped and created the table and then copied from the backup back to the table . This was supposed to solve the problem but the next day there were a few "new" dupes. According to Vertica, th...
by clv100
Fri Oct 04, 2013 3:27 pm
Forum: New to Vertica Database Administration
Topic: Row Counts for Tables Discrepancies
Replies: 13
Views: 25277

Re: Row Counts for Tables Discrepancies

Thanks - can you tell me what the select "null" and the sub at the end of the SQL statement mean??
by clv100
Thu Oct 03, 2013 9:31 pm
Forum: New to Vertica Database Administration
Topic: Row Counts for Tables Discrepancies
Replies: 13
Views: 25277

Re: Row Counts for Tables Discrepancies

Yes. That is the way it is set up to work. The table has 32 updateable columns and the last updates are to set the maint_date and upd_flag('U') where the keys match.The next part of the scripts us where INSERT is done from the stage f_inventory columns to f_inventory with the upd_flag = 'I' and the ...
by clv100
Thu Oct 03, 2013 7:23 pm
Forum: New to Vertica Database Administration
Topic: Row Counts for Tables Discrepancies
Replies: 13
Views: 25277

Re: Row Counts for Tables Discrepancies

P.S. Duplicates from this morning: store_gen_key week_gen_key item_gen_key upd_flag maint_date 500920 52013035 9000767453 U 2013-10-01 500920 52013035 9000767453 U 2013-10-01 500920 52013035 9000767453 U 2013-10-02 500920 52013035 9000767466 U 2013-10-01 500920 52013035 9000767466 U 2013-10-01 50092...

Go to advanced search