Pt-archiver use updatable view instead of table

If a view(updatable) name is specified in place of table, we get the following error:

TableParser doesn’t handle CREATE TABLE without quoting. at /usr/bin/pt-archiver line 1951, line 1.

It looks like the pt-archiver script is trying to parse a CREATE TABLE ddl and generate list of columns and their type. While DB substitutes table with view and returns the view creation ddl, it contains columns in different format.

Is there any suggestion / option where we can avoid this error? Only alternative we see is to use view in the where selection criteria.

1 Like