[
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)
