# Dask-sql NotImplementedError

**URL:** https://dask.discourse.group/t/dask-sql-notimplementederror/2645
**Category:** Uncategorized
**Created:** [March 26, 2024, 4:03pm UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645 "2024-03-26T16:03:16Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![bnamantis](https://avatars.discourse-cdn.com/v4/letter/b/f08c70/32.png) [@bnamantis](https://dask.discourse.group/u/bnamantis)
#### Post date: [March 26, 2024, 4:03pm UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/1 "2024-03-26T16:03:16Z")

</div>

I am trying out dask-sql but keeping getting error saying string[pyarrow] NotImplementedError: the python type string is not implemented (yet), idea?

---

<div class="post-metadata">

### Author: ![guillaumeeb](https://yyz1.discourse-cdn.com/flex035/user_avatar/dask.discourse.group/guillaumeeb/32/1613_2.png) [@guillaumeeb](https://dask.discourse.group/u/guillaumeeb)
#### Post date: [March 27, 2024, 10:03am UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/2 "2024-03-27T10:03:09Z")

</div>

Hi @bnamantis,

Maybe you could try to disable the use PyArrow String:

```auto
import dask 
dask.config.set({"dataframe.convert-string": False})

```

---

<div class="post-metadata">

### Author: ![bnamantis](https://avatars.discourse-cdn.com/v4/letter/b/f08c70/32.png) [@bnamantis](https://dask.discourse.group/u/bnamantis)
#### Post date: [March 27, 2024, 11:47am UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/3 "2024-03-27T11:47:08Z")

</div>

![1000006259](https://canada1.discourse-cdn.com/flex035/uploads/dask/original/2X/b/b928555b7c461d59e6f654202ce0766755f4513c.jpeg)

---

<div class="post-metadata">

### Author: ![bnamantis](https://avatars.discourse-cdn.com/v4/letter/b/f08c70/32.png) [@bnamantis](https://dask.discourse.group/u/bnamantis)
#### Post date: [March 27, 2024, 11:48am UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/4 "2024-03-27T11:48:48Z")

</div>

Hope you can see screenshot, same error, no change, I am running same example in the documentation, not sure if there is any versioning issue, are you able to run it without error?

---

<div class="post-metadata">

### Author: ![guillaumeeb](https://yyz1.discourse-cdn.com/flex035/user_avatar/dask.discourse.group/guillaumeeb/32/1613_2.png) [@guillaumeeb](https://dask.discourse.group/u/guillaumeeb)
#### Post date: [March 27, 2024, 5:59pm UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/5 "2024-03-27T17:59:40Z")

</div>

Could you also provide the environment you are using, especially Pandas and Dask versions?

---

<div class="post-metadata">

### Author: ![guillaumeeb](https://yyz1.discourse-cdn.com/flex035/user_avatar/dask.discourse.group/guillaumeeb/32/1613_2.png) [@guillaumeeb](https://dask.discourse.group/u/guillaumeeb)
#### Post date: [March 27, 2024, 6:55pm UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/6 "2024-03-27T18:55:42Z")

</div>

So I was able to reproduce you issue with Dask and dask-sql latest version.

But adding

```auto
import dask 
dask.config.set({"dataframe.convert-string": False})

```

Before any other thing in my code solved it.

An issue is already opened here: [[QST] NotImplementedError: The python type string is not implemented (yet) · Issue #1225 · dask-contrib/dask-sql · GitHub](https://github.com/dask-contrib/dask-sql/issues/1225).

---

<div class="post-metadata">

### Author: ![bnamantis](https://avatars.discourse-cdn.com/v4/letter/b/f08c70/32.png) [@bnamantis](https://dask.discourse.group/u/bnamantis)
#### Post date: [March 28, 2024, 10:20pm UTC](https://dask.discourse.group/t/dask-sql-notimplementederror/2645/7 "2024-03-28T22:20:35Z")

</div>

This worked! Thank you so much!
