:lady_beetle: Daily RUN failed

adriens / neo4j-ninjas

A set of resources around Neo4J ninjas program

https://www.kaggle.com/datasets/adriensales/neo4j-ninjas-duckdb-dataset

1 stars 0 forks source link

:lady_beetle: Daily RUN failed #18

Closed adriens closed 1 year ago

adriens commented 1 year ago

Investigations WIP

adriens commented 1 year ago

[ConstraintException: Constraint Error: NOT NULL constraint failed:
countries.region](https://raw.githubusercontent.com/lukes/ISO-3166-Countries-with-Regional-Codes/master/all/all.csv%3C/span%3E%3Cspan)

adriens commented 1 year ago

Removing NOT NULL constraint...

adriens commented 1 year ago

now this

con.execute("""create or replace table countries (
    name VARCHAR not null,
    alpha_2 VARCHAR not null,
    alpha_3 VARCHAR not null primary key,
    country_code VARCHAR not null,
    iso_3166_2 VARCHAR not null,
    region VARCHAR,-- not null,
    sub_region VARCHAR,-- not null,

adriens commented 1 year ago

 "display_name: Isaac Ruiz Guerra" does not exist in the referenced table

adriens commented 1 year ago

ConstraintException: Constraint Error: NOT NULL constraint failed: ninjas.guessed_country

adriens commented 1 year ago

COnstraintes removed : running a full ntebook backup :rocket:

:point_right: I'll fix NULL countries shortly