티스토리 뷰

공부

[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
저작자표시 비영리 변경금지

'공부' 카테고리의 다른 글

[Java] map.foreach((k, v) -> {})  (0) 2021.12.18
[Hive] ORC 파일 포맷  (0) 2021.12.18
[Linux] Couldn't authenticate to server: Bad sendauth version was sent  (0) 2021.12.18
[Java] intersection retainAll()  (0) 2021.12.18
[Java] print List<T>  (0) 2021.12.16
댓글