question SQOOP import of "image" data type into hive in Support Questions

question SQOOP import of "image" data type into hive in Support Questions https://community.cloudera.com/t5/Support-Questions/SQOOP-import-of-quot-image-quot-data-type-into-hive/m-p/283584#M210748 I am trying to import a table from MSSQL which has few columns with data type "Image" The value in the columns are of binary format(LOBS) . Ex database type : MSSQL column name : Settings Data_type : image value of the column: ( 0x1F8B0800000400EDBD07601C499625262FD7E0CC188CDE692EC1D69472329AB2A81CA6501320CCE74A10880604010ED9D....)   When I import using sqoop the COLUMNS is automatically taken as string in hive but the data is corrupted.   COMMAND USED :   sqoop import --driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver' --connect 'jdbc:sqlserver://IP:PORT;database=DB;' --connection-manager 'org.apache.sqoop.manager.SQLServerManager' --username <> -password <> --as-parquetfile --delete-target-dir --target-dir '/user/test/' --query "select GUID,Name,cast(Settings AS binary) AS Settings FROM my_table_name where \$CONDITIONS; " --m 1       Thu, 21 Nov 2019 09:00:39 GMT sow 2019-11-21T09:00:39Z