TSV to ORC
Convert Tab-Separated Values (.tsv) to Optimized Row Columnar (.orc).
Source Tab-Separated Values: TSV (Tab-Separated Values) splits fields with tabs, sidestepping CSV's comma-in-field escaping problem entirely. Bioinformatics annotation tables, Google Search Console exports, and database dumps ship as TSV, and Excel, pandas, and R open it directly. Convert to CSV, Parquet, or XLSX depending on whether sharing, analytics, or human review is the goal.
Target Optimized Row Columnar: ORC (Optimized Row Columnar) is the Apache Hive warehouse format with predicate pushdown, lightweight compression, ACID transactions, and vectorized execution - the default table storage for serious Hive deployments. Convert to Parquet to cross into the broader Spark and Presto ecosystem, to CSV or JSON for small-scale inspection, or to Feather for fast Python reads.