https://community.cloudera.com/t5/Archives-of-Support-Questions/JdbcHandler-return-org-apache-hadoop-hive-ql-exec-DDLTask/m-p/235099#M84662 <P>Try to create a external with JdbcHandler : </P><P>hive version : Hive 3.1.0.3.0.1.0-187</P><P>Query : </P><PRE><BR />CREATE EXTERNAL TABLE HiveTable(<BR />id INT,<BR />nm STRING,<BR />test INT)<BR />STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'TBLPROPERTIES (<BR /> "mapred.jdbc.driver.class"="com.mysql.jdbc.Driver",<BR /> "mapred.jdbc.url"="jdbc:mysql://localhost:3306/test_jdbc",<BR /> "mapred.jdbc.username"="root",<BR /> "mapred.jdbc.input.table.name"="HiveTable",<BR /> "mapred.jdbc.output.table.name"="HiveTable",<BR /> "mapred.jdbc.password"="********",<BR /> "mapred.jdbc.hive.lazy.split"= "false");</PRE><PRE>Return : &gt;[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 &#3; Any idea why ?</PRE> Thu, 01 Nov 2018 05:41:18 GMT philippe_poulio 2018-11-01T05:41:18Z https://community.cloudera.com/t5/Archives-of-Support-Questions/JdbcHandler-return-org-apache-hadoop-hive-ql-exec-DDLTask/m-p/235099#M84662 <P>Try to create a external with JdbcHandler : </P><P>hive version : Hive 3.1.0.3.0.1.0-187</P><P>Query : </P><PRE><BR />CREATE EXTERNAL TABLE HiveTable(<BR />id INT,<BR />nm STRING,<BR />test INT)<BR />STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'TBLPROPERTIES (<BR /> "mapred.jdbc.driver.class"="com.mysql.jdbc.Driver",<BR /> "mapred.jdbc.url"="jdbc:mysql://localhost:3306/test_jdbc",<BR /> "mapred.jdbc.username"="root",<BR /> "mapred.jdbc.input.table.name"="HiveTable",<BR /> "mapred.jdbc.output.table.name"="HiveTable",<BR /> "mapred.jdbc.password"="********",<BR /> "mapred.jdbc.hive.lazy.split"= "false");</PRE><PRE>Return : &gt;[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 &#3; Any idea why ?</PRE> Thu, 01 Nov 2018 05:41:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/JdbcHandler-return-org-apache-hadoop-hive-ql-exec-DDLTask/m-p/235099#M84662 philippe_poulio 2018-11-01T05:41:18Z https://community.cloudera.com/t5/Archives-of-Support-Questions/JdbcHandler-return-org-apache-hadoop-hive-ql-exec-DDLTask/m-p/235100#M84663 <P>Finally found who. With the new version we should do like this : <A href="https://cwiki.apache.org/confluence/display/Hive/JdbcStorageHandler" target="_blank">https://cwiki.apache.org/confluence/display/Hive/JdbcStorageHandler</A></P> Tue, 06 Nov 2018 21:15:05 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/JdbcHandler-return-org-apache-hadoop-hive-ql-exec-DDLTask/m-p/235100#M84663 philippe_poulio 2018-11-06T21:15:05Z