Which datatype to use in hive for nvarchar(max) in SQL

sqoop

#1

Hello,

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.
Nitesh