[HIVE-19455] Create JDBC External Table NullPointerException

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.3, 3.0.0
• Component/s: JDBC
• Assignee: Unassigned
• Reporter: gonglinglei
• Created: 08/May/18 07:01
• Updated: 11/May/18 17:13

Description

JdbcSerDe.initialize use tbl.containsKey(JdbcStorageConfig.DATABASE_TYPE.getPropertyName()) to decide whether properties is empty and whether to initialize serde. But when creating a external table
without hive.sql.database.type provided, it will throw a NullPointerException.

2018-05-08T11:21:03,745 ERROR [88c8bc6c-cd5b-4b74-b6d6-242e3cc12165 main] metadata.Table: Unable to get field from serde: org.apache.hive.storage.jdbc.JdbcSerDe
java.lang.NullPointerException
at org.apache.hadoop.hive.metastore.MetaStoreUtils.getFieldsFromDeserializer(MetaStoreUtils.java:1426) ~[hive-exec-2.3.3.jar:2.3.3]
at org.apache.hadoop.hive.ql.metadata.Table.getColsInternal(Table.java:641) ~[hive-exec-2.3.3.jar:2.3.3]