Convert Avro to TSV

Avro is a row-based data serialization system developed within Apache's Hadoop project. It provides rich data structures and a compact, fast binary data format.

Technical Details

Avro uses JSON for defining data schemas, which are stored with the data. This enables schema evolution while maintaining compatibility. The data itself is stored in a compact binary format.

Advantages

• Compact binary serialization
• Schema definition included with the data
• Support for schema evolution
• Dynamic typing and code generation

Limitations

• Not human-readable without special tools
• Less widely supported than formats like JSON or CSV
• More complex to implement than simpler formats
• Less efficient for columnar queries than Parquet

Tab-separated values (TSV) is another simple and widely used format for storing tabular data. Like CSV, it's easy to read and create.

Row delimiter

The row delimiter in TSV data is usually a new line character (LF) or a carriage return plus a new line character (CRLF).

We'll automatically detect and parse the rows correctly, so you don't need to worry about it.

Value separator

In TSV files, the value separator is typically a tab character, but it can vary depending on the software used to create the file.

Character encoding

The character encoding of your TSV file might differ based on the software you used to create it.

If you're not sure about the character encoding, don't worry. We'll try to guess it automatically if it's not specified.