티스토리 뷰

공부

[hive] `VARCHAR` vs `STRING` -> STRING is winner

승가비 2023. 2. 26. 12:27
728x90

I would recommend string if at all possible - You are correct that it is very handy to not be limited by a length specifier. Even if the data coming in is only Varchar(30) in length, your ELT/ETL processing will not fail if you send in 31 characters while using a string datatype.

 

https://community.cloudera.com/t5/Support-Questions/Hive-STRING-vs-VARCHAR-Performance/m-p/157939

 

Hive STRING vs VARCHAR Performance

Hi, We have prototyping a datawarehouse solution on Hadoop/Hive. One of the issue arised was whther we should use same datatype e.g. varchar2 in Oracle converts to varchar in Hive. number in Oracle to int in Hive, date in Oracle to timestamp in Hive etc. I

community.cloudera.com

 

728x90
저작자표시 비영리

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

[kotlin] jsoup & retries  (0) 2023.02.26
[terraform] command (init, apply, plan)  (0) 2023.02.26
[aws] install `Amazon Corretto 11`  (0) 2023.02.26
[spark] spark.conf.set("spark.sql.legacy.timeParserPolicy", "LEGACY")  (0) 2023.02.26
[kotlin] semaphore & coroutine  (0) 2023.02.26
댓글