[jira] [Created] (HIVE-25813) CREATE TABLE x LIKE storagehandler-based-source fails

[Sai Hemanth Gantasala (Jira)]

Sai Hemanth Gantasala created HIVE-25813:
--------------------------------------------

             Summary: CREATE TABLE x LIKE storagehandler-based-source fails 
                 Key: HIVE-25813
                 URL: https://issues.apache.org/jira/browse/HIVE-25813
             Project: Hive
          Issue Type: Bug
            Reporter: Sai Hemanth Gantasala
            Assignee: Sai Hemanth Gantasala


{code:java}
CREATE EXTERNAL TABLE default.dbs (
  DB_ID            bigint,
  DB_LOCATION_URI  string,
  NAME             string,
  OWNER_NAME       string,
  OWNER_TYPE       string )
STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
TBLPROPERTIES (
  'hive.sql.database.type' = 'MYSQL',
  'hive.sql.jdbc.driver'   = 'com.mysql.jdbc.Driver',
  'hive.sql.jdbc.url'      = 'jdbc:mysql://localhost:3306/hive1',
  'hive.sql.dbcp.username' = 'hive1',
  'hive.sql.dbcp.password' = 'cloudera',
  'hive.sql.query' = 'SELECT DB_ID, DB_LOCATION_URI, NAME, OWNER_NAME, 
OWNER_TYPE FROM DBS'
);

CREATE TABLE default.dbscopy LIKE default.dbs;

Caused by: java.lang.NullPointerException
        at 
org.apache.hadoop.hive.metastore.HiveMetaStoreUtils.getFieldsFromDeserializer(HiveMetaStoreUtils.java:186)
 {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)