Query regarding String and Varchar in Hive

Question

I want to create a table for some columns data from is in the form of characters, which of the String and Varchar would be preferred? If any difference while execution could you explain to me those?

Answer 1

Varchar datatype is also saved internally as a String. Now the Hive Varchar does not support vectorization. Vectorization allows Hive to process a batch of rows together instead of processing one row at a time. Operations are performed on the entire column vector which improves the instruction pipelines and cache usage.