This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/sedona-spatialbench.git
The following commit(s) were added to refs/heads/main by this push:
new b61071e Fix empty host issues for Zone table generation (#16)
b61071e is described below
commit b61071e43992fe353d64624b7b4b411c92d37851
Author: Pranav Toggi <[email protected]>
AuthorDate: Thu Sep 18 23:07:49 2025 -0700
Fix empty host issues for Zone table generation (#16)
* set empty creds for anonymous access to public s3
* fix fmt
---
spatialbench/src/generators.rs | 21 +++++++++++++++++----
1 file changed, 17 insertions(+), 4 deletions(-)
diff --git a/spatialbench/src/generators.rs b/spatialbench/src/generators.rs
index 94b771b..109c0ce 100644
--- a/spatialbench/src/generators.rs
+++ b/spatialbench/src/generators.rs
@@ -1590,10 +1590,23 @@ impl ZoneGenerator {
// Install and load required extensions
let t1 = Instant::now();
- conn.execute("INSTALL httpfs;", [])?;
- conn.execute("LOAD httpfs;", [])?;
- conn.execute("INSTALL spatial;", [])?;
- conn.execute("LOAD spatial;", [])?;
+ conn.execute_batch(
+ r#"
+ INSTALL httpfs;
+ LOAD httpfs;
+ INSTALL spatial;
+ LOAD spatial;
+
+ -- Public bucket: force unsigned requests
+ SET s3_access_key_id = '';
+ SET s3_secret_access_key = '';
+ SET s3_session_token = '';
+
+ -- Region + endpoint for the Overture bucket
+ SET s3_region = 'us-west-2';
+ SET s3_endpoint = 's3.us-west-2.amazonaws.com';
+ "#,
+ )?;
debug!(
"Installed and loaded DuckDB extensions in {:?}",
t1.elapsed()
