# \[DataTable\]3 of 15 shards failed

**URL:** https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164074
**Category:** Kibana
**Created:** [January 14, 2019, 2:45am UTC](https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164074 "2019-01-14T02:45:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![hyhong](https://avatars.discourse-cdn.com/v4/letter/h/3bc359/32.png) [@hyhong](https://discuss.elastic.co/u/hyhong)
#### Post date: [January 14, 2019, 2:45am UTC](https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164074/1 "2019-01-14T02:45:00Z")

</div>

version: 6.5.1  
When I use JSON input of DataTable,it throws an error: 3 of 15 shards failed,detail as follows:  
JSON input:  
{  
"script": {  
"source": "if(doc['currency.keyword'].value=='AAA'&&doc['country.keyword'].value=='BBB'){return doc.cost.value}"  
}  
}  
ERROR:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/6/66ba5b5ae7cfcbf79d6f3edb0f56e90a6d452254.png)

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 14, 2019, 3:10am UTC](https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164074/2 "2019-01-14T03:10:41Z")

</div>

Please don't post multiple topics on the same question, it makes it harder for people to assist you 🙂

Let's continue in this topic [[DataTable]3 of 15 shards failed](https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164068)

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 14, 2019, 3:10am UTC](https://discuss.elastic.co/t/datatable-3-of-15-shards-failed/164074/3 "2019-01-14T03:10:44Z")

</div>