# Dremio not returning records from a parquet file

**URL:** <https://community.dremio.com/t/dremio-not-returning-records-from-a-parquet-file/11011>\
**Category:** Uncategorized\
**Created:** [September 16, 2023, 1:05am UTC](https://community.dremio.com/t/dremio-not-returning-records-from-a-parquet-file/11011 "2023-09-16T01:05:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iskidet01](https://avatars.discourse-cdn.com/v4/letter/i/97f17d/32.png) [@iskidet01](https://community.dremio.com/u/iskidet01)\
**Post date:** [September 16, 2023, 1:05am UTC](https://community.dremio.com/t/dremio-not-returning-records-from-a-parquet-file/11011/1 "2023-09-16T01:05:21Z")

</div>

Hello Dremio,

My company uses a Dremio version 22.1.7, we have been reading parquets from our s3 bucket,

I loaded parquet files from a dataframe with this setings below.  
`df.to_parquet(path=file_path_name, index=False,compression='snappy')`

Dremio was able to read the parquet in the data settings as usual

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/31d323ed88eff1ca59078c48bbfdf62cb0055eac.png)

but when I created a PDS on the file , no records is been returned.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a735fa0a7ada809338444731bba38756a870c4ba.png)

---

<div class="post-metadata">

**Author:** ![isha](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/isha/32/2883_2.png) [@isha](https://community.dremio.com/u/isha)\
**Post date:** [September 18, 2023, 3:11pm UTC](https://community.dremio.com/t/dremio-not-returning-records-from-a-parquet-file/11011/2 "2023-09-18T15:11:45Z")

</div>

@iskidet01 Could you try clicking the Run button to see if a full run returns results?

---

<div class="post-metadata">

**Author:** ![iskidet01](https://avatars.discourse-cdn.com/v4/letter/i/97f17d/32.png) [@iskidet01](https://community.dremio.com/u/iskidet01)\
**Post date:** [September 18, 2023, 3:17pm UTC](https://community.dremio.com/t/dremio-not-returning-records-from-a-parquet-file/11011/3 "2023-09-18T15:17:38Z")

</div>

I haved resolved the issue ,I basically have to covert all schema to string using  
df=df.applymap(str) before rewrting to parquet, it appears dremio has issue dealing with variant datatype in parquet format