공부
[Hive] ROW FORMAT DELIMITED is only compatible with 'textfile', not 'orc'
승가비
2021. 12. 18. 16:33
728x90
if you are using any binary format (ORC, AVRO, Parquet) to store you data then ROW FORMAT DELIMITED FIELDS TERMINATED BY is just ignored, you can use it in your table syntax, it might not give you any error. However they are not being used
https://stackoverflow.com/questions/53871596/is-defining-a-delimiter-in-a-hive-orc-table-useless
Is defining a delimiter in a hive ORC Table useless?
When you create a ORC table in hive, you are changing the file type to be orc. This means you can't look at a specific file outside of the orc table. Here's an example orc create table statement
stackoverflow.com
728x90