# Is it possible to filter an array?

**URL:** <https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138>\
**Category:** Uncategorized\
**Created:** [January 5, 2023, 4:48pm UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138 "2023-01-05T16:48:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julienqw](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@Julienqw](https://community.dremio.com/u/Julienqw)\
**Post date:** [January 5, 2023, 4:48pm UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138/1 "2023-01-05T16:48:18Z")

</div>

Hi, i’m currently trying Dremio and i would like to make like a spark filter.  
Sorry if my question is stupid but i didn’t find what i’m searching in the doc.

I have a column containing :

```auto
[
  {"key1": "cats", "key2": "adopted", "name": xxx },
  {"key1": "dogs", "key2": "to adopted", "name": xxxx},
  ....
]

```

In spark sql i can do something like that :  
`filter(column, item -> item.key1== "cats")[0] as cat`

It will return the first map with key1 == cats, (i use it in the select part).

Is their a similar dremio function without using flatten ?

Thank you for your help 🙂

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 8, 2023, 5:24am UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138/2 "2023-01-08T05:24:28Z")

</div>

@Julienqw Is your source a Hive table?

---

<div class="post-metadata">

**Author:** ![Julienqw](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@Julienqw](https://community.dremio.com/u/Julienqw)\
**Post date:** [January 9, 2023, 7:47am UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138/3 "2023-01-09T07:47:27Z")

</div>

Hi @balaji.ramaswamy , no it’s a parquet file.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 9, 2023, 8:10pm UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138/4 "2023-01-09T20:10:28Z")

</div>

@Julienqw Here are the different things you can do with the MAP

> **[Introducing MAP Data Type in Dremio | Dremio](https://www.dremio.com/blog/introducing-map-data-type-in-dremio/)**
>
> Learn about querying MAP data in Dremio Cloud and Dremio Software v23.0.

---

<div class="post-metadata">

**Author:** ![Julienqw](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@Julienqw](https://community.dremio.com/u/Julienqw)\
**Post date:** [January 10, 2023, 7:41am UTC](https://community.dremio.com/t/is-it-possible-to-filter-an-array/10138/5 "2023-01-10T07:41:16Z")

</div>

Ok thank you, so it’s not possible to do it in only one function.  
We have to flatten our array and then filter it.