...
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 org.apache.hadoop.hive.ql.io.RCFileInputFormat' OUTPUTFORMAT
' |
STORED AS SEQUENCEFILE | STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT '
|
STORED AS TEXTFILE | STORED AS INPUTFORMAT
' OUTPUTFORMAT
|
...