Overwriting Hive Partition with In-DB Write

[gkresge]

I am trying to figure out how to have the equivalent of `insert overwrite table...` using the In-DB Write tool.

Alternatively, a way to drop a partition prior to the load would work. I know the standard Output Data tool has a options for pre/post create SQL statements, but I am not seeing anything similar in the In-DB tool. 

I would prefer to continue using the In-DB tool, since I am using the HDFS (Avro) driver to stream the data back onto the cluster prior to writing to my partitioned table due to speed considerations. 

Is this a job for a macro? or is there some way using existing tools. 

Thanks!