ERROR manager.SqlManager: Error reading from database: java.sql.SQLException:
Streaming result set com.mysql.jdbc.RowDataDynamic@5119fb47 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@5119fb47 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.
这个问题是因为驱动没有加上的问题,
加上mysql驱动:
--driver com.mysql.jdbc.Driver \
完整版:
/apps/sqoop-1.4.6/bin/sqoop import \
--connect jdbc:mysql://mini1:3306/shop \
--username root \
--password 123456 \
--driver com.mysql.jdbc.Driver \
-table goods \
-m 1 \
--fields-terminated-by ',' \
--lines-terminated-by '\n' \
--create-hive-table \
--hive-overwrite \
--hive-import \
--hive-table 'dim_shop.goods_dim' \
--null-string '\\N' \
--null-non-string '\\N' \