# Is there any way to skip row inserting in ES while moving data from HIVE to ES?

**URL:** <https://discuss.elastic.co/t/is-there-any-way-to-skip-row-inserting-in-es-while-moving-data-from-hive-to-es/53648>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [June 22, 2016, 10:43am UTC](https://discuss.elastic.co/t/is-there-any-way-to-skip-row-inserting-in-es-while-moving-data-from-hive-to-es/53648 "2016-06-22T10:43:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![r.gupta2508](https://avatars.discourse-cdn.com/v4/letter/r/e480ec/32.png) [@r.gupta2508](https://discuss.elastic.co/u/r.gupta2508)\
**Post date:** [June 22, 2016, 10:43am UTC](https://discuss.elastic.co/t/is-there-any-way-to-skip-row-inserting-in-es-while-moving-data-from-hive-to-es/53648/1 "2016-06-22T10:43:34Z")

</div>

i am trying to copy data (more then 300 million rows) from hive table to Elasticsearch using this query:- insert overwrite table TableNameES select \* from HiveTableName;

& after inserting some of rows i am getting this exception. i know this is because of different data type of mapping in ES ...

Caused by: org.elasticsearch.hadoop.rest.EsHadoopInvalidRequest: Found unrecoverable error [xx.xx.xx.xx:9200] returned Bad Request(400) - [MapperParsingException[failed to parse [pctblack.pctblack\_raw]]; nested: NumberFormatException[For input string: "(S)"]; ]; Bailing out..\*\*

i want to skip inserting those row which one giving error not only this exception may be other exception.

---

<div class="post-metadata">

**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\
**Post date:** [June 27, 2016, 6:40pm UTC](https://discuss.elastic.co/t/is-there-any-way-to-skip-row-inserting-in-es-while-moving-data-from-hive-to-es/53648/2 "2016-06-27T18:40:35Z")

</div>

Hello!

I would advise filtering or transforming any troublesome data with the tools provided from Hive before the final insert into your Elasticsearch index. The `insert ... table` syntax supports a given `select` statement that should allow you to fix up or filter out any data that shouldn't be coming along for the ride.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:24pm UTC](https://discuss.elastic.co/t/is-there-any-way-to-skip-row-inserting-in-es-while-moving-data-from-hive-to-es/53648/3 "2017-07-06T13:24:10Z")

</div>