How efficiently are the complex types physically stored (encoding, storage footprint, CPU/memory consumption when working with them)?
Question asked by an attendee during Putting Complex Data Types to Work. @DeepakMajeti @rroelke
Vague question... but basically, as efficient as a deconstructed set of primitive types, if you use the new CT stuff (So... extremely efficient!). Sometimes inefficient, if you use unoptimized flex maps.
FYI, one-dimensional arrays are the only complex types that can currently be stored in ROS data; everything else is external tables.
What encoding can be used in case of the new CT stuff?
I am creating an SQL table that will provide the back-end storage mechanism for complex-typed objects. I am trying to determine how to accomplish this with the best performance. I need to be able to query on each individual simple type value of the complex type (e.g. the String value of a City in an Address complex type). VidMate TeaTV Shareit
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.