Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After exception, future changes to the SQL doesn't update the exploration table #886

Open
ahuang11 opened this issue Dec 20, 2024 · 0 comments · May be fixed by #887
Open

After exception, future changes to the SQL doesn't update the exploration table #886

ahuang11 opened this issue Dec 20, 2024 · 0 comments · May be fixed by #887

Comments

@ahuang11
Copy link
Contributor

Traceback (most recent call last):
  File "/Users/ahuang/repos/lumen/lumen/ai/views.py", line 257, in render
    pipeline.source = pipeline.source.create_sql_expr_source(
    ^^^^^^^^^^^^^^^
  File "/Users/ahuang/miniconda3/envs/lumen/lib/python3.12/site-packages/param/parameterized.py", line 528, in _f
    instance_param.__set__(obj, val)
  File "/Users/ahuang/miniconda3/envs/lumen/lib/python3.12/site-packages/param/parameterized.py", line 530, in _f
    return f(self, obj, val)
           ^^^^^^^^^^^^^^^^^
  File "/Users/ahuang/miniconda3/envs/lumen/lib/python3.12/site-packages/param/parameterized.py", line 1553, in __set__
    obj.param._call_watcher(watcher, event)
  File "/Users/ahuang/miniconda3/envs/lumen/lib/python3.12/site-packages/param/parameterized.py", line 2526, in _call_watcher
    self_._execute_watcher(watcher, (event,))
  File "/Users/ahuang/miniconda3/envs/lumen/lib/python3.12/site-packages/param/parameterized.py", line 2506, in _execute_watcher
    watcher.fn(*args, **kwargs)
  File "/Users/ahuang/repos/lumen/lumen/pipeline.py", line 192, in _sync_source
    self._update_data()
  File "/Users/ahuang/repos/lumen/lumen/util.py", line 321, in wrapper
    raise e
  File "/Users/ahuang/repos/lumen/lumen/util.py", line 308, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahuang/repos/lumen/lumen/pipeline.py", line 322, in _update_data
    new_data = self._compute_data()
               ^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahuang/repos/lumen/lumen/pipeline.py", line 268, in _compute_data
    data = self.source.get(self.table, **query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahuang/repos/lumen/lumen/sources/base.py", line 87, in wrapped
    df = method(self, table, **cache_query)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahuang/repos/lumen/lumen/sources/duckdb.py", line 268, in get
    rel = self._connection.execute(sql_expr)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
duckdb.duckdb.BinderException: Binder Error: Values list "t" does not have a column named "yearly_passenger_totals"
LINE 20:     t.yearly_passenger_totals
Image
@ahuang11 ahuang11 linked a pull request Dec 20, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant