[ https://issues.apache.org/jira/browse/HIVE-22352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17183003#comment-17183003 ]
chenruotao commented on HIVE-22352: ----------------------------------- maybe you should try to set hive.sql.query.fieldNames=id,date and set hive.sql.query.fieldTypes=int,timestamp or update the ext table column name col1 to id and col2 to date > Hive JDBC Storage Handler, simple select query failed with NPE if executed > using Fetch Task > ------------------------------------------------------------------------------------------- > > Key: HIVE-22352 > URL: https://issues.apache.org/jira/browse/HIVE-22352 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.1.1 > Environment: Hive-3.1 > Reporter: Rajkumar Singh > Priority: Blocker > > Steps To Repro: > > {code:java} > // MySQL Table > CREATE TABLE `visitors` ( `id` bigint(20) unsigned NOT NULL, `date` timestamp > NOT NULL DEFAULT CURRENT_TIMESTAMP ) > // hive table > CREATE EXTERNAL TABLE `hive_visitors`( `col1` bigint COMMENT 'from > deserializer', `col2` timestamp COMMENT 'from deserializer') ROW FORMAT SERDE > 'org.apache.hive.storage.jdbc.JdbcSerDe' STORED BY > 'org.apache.hive.storage.jdbc.JdbcStorageHandler' WITH SERDEPROPERTIES ( > 'serialization.format'='1') TBLPROPERTIES ( 'bucketing_version'='2', > 'hive.sql.database.type'='MYSQL', 'hive.sql.dbcp.maxActive'='1', > 'hive.sql.dbcp.password'='hive', 'hive.sql.dbcp.username'='hive', > 'hive.sql.jdbc.driver'='com.mysql.jdbc.Driver', > 'hive.sql.jdbc.url'='jdbc:mysql://hostname/test', > 'hive.sql.table'='visitors', 'transient_lastDdlTime'='1554910389') > Query: > select * from hive_visitors ; > Exception: > 2019-10-16T04:04:39,483 WARN [HiveServer2-Handler-Pool: Thread-71]: > thrift.ThriftCLIService (:()) - Error fetching results: > org.apache.hive.service.cli.HiveSQLException: java.io.IOException: > java.lang.NullPointerException at > org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:478) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:328) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:952) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) ~[?:?] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_112] at java.lang.reflect.Method.invoke(Method.java:498) > ~[?:1.8.0_112] at > org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_112] at > javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_112] at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730) > ~[hadoop-common-3.1.1.3.1.4.0-315.jar:?] at > org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > com.sun.proxy.$Proxy42.fetchResults(Unknown Source) ~[?:?] at > org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:565) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:792) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[?:1.8.0_112] at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > ~[?:1.8.0_112] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112] Caused > by: java.io.IOException: java.lang.NullPointerException at > org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:602) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:509) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2739) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:229) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:473) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] ... 24 more Caused > by: java.lang.NullPointerException at > org.apache.hive.storage.jdbc.JdbcSerDe.deserialize(JdbcSerDe.java:164) > ~[hive-jdbc-handler-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] at > org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:583) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:509) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2739) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:229) > ~[hive-exec-3.1.0.3.1.4.0-315.jar:3.1.1000-SNAPSHOT] at > org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:473) > ~[hive-service-3.1.0.3.1.4.0-315.jar:3.1.0.3.1.4.0-315] > > {code} > > setting fetch.task.conversion=none avoids NPE and yield correct results, the > column key lookup failed because of hashcode mismatch and value set to NULL. > [https://github.com/apache/hive/blob/master/jdbc-handler/src/main/java/org/apache/hive/storage/jdbc/JdbcSerDe.java#L158] > > jdbc Iterator has right hive column names (col1,col2), the MapWritable has > Text(col0) as key > [https://github.com/apache/hive/blob/dcfa17cea2198bcaa483e3d92f62db9c642f14f6/jdbc-handler/src/main/java/org/apache/hive/storage/jdbc/dao/JdbcRecordIterator.java#L63] > > while the JdbcSerDe org.apache.hive.storage.jdbc.JdbcSerDe#hiveColumnNames > has incorrect mapping , the columnKey created at > org/apache/hive/storage/jdbc/JdbcSerDe.java:157 is Text(id) where id is > column name for mysql not hive, opened another Jira HIVE-22353 for this > invalid reference issue. > -- This message was sent by Atlassian Jira (v8.3.4#803005)