JdbcHandler return org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.NullPointerException

[#1]

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 ?

[#2 · Accepted solution]

Finally found who. With the new version we should do like this : https://cwiki.apache.org/confluence/display/Hive/JdbcStorageHandler