search

pdet / Scrooge-McDuck

MIT License
129 stars 13 forks source link

Binder Error: table "yahoo_finance" has duplicate column name "star" #35

Open Thorsten-Yurika opened 3 months ago

Thorsten-Yurika commented 3 months ago

Hello,

I am testing out the new extensions and have noticed that i cannot use the yahoo_finance tables in DBBeaver (Version 24.1.2.202407071610) and idea what I am doing wrong?

INSTALL scrooge FROM community;
LOAD scrooge;

FROM yahoo_finance("^GSPC", "2023-02-01", "2023-02-04", "1d");

SQL Error: java.sql.SQLException: Binder Error: table "yahoo_finance" has duplicate column name "star"

pdet commented 3 months ago

Hi Thorsten, thanks for opening the issue, I've fixed this some time back, but have not yet released it on the main DuckDB Distributions

Could you try with 

SET custom_extension_repository='https://scrooge-duck.s3.us-west-2.amazonaws.com';
SET allow_extensions_metadata_mismatch=true;
Thorsten-Yurika commented 3 months ago

I must be doing something wrong:

SET custom_extension_repository='https://scrooge-duck.s3.us-west-2.amazonaws.com'; SET allow_extensions_metadata_mismatch=true;

INSTALL scrooge; LOAD scrooge;

FROM yahoo_finance("^GSPC", "2023-02-01", "2023-02-04", "1d");