I have imported the logs from SQL server to HDFS in compressed format(.gz).
I created a external table in hive on top of this data. Those logs have a column of datatype nvarchar(max) in SQL. Which should be the corresponding datatype to be used in hive?
I tried using the string datatype in hive but facing the below issue:
While running the select query in hive, I can’t see the whole text of that column in the result.
Kindly suggest a solution.
Thanks in advance.