Note: Using XMLTYPE.GETSTRINGVAL won't work if XMLRECORD size is greater than 4000. Use XMLTYPE.GETCLOBVAL sqoop import --connect "jdbc:oracle:thin:@xxx:1521:dcpdb" --username "nblt24" --password "nblt24" --query 'SELECT RECID, XMLTYPE.GETCLOBVAL(XMLRECORD) FROM F_COMPANY where $CONDITIONS' --target-dir /home/hduser/hadoop/share/hadoop/hdfsa --delete-target-dir --num-mappers 1 --hive-import --hive-table hr.f_company_xml_tab --verbose ... View more