DEFAULT_FILE_FORMAT Query Option

Use the DEFAULT_FILE_FORMAT query option to set the default table file format. The following values are supported:

  • TEXT (0)
  • RC_FILE (1)
  • SEQUENCE_FILE (2)
  • AVRO (3)
  • PARQUET (4)
  • KUDU (5)
  • ORC (6)

In impala-shell or Hue, the SET DEFAULT_FILE_FORMAT statement will not return an error when the option was set to an unsupported value. Impala validates the value and returns an error when you submitted the next query.

Type: Enum as specified above

Default: TEXT (0)

Added in: CDH 6.2