I have similar code and get same error message. ERROR: Open error: Failed to transcode result set data in column 'ID'. Based on the above Jedi's hint, I add sub_char=QUESTIONMARK after your server option (see below). It works for me. You may try it. /******************************************************************************************************************/ Proc SQL; CONNECT TO HADOOP(SERVER="..."   sub_char=QUESTIONMARK ); create table work.Temp as SELECT * FROM CONNECTION TO HADOOP ( these are the simple select * from * SQL codes that can be ignored ) ; disconnect from Hadoop; quit; /*****************************************************************************************************************/ the code goes through and only receives warning message in the log: WARNING: At least one column failed to transcode. Characters that could not be transcoded were replaced with the SUBCHAR option value. Details of which columns failed can be seen with sastrace=',,d' enabled. ... View more