关闭

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set

标签: sqoophivemysql
1452人阅读 评论(0) 收藏 举报
分类:

问题

在使用sqoop导入数据时,报如下错误:

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2cbefcfd 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@2cbefcfd 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-connector-java-。。。-bin.jar这个jar包出现了问题,可能是版本太低的原因。

解决方案

http://download.csdn.net/detail/heixiazuoluo10254222/7706781
在这里下载mysql-connector-java-5.1.31-bin
并替换掉原来sqoop目录下lib文件夹下的连接数据库jar包。这样就不会有问题了,如下截图。
这里写图片描述

2
0
查看评论

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set

异常起因将Mysql导入Hive中Sqoop提示的异常信息异常信息 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.Ro...
  • xiewendong93
  • xiewendong93
  • 2016-03-21 09:44
  • 1629

sqoop-导入数据出现java.sql.SQLException: Streaming result set com.mysql.jdbc.

hadoop之sqoop导入异常
  • l_lushuang
  • l_lushuang
  • 2016-01-26 13:38
  • 1647

ERROR Streaming result set com.mysql.jdbc.RowDataDynamic@1d5a7f6 is still active. No statements may

[jifeng@jifeng02 sqoop]$ bin/sqoop import --connect jdbc:mysql://10.X.X.X:3306/lir --username dss --password 123123 --table bb_month --hive-import -m ...
  • wind520
  • wind520
  • 2014-09-08 01:37
  • 7355

ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user

使用sqoop从MySQL数据库导出数据时: [root@node3 bin]# ./sqoop import --connect jdbc:mysql://192.168.0.109:3306/fantest1 --username root --password root --table go...
  • fanrenxiang
  • fanrenxiang
  • 2017-05-21 11:56
  • 1800

MySql允许被远程访问

今天在linux上远程访问windows下的mysql时出现如下异常:  ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: null,  message from server...
  • zwx19921215
  • zwx19921215
  • 2014-12-11 16:00
  • 2339

Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDyna

一异常原因用Sqoop将数据从mysql导入到Hbase表出现异常如下: [root@master bin]# ./sqoop import --connect jdbc:mysql://192.168.10.169/qyyx_test --username root -- pass...
  • xiaoshunzi111
  • xiaoshunzi111
  • 2016-06-28 18:29
  • 1775

使用sqoop时,Ensure that you have called .close() on any active streaming result sets before attempting

Warning: /opt/cloudera/parcels/CDH-5.5.1-1.cdh5.5.1.p0.11/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMUL...
  • u013430507
  • u013430507
  • 2016-08-17 13:52
  • 666

SQL

SQL操作全集 下列语句部分是Mssql语句,不可以在access中使用。 SQL分类: DDL—数据定义语言(CREATE,ALTER,DROP,DECLARE) DML—数据操纵语言(SELECT,DELETE,UPDATE,INSERT) DCL—数据控制语言(GRANT,REVOKE,COM...
  • anysky130
  • anysky130
  • 2008-06-01 08:01
  • 370

基于Android4.0版本截屏+node.js服务器接收显示

最近在开发同屏,做了个Dome,记录下成果! 首先是web端和服务器端,这里我使用node.js来做的
  • Alin693
  • Alin693
  • 2017-09-21 17:20
  • 447

Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timest

HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: Error attempting to get...
  • u012012240
  • u012012240
  • 2016-05-05 15:14
  • 2464
    个人资料
    • 访问:485067次
    • 积分:5434
    • 等级:
    • 排名:第5896名
    • 原创:136篇
    • 转载:10篇
    • 译文:0篇
    • 评论:187条
    联系方式

    欢迎评论交流,正常情况每天都会查看博客!

      邮箱:1563178220@qq.com;qy20115549@126.com
      发送邮件或申请加qq好友的,请注明咨询或者源码获取,白天较少回复请留言,将相关问题说明。

      由于本人知识有限,博客难免会有错误或疏漏之处,发现会及时修正。另外本人博客仅供学习使用,未经本人允许,禁止转载,或者上传到百度文库、道客巴巴等平台

    博客专栏
    Since 2018.02.01: Flag Counter Flag Counter
    最新评论