Ask Your Question
0

Truncate the target impala table at the beginning of each run?

asked 2018-04-17 13:30:19 -0500

anonymous user

Anonymous

updated 2018-04-17 14:12:01 -0500

jeff gravatar image

How can I truncate an Impala table before ingesting data into it?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-04-17 14:39:01 -0500

AC gravatar image

thanks for reply. for start event ı added jdbc query and connected impala via jdbc connection string but when ı wrote "truncate Sample table" can not truncate on hdfs table error .

How can ı add jdbc executor ??

edit flag offensive delete link more
0

answered 2018-04-17 14:11:29 -0500

jeff gravatar image

Look into pipeline lifecycle events. You should be able to attach a JDBC executor (assuming you have the Impala JDBC driver available and installed), which can execute the truncate statement.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-17 13:30:19 -0500

Seen: 19 times

Last updated: Apr 17