Search found 27 matches
- Fri Feb 05, 2016 3:25 pm
- Forum: Vertica Upgrade
- Topic: Upgrade 6.0 to 7.1 - database is slower
- Replies: 1
- Views: 15627
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...
- Fri Jan 08, 2016 8:51 pm
- Forum: General
- Topic: Lazy Projection
- Replies: 2
- Views: 7264
Re: Lazy Projection
Thank you for the information!
- Thu Jan 07, 2016 6:08 pm
- Forum: General
- Topic: Lazy Projection
- Replies: 2
- Views: 7264
Lazy Projection
Can anyone explain what the term "lazy" projection means? Thanks!
- Thu Oct 24, 2013 8:18 pm
- Forum: New to Vertica Database Administration
- Topic: Row Counts for Tables Discrepancies
- Replies: 13
- Views: 25434
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...
- Fri Oct 04, 2013 3:27 pm
- Forum: New to Vertica Database Administration
- Topic: Row Counts for Tables Discrepancies
- Replies: 13
- Views: 25434
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??
- Thu Oct 03, 2013 9:31 pm
- Forum: New to Vertica Database Administration
- Topic: Row Counts for Tables Discrepancies
- Replies: 13
- Views: 25434
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 ...
- Thu Oct 03, 2013 7:23 pm
- Forum: New to Vertica Database Administration
- Topic: Row Counts for Tables Discrepancies
- Replies: 13
- Views: 25434
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...