...
| Syntax | Equivalent |
|---|---|
STORED AS AVRO / STORED AS AVROFILE | ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' |
STORED AS ORC / STORED AS ORCFILE | ROW FORMAT SERDE ' STORED AS INPUTFORMAT ' OUTPUTFORMAT ' |
STORED AS PARQUET / STORED AS PARQUETFILE | ROW FORMAT SERDE ' STORED AS INPUTFORMAT ' OUTPUTFORMAT ' |
| STORED AS RCFILE | STORED AS INPUTFORMAT OUTPUTFORMAT ' |
| STORED AS SEQUENCEFILE | STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT ' |
| STORED AS TEXTFILE | STORED AS INPUTFORMAT ' OUTPUTFORMAT |
...