CSV to ORC
Convert Comma-Separated Values (.csv) to Optimized Row Columnar (.orc).
Source Comma-Separated Values: CSV (Comma-Separated Values) is the lingua franca of tabular data: one record per line, fields split by commas, understood by Excel, Google Sheets, every database, and every analysis language. Its plain-text simplicity powers exports, imports, and system integrations everywhere. The costs are the lack of types, formulas, and multiple sheets, plus dialect quirks around quoting and encodings. Convert to XLSX for formatting and formulas, or to JSON and Parquet for programmatic pipelines.
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.