Guys,
We've altered the partition granularity of one of our tables to Daily, which was earlier partitioned by month. The reorganization of the table post the partition alteration failed on one of the projections.
The results of the SQL below shows the operation_status as "ABORTED" for the projection in a couple of Vertica nodes.
select * from tuple_mover_operations where operation_name='Partitioning' and table_schema='XXX' and table_name='CALL_DETAIL' and projection_name like 'CALL_DETAIL%';
This has left the partition re-organization incomplete at 63%.
select * from V_MONITOR.PARTITION_STATUS Where table_schema='XXX' and projection_name like 'CALL_DETAIL%';
projection_id | table_schema | table_name | table_id | projection_schema | projection_name | partition_reorganize_percent
-------------------+--------------+-----------------+-------------------+-------------------+-----------------------------+------------------------------
45035996836332512 | XXX | CALL_DETAIL | 45035996273721024 | XXX | CALL_DETAIL_PK_BASED_b0 | 100
45035996836332944 | XXX | CALL_DETAIL | 45035996273721024 | XXX | CALL_DETAIL_PK_BASED_b1 | 63 <<<<<
(2 rows)
There is no records fetched from "PARTITION_REORGANIZE_ERRORS" dictionary table though. So , I've no ideas to what has caused the reorg. to fail.
Could some one please advise the way forward? Should we perform REORGANIZE of the table once again and be optimistic that it would succeed this time around? Is there an option to reorganize just the failed projection?
Thank you all for your guidance!
-Bhagat
Table Reorganize failed on one of the projections.
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Table Reorganize failed on one of the projections.
How many partitions are being created as a result of changing from a monthly partition to a daily partition?
Checkout vertica.tips for more Vertica resources.
Re: Table Reorganize failed on one of the projections.
dbadmin=> SELECT COUNT( DISTINCT PARTITION_KEY) FROM PARTITIONS WHERE table_schema='XXX' AND PROJECTION_NAME LIKE '%CALL_DETAIL%';
COUNT
-------
111
(1 row)
It's 111.
Regards,
Bhagat
COUNT
-------
111
(1 row)
It's 111.
Regards,
Bhagat