当前位置:首页 > 系统bug > 正文内容

Error: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier

2019-09-06 | 分类:系统bug | 评论:0人 | 浏览:34次

/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/bin/java "-javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=62243:/Applications/IntelliJ IDEA.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath /Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/packager.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_221.jdk/Contents/Home/lib/tools.jar:/Users/zzy/IdeaProjects/java_web/luanbgateway/bgateway/gateway-shell/target/classes:/Users/zzy/IdeaProjects/java_web/luanbgateway/bgateway/gateway-util-common/target/classes:/usr/local/apache-maven-3.3.9/repository/org/slf4j/slf4j-api/1.7.26/slf4j-api-1.7.26.jar:/usr/local/apache-maven-3.3.9/repository/org/slf4j/slf4j-log4j12/1.7.26/slf4j-log4j12-1.7.26.jar:/usr/local/apache-maven-3.3.9/repository/javax/servlet/javax.servlet-api/4.0.1/javax.servlet-api-4.0.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/directory/server/apacheds-jdbm/2.0.0-M5/apacheds-jdbm-2.0.0-M5.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/directory/server/apacheds-i18n/2.0.0-M5/apacheds-i18n-2.0.0-M5.jar:/usr/local/apache-maven-3.3.9/repository/com/fasterxml/jackson/core/jackson-core/2.9.8/jackson-core-2.9.8.jar:/usr/local/apache-maven-3.3.9/repository/com/fasterxml/jackson/core/jackson-databind/2.9.8/jackson-databind-2.9.8.jar:/usr/local/apache-maven-3.3.9/repository/com/fasterxml/jackson/core/jackson-annotations/2.9.0/jackson-annotations-2.9.0.jar:/Users/zzy/IdeaProjects/java_web/luanbgateway/bgateway/gateway-i18n/target/classes:/usr/local/apache-maven-3.3.9/repository/org/apache/httpcomponents/httpcore/4.4.11/httpcore-4.4.11.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/httpcomponents/httpclient/4.5.6/httpclient-4.5.6.jar:/usr/local/apache-maven-3.3.9/repository/commons-logging/commons-logging/1.2/commons-logging-1.2.jar:/usr/local/apache-maven-3.3.9/repository/net/minidev/json-smart/2.3/json-smart-2.3.jar:/usr/local/apache-maven-3.3.9/repository/net/minidev/accessors-smart/1.2/accessors-smart-1.2.jar:/usr/local/apache-maven-3.3.9/repository/org/ow2/asm/asm/5.0.4/asm-5.0.4.jar:/usr/local/apache-maven-3.3.9/repository/commons-codec/commons-codec/1.12/commons-codec-1.12.jar:/usr/local/apache-maven-3.3.9/repository/commons-io/commons-io/2.6/commons-io-2.6.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/commons/commons-lang3/3.8.1/commons-lang3-3.8.1.jar:/usr/local/apache-maven-3.3.9/repository/log4j/log4j/1.2.17/log4j-1.2.17.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hadoop/hadoop-common/2.9.2/hadoop-common-2.9.2.jar:/usr/local/apache-maven-3.3.9/repository/com/google/guava/guava/11.0.2/guava-11.0.2.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/commons/commons-math3/3.1.1/commons-math3-3.1.1.jar:/usr/local/apache-maven-3.3.9/repository/commons-net/commons-net/3.6/commons-net-3.6.jar:/usr/local/apache-maven-3.3.9/repository/commons-collections/commons-collections/3.2.2/commons-collections-3.2.2.jar:/usr/local/apache-maven-3.3.9/repository/org/mortbay/jetty/jetty-sslengine/6.1.26/jetty-sslengine-6.1.26.jar:/usr/local/apache-maven-3.3.9/repository/com/sun/jersey/jersey-core/1.9/jersey-core-1.9.jar:/usr/local/apache-maven-3.3.9/repository/commons-lang/commons-lang/2.6/commons-lang-2.6.jar:/usr/local/apache-maven-3.3.9/repository/com/google/protobuf/protobuf-java/2.5.0/protobuf-java-2.5.0.jar:/usr/local/apache-maven-3.3.9/repository/com/google/code/gson/gson/2.8.5/gson-2.8.5.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/curator/curator-client/4.2.0/curator-client-4.2.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/curator/curator-recipes/4.2.0/curator-recipes-4.2.0.jar:/usr/local/apache-maven-3.3.9/repository/com/google/code/findbugs/jsr305/3.0.0/jsr305-3.0.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/htrace/htrace-core4/4.1.0-incubating/htrace-core4-4.1.0-incubating.jar:/usr/local/apache-maven-3.3.9/repository/org/codehaus/woodstox/stax2-api/3.1.4/stax2-api-3.1.4.jar:/usr/local/apache-maven-3.3.9/repository/com/fasterxml/woodstox/woodstox-core/5.0.3/woodstox-core-5.0.3.jar:/usr/local/apache-maven-3.3.9/repository/commons-cli/commons-cli/1.4/commons-cli-1.4.jar:/usr/local/apache-maven-3.3.9/repository/commons-configuration/commons-configuration/1.10/commons-configuration-1.10.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hadoop/hadoop-hdfs-client/2.9.2/hadoop-hdfs-client-2.9.2.jar:/usr/local/apache-maven-3.3.9/repository/com/squareup/okhttp/okhttp/2.7.5/okhttp-2.7.5.jar:/usr/local/apache-maven-3.3.9/repository/com/squareup/okio/okio/1.6.0/okio-1.6.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hadoop/hadoop-auth/2.9.2/hadoop-auth-2.9.2.jar:/usr/local/apache-maven-3.3.9/repository/com/nimbusds/nimbus-jose-jwt/4.41.1/nimbus-jose-jwt-4.41.1.jar:/usr/local/apache-maven-3.3.9/repository/com/github/stephenc/jcip/jcip-annotations/1.0-1/jcip-annotations-1.0-1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/directory/server/apacheds-kerberos-codec/2.0.0-M15/apacheds-kerberos-codec-2.0.0-M15.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/directory/api/api-asn1-api/1.0.0-M20/api-asn1-api-1.0.0-M20.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/directory/api/api-util/1.0.0-M20/api-util-1.0.0-M20.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/zookeeper/zookeeper/3.4.13/zookeeper-3.4.13.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/yetus/audience-annotations/0.5.0/audience-annotations-0.5.0.jar:/usr/local/apache-maven-3.3.9/repository/io/netty/netty/3.10.6.Final/netty-3.10.6.Final.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/curator/curator-framework/4.2.0/curator-framework-4.2.0.jar:/usr/local/apache-maven-3.3.9/repository/junit/junit/4.12/junit-4.12.jar:/usr/local/apache-maven-3.3.9/repository/org/hamcrest/hamcrest-core/1.3/hamcrest-core-1.3.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-exec/1.1.0/hive-exec-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-ant/1.1.0/hive-ant-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/velocity/velocity/1.5/velocity-1.5.jar:/usr/local/apache-maven-3.3.9/repository/oro/oro/2.0.8/oro-2.0.8.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-metastore/1.1.0/hive-metastore-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/com/jolbox/bonecp/0.8.0.RELEASE/bonecp-0.8.0.RELEASE.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/derby/derby/10.14.2.0/derby-10.14.2.0.jar:/usr/local/apache-maven-3.3.9/repository/org/datanucleus/datanucleus-api-jdo/3.2.6/datanucleus-api-jdo-3.2.6.jar:/usr/local/apache-maven-3.3.9/repository/org/datanucleus/datanucleus-rdbms/3.2.9/datanucleus-rdbms-3.2.9.jar:/usr/local/apache-maven-3.3.9/repository/commons-pool/commons-pool/1.6/commons-pool-1.6.jar:/usr/local/apache-maven-3.3.9/repository/commons-dbcp/commons-dbcp/1.4/commons-dbcp-1.4.jar:/usr/local/apache-maven-3.3.9/repository/javax/jdo/jdo-api/3.0.1/jdo-api-3.0.1.jar:/usr/local/apache-maven-3.3.9/repository/javax/transaction/jta/1.1/jta-1.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/thrift/libthrift/0.9.2/libthrift-0.9.2.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-shims/1.1.0/hive-shims-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/shims/hive-shims-common/1.1.0/hive-shims-common-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/shims/hive-shims-0.20S/1.1.0/hive-shims-0.20S-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/shims/hive-shims-0.23/1.1.0/hive-shims-0.23-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/shims/hive-shims-scheduler/1.1.0/hive-shims-scheduler-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/antlr/ST4/4.0.4/ST4-4.0.4.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/ant/ant/1.9.1/ant-1.9.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/ant/ant-launcher/1.9.1/ant-launcher-1.9.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/commons/commons-compress/1.18/commons-compress-1.18.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/thrift/libfb303/0.9.2/libfb303-0.9.2.jar:/usr/local/apache-maven-3.3.9/repository/org/codehaus/groovy/groovy-all/2.1.6/groovy-all-2.1.6.jar:/usr/local/apache-maven-3.3.9/repository/org/datanucleus/datanucleus-core/3.2.10/datanucleus-core-3.2.10.jar:/usr/local/apache-maven-3.3.9/repository/stax/stax-api/1.0.1/stax-api-1.0.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-jdbc/1.1.0/hive-jdbc-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-service/1.1.0/hive-service-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/net/sf/jpam/jpam/1.1/jpam-1.1.jar:/usr/local/apache-maven-3.3.9/repository/org/eclipse/jetty/aggregate/jetty-all/7.6.0.v20120127/jetty-all-7.6.0.v20120127.jar:/usr/local/apache-maven-3.3.9/repository/javax/servlet/servlet-api/2.5/servlet-api-2.5.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/geronimo/specs/geronimo-jta_1.1_spec/1.1.1/geronimo-jta_1.1_spec-1.1.1.jar:/usr/local/apache-maven-3.3.9/repository/javax/mail/mail/1.4.1/mail-1.4.1.jar:/usr/local/apache-maven-3.3.9/repository/javax/activation/activation/1.1/activation-1.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/geronimo/specs/geronimo-jaspic_1.0_spec/1.0/geronimo-jaspic_1.0_spec-1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/geronimo/specs/geronimo-annotation_1.0_spec/1.1.1/geronimo-annotation_1.0_spec-1.1.1.jar:/usr/local/apache-maven-3.3.9/repository/asm/asm-commons/3.1/asm-commons-3.1.jar:/usr/local/apache-maven-3.3.9/repository/asm/asm-tree/3.1/asm-tree-3.1.jar:/usr/local/apache-maven-3.3.9/repository/asm/asm/3.1/asm-3.1.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/hive/hive-serde/1.1.0/hive-serde-1.1.0.jar:/usr/local/apache-maven-3.3.9/repository/org/apache/avro/avro/1.7.5/avro-1.7.5.jar:/usr/local/apache-maven-3.3.9/repository/org/codehaus/jackson/jackson-core-asl/1.9.13/jackson-core-asl-1.9.13.jar:/usr/local/apache-maven-3.3.9/repository/org/codehaus/jackson/jackson-mapper-asl/1.9.13/jackson-mapper-asl-1.9.13.jar:/usr/local/apache-maven-3.3.9/repository/com/thoughtworks/paranamer/paranamer/2.3/paranamer-2.3.jar:/usr/local/apache-maven-3.3.9/repository/org/xerial/snappy/snappy-java/1.0.5/snappy-java-1.0.5.jar:/usr/local/apache-maven-3.3.9/repository/net/sf/opencsv/opencsv/2.3/opencsv-2.3.jar:/usr/local/apache-maven-3.3.9/repository/com/twitter/parquet-hadoop-bundle/1.6.0rc3/parquet-hadoop-bundle-1.6.0rc3.jar:/usr/local/apache-maven-3.3.9/repository/jline/jline/2.12/jline-2.12.jar org.apache.hive.beeline.BeeLine -n guest -p guest-password –color=true -u ‘jdbc:hive2://localhost:8443/;ssl=true;sslTrustStore=/Users/zzy/IdeaProjects/java_web/luanbgateway/knox-1.2.0/data/security/keystores/gateway.jks;trustStorePassword=123456?hive.server2.transport.mode=http;hive.server2.thrift.http.path=/gateway/sandbox/hive’
scan complete in 4ms
Connecting to jdbc:hive2://localhost:8443/;ssl=true;sslTrustStore=/Users/zzy/IdeaProjects/java_web/luanbgateway/knox-1.2.0/data/security/keystores/gateway.jks;trustStorePassword=123456?hive.server2.transport.mode=http;hive.server2.thrift.http.path=/gateway/sandbox/hive
2019-08-21 18:21:06,671 INFO  [main] Supplied authorities: localhost:8443
2019-08-21 18:21:06,674 WARN  [main] ***** JDBC param deprecation *****
2019-08-21 18:21:06,674 WARN  [main] The use of hive.server2.transport.mode is deprecated.
2019-08-21 18:21:06,674 WARN  [main] Please use transportMode like so: jdbc:hive2://<host>:<port>/dbName;transportMode=<transport_mode_value>
2019-08-21 18:21:06,674 WARN  [main] ***** JDBC param deprecation *****
2019-08-21 18:21:06,675 WARN  [main] The use of hive.server2.thrift.http.path is deprecated.
2019-08-21 18:21:06,675 WARN  [main] Please use httpPath like so: jdbc:hive2://<host>:<port>/dbName;httpPath=<http_path_value>
2019-08-21 18:21:06,675 INFO  [main] Resolved authority: localhost:8443
Connected to: Apache Hive (version 1.2.2)
Driver: Hive JDBC (version 1.1.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0 by Apache Hive
0: jdbc:hive2://localhost:8443/> show databases;
show databases;
+—————-+–+
| database_name  |
+—————-+–+
| default        |
| test_db        |
| zwctest        |
+—————-+–+
3 rows selected (0.776 seconds)
0: jdbc:hive2://localhost:8443/> use default;
use default;
No rows affected (1.156 seconds)
0: jdbc:hive2://localhost:8443/> show tables;
show tables;
+———–+–+
| tab_name  |
+———–+–+
| employee  |
| fz        |
+———–+–+
2 rows selected (1.266 seconds)
0: jdbc:hive2://localhost:8443/> select * from employee;
select * from employee;
org.apache.thrift.transport.TTransportException: HTTP Response code: 500
    at org.apache.thrift.transport.THttpClient.flushUsingHttpClient(THttpClient.java:262)
    at org.apache.thrift.transport.THttpClient.flush(THttpClient.java:313)
    at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:65)
    at org.apache.hive.service.cli.thrift.TCLIService$Client.send_FetchResults(TCLIService.java:495)
    at org.apache.hive.service.cli.thrift.TCLIService$Client.FetchResults(TCLIService.java:487)
    at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:360)
    at org.apache.hive.beeline.BufferedRows.<init>(BufferedRows.java:42)
    at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1704)
    at org.apache.hive.beeline.Commands.execute(Commands.java:791)
    at org.apache.hive.beeline.Commands.sql(Commands.java:663)
    at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:922)
    at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:762)
    at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:724)
    at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:454)
    at org.apache.hive.beeline.BeeLine.main(BeeLine.java:437)
0: jdbc:hive2://localhost:8443/> Error: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=bef44924-14d2-49d3-80d8-13eab7b38937] (state=,code=0)

Error: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier

 

问题解决请联系站长

来源:赵大虾博客(微信号/QQ号:),转载请注明出处,谢谢!

  • 评论:(0)

已有 0 位网友发表了一针见血的评论,你还等什么?

◎欢迎参与讨论!

傲笑九天志在必得, 卧薪尝胆勇者无畏

站内搜索

傲笑九天志在必得, 卧薪尝胆勇者无畏

傲笑九天志在必得, 卧薪尝胆勇者无畏