Try to create a external with JdbcHandler : hive version : Hive 3.1.0.3.0.1.0-187 Query : CREATE EXTERNAL TABLE HiveTable( id INT, nm STRING, test INT) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'TBLPROPERTIES ( "mapred.jdbc.driver.class"="com.mysql.jdbc.Driver", "mapred.jdbc.url"="jdbc:mysql://localhost:3306/test_jdbc", "mapred.jdbc.username"="root", "mapred.jdbc.input.table.name"="HiveTable", "mapred.jdbc.output.table.name"="HiveTable", "mapred.jdbc.password"="********", "mapred.jdbc.hive.lazy.split"= "false"); Return : >[Error] Script lines: 1-17 ------------------------- Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.NullPointerException  Any idea why ? ... View more