https://lakefs.io/ logo
Title
c

chet justice

04/29/2023, 2:33 PM
Hi all, running through the tutorial here. Running the step using the
LAKEFS_OBJECT
reference, aka What about the data in
main
?
SELECT   country, COUNT(*)
FROM     READ_PARQUET(LAKEFS_OBJECT('quickstart', 'main', 'lakes.parquet'))
GROUP BY country
ORDER BY COUNT(*) 
DESC LIMIT 5;
and get this:
Error: Catalog Error: Scalar Function with name lakefs_object does not exist!
Did you mean "json_object"?
LINE 1: ...ountry, COUNT(*) FROM     READ_PARQUET(LAKEFS_OBJECT('quickstart', 'main', 'la...
Found the reference to the object here and manually created the
p_encode
and
lakefs_object
macros. That resulted in this:
Error: IO Error: No files found that match the pattern "${document.location.protocol}//${document.location.host}/api/v1/repositories/quickstart/refs/main/objects?path=lakes.parquet"
I'm guessing there's another dependency missing. Anyway, I've been through the tutorial a couple of times now and the issue persists. Did I miss a step somewhere?
o

Oz Katz

04/29/2023, 2:37 PM
Hey @chet justice ! that macro is intended to run in a browser environment. as the quickstart guide demonstrates, it is not required if running in other duckdb environments - for those you can simply use the s3 compatibility provided by lakeFS
c

chet justice

04/29/2023, 2:47 PM
Ah...yes. I see it now. Was in duckDB and didn't notice the context switch. Thanks. Works. 🙂
o

Oz Katz

04/29/2023, 2:47 PM
Yay! happy to hear that 🙂