sqoop 을 이용하여 import, export 처리중 다음과 같은 오류가 발생하는 경우가 있다.
3376 [uber-SubtaskRunner] ERROR org.apache.sqoop.manager.SqlManager - Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@6b80c0fb is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@6b80c0fb is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
이런 오류가 발생하는 경우 --driver 옵션을 지정하여 주면 된다.
사용법은 다음과 같다.
> sqoop export --driver com.mysql.jdbc.Driver --connect jdbc:mysql://0.0.0.0:4506