We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How to fix multiple table declaration after materialize_flextable_columns? — Vertica Forum

How to fix multiple table declaration after materialize_flextable_columns?

After applying materialize_flextable_columns to a flex table \dt returns many same named tables with different comments like "Addedd successfully: some column", so I have so many table dups as materialized columns.
Simple research sows that all_tables contains multiple rows about the same table with just different "remarks".
version 09.03.0000

Utilities like DBeaver showing many copies too and hang with refresh.

Tagged:

Answers

  • Ariel_CaryAriel_Cary Vertica Employee Employee

    Hello. We're aware of that problem. Unfortunately that output is bogus. You do not actually have table duplicates in the database. Please use select * from tables to get the list of tables as a workaround for now. We're working to fix that output in a future release.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file