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

最新推荐文章于 2023-09-13 15:45:08 发布
最新推荐文章于 2023-09-13 15:45:08 发布
阅读量1.1w 收藏
点赞数 1
分类专栏： Hadoop 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wind520/article/details/39127843
版权

用sqoop导入mysql出现错误：

[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 100
Warning: /home/jifeng/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /home/jifeng/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Warning: $HADOOP_HOME is deprecated.

14/09/08 01:10:12 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
14/09/08 01:10:12 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
14/09/08 01:10:12 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
14/09/08 01:10:12 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
14/09/08 01:10:12 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
14/09/08 01:10:12 INFO tool.CodeGenTool: Beginning code generation
14/09/08 01:10:12 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `bb_month` AS t LIMIT 1
14/09/08 01:10:12 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@1d5a7f6 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@1d5a7f6 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.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:930)
        at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2694)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1868)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
        at com.mysql.jdbc.ConnectionImpl.getMaxBytesPerChar(ConnectionImpl.java:3030)
        at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:592)
        at com.mysql.jdbc.ResultSetMetaData.getPrecision(ResultSetMetaData.java:444)
        at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:285)
        at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
        at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
        at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
        at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1773)
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1578)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:601)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
14/09/08 01:10:12 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1584)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:601)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:236)

网上搜索是mysql的bug，下载新的jar就可以了 

[jifeng@jifeng02 ~]$ wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.32.tar.gz
--2014-09-08 01:20:16--  http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.32.tar.gz
正在解析主机 dev.mysql.com... 137.254.60.11
正在连接 dev.mysql.com|137.254.60.11|:80... 已连接。
已发出 HTTP 请求，正在等待回应... 302 Found
位置：http://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-5.1.32.tar.gz [跟随至新的 URL]
--2014-09-08 01:20:21--  http://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-5.1.32.tar.gz
正在解析主机 cdn.mysql.com... 23.41.85.226
正在连接 cdn.mysql.com|23.41.85.226|:80... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：3795067 (3.6M) [application/x-tar-gz]
正在保存至: “mysql-connector-java-5.1.32.tar.gz”

40% [============================>                                             ] 1,518,632    488K/s eta(英国中部时44% [================================>                                         ] 1,696,736    508K/s eta(英国中部时48% [===================================>                                      ] 1,854,568    523K/s eta(英国中部时54% [=======================================>                                  ] 2,052,944    543K/s eta(英国中部时57% [=========================================>                                ] 2,186,160    563K/s eta(英国中部时60% [===========================================>                              ] 2,302,000    572K/s eta(英国中部时63% [=============================================>                            ] 2,404,808    579K/s eta(英国中部时66% [================================================>                         ] 2,535,128    590K/s eta(英国中部时70% [==================================================>                       ] 2,656,760    601K/s eta(英国中部时73% [=====================================================>                    ] 2,803,008    613K/s eta(英国中部时77% [========================================================>                 ] 2,939,120    624K/s eta(英国中部时81% [===========================================================>              ] 3,104,192    645K/s eta(英国中部时85% [==============================================================>           ] 3,257,680    656K/s eta(英国中部时90% [==================================================================>       ] 3,437,232    669K/s eta(英国中部时95% [=====================================================================>    ] 3,609,544    681K/s eta(英国中部时100%[=========================================================================>] 3,795,067    698K/s   in 6.2s    

2014-09-08 01:20:27 (597 KB/s) - 已保存 “mysql-connector-java-5.1.32.tar.gz” [3795067/3795067])


wind520
关注
专栏目录
Flink Record has Long.MIN_VALUE timestamp (= no timestamp marker). Is the time characteristic
Top5软件工程硕士，先后在京东、字节从事多年Java后端开发、实时和离线大数据开发
04-15 7667
报错： Exception in thread "main" org.apache.flink.runtime.client.JobExecutionException: Job execution failed. at org.apache.flink.runtime.jobmaster.JobResult.toJobExecutionResult(JobResult.java:147) at org.apache.flink.runtime.minicluster.MiniCluste...
AttributeError: module ‘openai‘ has no attribute ‘error‘解决方案
最新发布
weixin_43178406的博客
01-17 3万+
本文主要介绍了AttributeError: module ‘openai’ has no attribute 'error’解决方案，希望能对使用langchain的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案 2.1 方案一 2.2 方案二
sqoop Streaming result set com.mysql.jdbc.RowDataDynamic is still active
fanchw的专栏
07-06 1724
2020-07-06 11:20:56,735 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@7a2bfad9 is still active. No statements may be issued when any streaming result sets are open and in us
No statements may be issued when any streaming result sets are open and in use on a given connection
小妖666个人笔记
09-18 3287
eclipse下面的错误，注意下面错误中标红字体处。 Streaming result set com.mysql.jdbc.RowDataDynamic@cf13b1 is still active. No statements may be issued when any streaming result sets are open and in use on a given connect...
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@44f16719 is still active.
ToLightElegantly的博客
07-30 711
sqoop 导入mysql 表时,出现以下异常: 19/07/28 07:44:44 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@1ea9f6af is still active. No statements may be issued when any streaming result sets
The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH
weixin_43616627的博客
01-13 3897
The specified datastore driver (“com.mysql.jdbc.Driver”) was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver已解决 要执行的代码如下： object HiveRead { def mai...
没弄懂的 Texture Mipmap Streaming (Unity 2018.2)
游戏路上的小学生
07-24 1万+
首先，没弄懂 这个东西是否带来了性能上的提升？ 它用少量CPU资源以节省潜在的大量GPU内存。 Texture mipmap Streaming系统使您可以控制实际加载到内存中的mipmap级别。 通常Unity会加载存储在磁盘上的所有mipmap级别，但是使用此系统，您可以直接控制加载哪些mipmap级别。 通常，这样的系统通过仅加载渲染场景中当前相机位置所需的...
Mysql报错 Error querying database. Cause java.sql.SQLSyntaxErrorException
egegerhn的博客
07-30 1万+
先自我介绍一下，小编13年上师交大毕业，曾经在小公司待过，去过华为OPPO等大厂，18年进入阿里，直到现在。因此我收集了一份《java开发全套学习资料》送给大家，初衷也很简单，就是希望帮助到想自学又不知道该从何学起的朋友，同时减轻大家的负担。这个问题也是比较头疼，找了很久(关键是这个sql语句在navicat上能运行）,最后发现因为我这个项目用到了分页的插件，所以执行的时候后面会自动给我加上分页的sql语句，然而我最后排序那里写了个分号，所以报错了。最后成功运行，查询到了结果。...
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@27ce24aa is still active
翎野君的博客
03-20 1861
在Sqoop往mysql导出数据的时候报了这个错误，一开始还以为是jar包没有打进去或者打错位置了，未解便上网查询。 Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@27ce24aa is still active. No stateme...
解决问题 Sqoop No statements may be issued when any streaming result sets are open and in use
东语的专栏
09-13 358
sqoop 执行import或者export时候，出现错误。Sqoop No statements may be issued when any streaming result sets are open and in use
Sqoop No statements may be issued when any streaming result sets are open and in use on a given conn
好民小张的博客
03-09 853
Sqoop import命令报错 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. 1.原命令: sqoop import --connect jd
mysql resultset size_记一个MySQLStreamingresultset时的小错误
weixin_31567239的博客
01-21 638
同事使用kettle迁移MySQL数据时出现了 SQLException，详细报错信息如下：Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@xxxxxxx is still active. No statements may be issue...
Sqoop导mysql库到Hive中com.mysql.jdbc.RowDataDynamic错误解决
Qi.zheng
10-26 971
ERROR manager.SqlManager: Error reading from database: java.sql.SQLException:  Streaming result set com.mysql.jdbc.RowDataDynamic@1d5a7f6 is still active. No statements may be issued  when any strea
使用sqoop时，Ensure that you have called .close() on any active streaming result sets before attempting
郭靖的专栏
08-17 2449
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 $ACCUMULO_HOME to the root of your Accumulo installation. 1
WebSocket入门：socket.io通信模型解析
socket.io不仅支持WebSocket，还兼容其他如FlashSocket、AJAX long-polling、AJAX multipart streaming、Forever IFrame和JSONP polling等多种技术，确保在不同浏览器和设备上的广泛兼容性。这样，开发者无需关心...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值