file_format

Format

| ORC

| PARQUET

| JSON

| CSV

| CARBON

| AVRO

Description

  • Currently, the preceding formats are supported.
  • Both USING and STORED AS can be used for specifying the data format. You can specify the preceding data formats by USING, but only the ORC and PARQUET formats by STORED AS.
  • ORC has optimized RCFile to provide an efficient method to store Hive data.
  • PARQUET is an analytical service-oriented and column-based storage format.
  • CARBON does not support the following data types: tinyint, float, and date.