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

NOAA Integrated Surface Database example not working #42

Open
ManshaP opened this issue Feb 7, 2024 · 0 comments
Open

NOAA Integrated Surface Database example not working #42

ManshaP opened this issue Feb 7, 2024 · 0 comments

Comments

@ManshaP
Copy link

ManshaP commented Feb 7, 2024

the notebook under examples/noaa-isd/notebooks is not working for me:

When running the notebook up to
df = pd.read_sql("SELECT obs_date, obs_time, air_temp, air_dewpoint_temp FROM noaaisd.isd where station_call = 'KOKC ' and air_temp_quality = '5' and air_dewpoint_temp_quality = '5' and year between 2010 and 2018;", conn) df

I get:

OperationalError                          Traceback (most recent call last)
File [~/miniconda3/envs/pe/lib/python3.12/site-packages/pandas/io/sql.py:2675](http://localhost:8888/lab/tree/~/miniconda3/envs/pe/lib/python3.12/site-packages/pandas/io/sql.py#line=2674), in SQLiteDatabase.execute(self, sql, params)
   2674 try:
-> 2675     cur.execute(sql, *args)
   2676     return cur

File [~/miniconda3/envs/pe/lib/python3.12/site-packages/pyathena/cursor.py:108](http://localhost:8888/lab/tree/~/miniconda3/envs/pe/lib/python3.12/site-packages/pyathena/cursor.py#line=107), in Cursor.execute(self, operation, parameters, work_group, s3_staging_dir, cache_size, cache_expiration_time, result_reuse_enable, result_reuse_minutes, **kwargs)
    107 else:
--> 108     raise OperationalError(query_execution.state_change_reason)
    109 return self

OperationalError: SCHEMA_NOT_FOUND: line 1:61: Schema 'noaaisd' does not exist

Is this a bug? Thank you! @zflamig

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

No branches or pull requests

1 participant