Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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 ?
1 ACCEPTED SOLUTION

avatar
New Contributor

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

View solution in original post

1 REPLY 1

avatar
New Contributor

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