• The default delimiter for reading from file in Hive is \t.
  • We can save data to the below formats only by using INSERT INTO/ INSERT OVERWRITE command
  • Parquet, ORC, RCF store the metadata along with the data (So if we use an small file the compressed file will be larger than the original)
  • Formats like Parquet and ORC are called “Compression File Formats”

Supported File Formats: Text, ORC, RCF, Parquet, Sequence File Not Supported Format: Avro