For the most part, I think just using the string type is sufficient.
---- Replied Message ---- | From | liubin_w...@yeah.net | | Date | 01/16/2025 15:01 | | To | user@hive.apache.org | | Cc | | | Subject | which one is better to use in hive when storage date like text type ,string or varchar? | Hi Developer, I met a problem with using the hive, while I was creating a data table. In such case, I want to keep the efficiency of query and minimum size of data occupy in hive, but some fields in this table are indefinite length. Which data type is best for this case? Or I should use all of them in this table, the varchar for definite length field, and the string for indefinite length field. Thanks for your help!