FlexZone: exploring multiline name value records
I know FlexZone allows exploring data before creating a defined data model or schema in Vertica and this can be done with data from JSON, CSV or similar data.
I would like to know if it is possible to load data into FlexZone which is in a specific ASCII format: a number of lines for each record (newline defines new field), one extra new line means a new record and most of the fields are in the format on FieldName <Separator> FieldValue (similar to name value format in some RADIUS accounting records for example).
Is there any parser or tool to be able to analyze this type of input files with FlexZone in order to discover the type of fields and values before creating a proper data model?
Thanks for your suggestions
I would like to know if it is possible to load data into FlexZone which is in a specific ASCII format: a number of lines for each record (newline defines new field), one extra new line means a new record and most of the fields are in the format on FieldName <Separator> FieldValue (similar to name value format in some RADIUS accounting records for example).
Is there any parser or tool to be able to analyze this type of input files with FlexZone in order to discover the type of fields and values before creating a proper data model?
Thanks for your suggestions
0