# Hive to ES incremental upload
**URL:** https://discuss.elastic.co/t/hive-to-es-incremental-upload/99516
**Category:** Elasticsearch
**Created:** [September 6, 2017, 5:28am UTC](https://discuss.elastic.co/t/hive-to-es-incremental-upload/99516 "2017-09-06T05:28:36Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Ashwini\_Kumar](https://discuss.elastic.co/u/Ashwini_Kumar)
#### Post date: [September 6, 2017, 5:28am UTC](https://discuss.elastic.co/t/hive-to-es-incremental-upload/99516/1 "2017-09-06T05:28:36Z")
I have 20000 documents in ES and I have uploaded them from Hive using Hive -ES connector. How can I dump new data from hive to ES? I want to do an incremental upload how sqoop does.
---
### Author:  [@james.baiera](https://discuss.elastic.co/u/james.baiera)
#### Post date: [September 12, 2017, 2:57pm UTC](https://discuss.elastic.co/t/hive-to-es-incremental-upload/99516/2 "2017-09-12T14:57:01Z")
@Ashwini_Kumar I'm not aware of anything that does this out of the box for Hive, so it might require a little bit of footwork to do. Does your new data have any way to differentiate it from old data such as a create timestamp or transaction ids? If so, you could attempt to query just for the new data since your last load into ES when running the load command.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 10, 2017, 2:57pm UTC](https://discuss.elastic.co/t/hive-to-es-incremental-upload/99516/3 "2017-10-10T14:57:14Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.