You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zhihua Deng (Jira)" <ji...@apache.org> on 2023/07/09 13:51:00 UTC
[jira] [Commented] (HIVE-27487) NPE in Hive JDBC storage handler
[ https://issues.apache.org/jira/browse/HIVE-27487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741390#comment-17741390 ]
Zhihua Deng commented on HIVE-27487:
------------------------------------
Create statement for sample_nightly:
{noformat}
CREATE EXTERNAL TABLE sample_nightly(Code string,Description string,total_emp int,Salary int) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES("hive.sql.database.type"="HIVE","hive.sql.jdbc.driver"="org.apache.hive.jdbc.HiveDriver","hive.sql.jdbc.url"="jdbc:hive2://hiveserver2:10000/default","hive.sql.dbcp.username"="user","hive.sql.dbcp.password"="password","hive.sql.table"="sample_nightly","hive.sql.dbcp.maxActive"="1");{noformat}
> NPE in Hive JDBC storage handler
> --------------------------------
>
> Key: HIVE-27487
> URL: https://issues.apache.org/jira/browse/HIVE-27487
> Project: Hive
> Issue Type: Bug
> Components: JDBC storage handler
> Reporter: Zhihua Deng
> Assignee: Zhihua Deng
> Priority: Major
>
> A simple query against a Hive JDBC table: "select * from sample_nightly" would fail due to:
> {noformat}
> Caused by: java.lang.NullPointerException
> at org.apache.hive.storage.jdbc.JdbcSerDe.deserialize(JdbcSerDe.java:168)
> at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:623)
> ... 21 more{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)