...
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 OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat' |
STORED AS SEQUENCEFILE | STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat' |
STORED AS TEXTFILE | STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' |
To add a new native SerDe with STORED AS keyword, follow these steps:
...