Fixing duplicate records in a table that is used as a dimension in a prejoined projection
I have a table that had duplicate records mistakenly imported into it.
I am trying a number of ways to correct this. I've created a new temporary table using:
CREATE TABLE new_table AS SELECT DISTINCT * FROM users;
I then tried to truncate users.
I am getting the following error:
[Vertica][VJDBC](4882) ROLLBACK: Table "users" is used as a dimension in a prejoined projection
What do I need to do to remove the duplicate records from the users table?