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!
