Varchar was only added to Hive in 0.12, before that there was only string if
you wanted to deal with string types. Varchar will enforce the max character
length, truncating the string value if necessary. We've tried to make it as
compatible with string as possible.
One thing about varchars, if y
>
> I am a newbie to hive. I am trying to query an oracle table in hive. The
> data is in hadoop and i have created similar varchar columns in my external
> table. Would like to know what are the limitations of varchar over string.
> And why people prefer string over varchar.
>
> Thanks,
> Gayathri
