# Unable to parse condition: col("guid").isNull()

**URL:** <https://discourse.greatexpectations.io/t/unable-to-parse-condition-col-guid-isnull/1956>\
**Category:** GX Core Support\
**Tags:** help-wanted\
**Created:** [October 18, 2024, 5:54pm UTC](https://discourse.greatexpectations.io/t/unable-to-parse-condition-col-guid-isnull/1956 "2024-10-18T17:54:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lauraz](https://avatars.discourse-cdn.com/v4/letter/l/e47774/32.png) [@lauraz](https://discourse.greatexpectations.io/u/lauraz)\
**Post date:** [October 18, 2024, 5:54pm UTC](https://discourse.greatexpectations.io/t/unable-to-parse-condition-col-guid-isnull/1956/1 "2024-10-18T17:54:05Z")

</div>

I’m running GX in a Spark notebook in Databricks. The data source is a Dataframe read from a Delta table. The code for adding conditional expectation is like below:  
“”"

### Conditional Contract

ml\_suite.add\_expectation(  
gx.expectations.ExpectColumnValuesToBeNull(column=‘zuid’,  
condition\_parser=‘great\_expectations\_\_experimental\_\_’,  
row\_condition=‘col(“guid”).isNull()’)  
)  
“”"

However, i ran into error like  
“”"  
raise gx\_exceptions.MetricResolutionError(\ngreat\_expectations.exceptions.exceptions.MetricResolutionError: unable to parse condition: col("guid").isNull()\n",  
“exception\_message”: “unable to parse condition: col("guid").isNull()”,  
“”"

How should I get rid of this?

---

<div class="post-metadata">

**Author:** ![adeola](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@adeola](https://discourse.greatexpectations.io/u/adeola)\
**Post date:** [October 23, 2024, 2:48pm UTC](https://discourse.greatexpectations.io/t/unable-to-parse-condition-col-guid-isnull/1956/2 "2024-10-23T14:48:23Z")

</div>

can you try changing the parser to “spark” and then updating the row condition to use standard SQL syntax:

here’s a snippet from a working example that i have with a spark/databricks:

```auto
from datetime import datetime
import great_expectations as gx

cond_expectation = gx.expectations.ExpectColumnValuesToBeInSet(
    column="tpep_dropoff_datetime",
    value_set=[
        datetime(2016, 1, 1, 0, 12),
        datetime(2016, 1, 1, 0, 13),
    ],
    condition_parser="spark",
    row_condition='`pickup_zip` = 10001'  
)

batch.validate(cond_expectation)

```

pickup\_zip is my column name that i have wrapped in backticks

---

<div class="post-metadata">

**Author:** ![lauraz](https://avatars.discourse-cdn.com/v4/letter/l/e47774/32.png) [@lauraz](https://discourse.greatexpectations.io/u/lauraz)\
**Post date:** [November 10, 2024, 6:44am UTC](https://discourse.greatexpectations.io/t/unable-to-parse-condition-col-guid-isnull/1956/3 "2024-11-10T06:44:09Z")

</div>

Yes that works! Thanks!