Ask Your Question

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

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

anonymous user


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

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

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

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

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

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


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

Seen: 420 times

Last updated: Apr 17 '18