Advertisement
vishneva_olga

err

Apr 6th, 2025
285
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.13 KB | None | 0 0
  1. (Background on this error at: https://sqlalche.me/e/14/f405)
  2. [2025-04-06T17:10:40.322+0000] {taskinstance.py:1400} INFO - Marking task as FAILED. dag_id=alt_churn, task_id=create_table, execution_date=20250406T171036, start_date=20250406T171040, end_date=20250406T171040
  3. [2025-04-06T17:10:40.340+0000] {standard_task_runner.py:104} ERROR - Failed to execute job 53 for task create_table ((psycopg2.errors.DuplicateTable) relation "uq_customer_id" already exists
  4.  
  5. [SQL:
  6. CREATE TABLE alt_users_churn (
  7.     id SERIAL NOT NULL,
  8.     customer_id VARCHAR,
  9.     begin_date TIMESTAMP WITHOUT TIME ZONE,
  10.     end_date TIMESTAMP WITHOUT TIME ZONE,
  11.     type VARCHAR,
  12.     paperless_billing VARCHAR,
  13.     payment_method VARCHAR,
  14.     monthly_charges FLOAT,
  15.     total_charges FLOAT,
  16.     internet_service VARCHAR,
  17.     online_security VARCHAR,
  18.     online_backup VARCHAR,
  19.     device_protection VARCHAR,
  20.     tech_support VARCHAR,
  21.     streaming_tv VARCHAR,
  22.     streaming_movies VARCHAR,
  23.     gender VARCHAR,
  24.     senior_citizen INTEGER,
  25.     partner VARCHAR,
  26.     dependents VARCHAR,
  27.     multiple_lines VARCHAR,
  28.     target INTEGER,
  29.     PRIMARY KEY (id),
  30.     CONSTRAINT uq_customer_id UNIQUE (customer_id)
  31. )
  32.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement