What processor are you using to put the data into Hive? Right now it looks like you have Avro in the flow file content (the columns coming out of the Oracle DB via QueryDatabaseTable) and your batch_ts value as a attribute (aka metadata) on the flow file. You'll need to be able to inject the batch_ts value into your record(s).
I don't believe your version of NiFi has UpdateRecord, but if it does, you can use that to add a "batch_ts" field to each of the Avro records in the flow file. If you don't have UpdateRecord, you can convert the Avro to JSON and use JoltTransformJSON to put the "batch_ts" field into each record.