Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How do we view complex types if visualization tool doesn't support them?

Deb_ChatignyDeb_Chatigny Administrator
edited April 2020 in General Discussion

With the use of complex types, how do we effectively view data in these complex types if visualization layer does not support them?

How efficient is flattening? Would storing them in flattened project not just be a waste of resources (etl should have flattened them to begin with).

Question asked by an attendee during Putting Complex Data Types to Work. @DeepakMajeti

Related question:


  • why not expose them in a view? Ideally whatever is querying the data will significantly reduce the rows returned

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.