How can i use duckdb from commandline?
I got the windows duckdb and installed it from https://duckdb.org/docs/installation/index?version=stable&environment=cli&platform=win&download_method=package_manager
Base 16 hexadecimal string to base 10 integer
I’m trying to convert a hash into an integer. The conversion works as expected in python and t-sql (with the same answer). I’m trying to replicate it in duckdb but can’t quite.
Use a calculated list in list_transform
I wonder how to use data in list_transform
Partitioned data – pushed down filter
I have data in ADLS which is partitioned as shown in image [Partitioned Data structure]
Partitioned Data structure
How to select dynamic attributes from JSON with DuckDB?
I use ansible to select internal details of my hosts and get a large JSON list of the results. I want to see the networking details of every interface on every host in a nice table.
Need to read old xls file instead with xlsx with st_read()
I need to read some old xls file instead with xlsx with st_read() that is part of the spatial extension.
Why doesn’t DuckDB return data?
Considering this very simple function:
Why doesn’t DuckDB return data?
Considering this very simple function:
DuckDB: parquet predicate pushdown with more than one clause?
I have a parquet file of tickdata ordered (and row-chunked) by instrument-symbol. The parquet file metadata contains min/max metadata. I’ve found that if my query asks for a single symbol in the where clause then duckdb performs predicate pushdown on the parquet file, but with more than one symbol it doesn’t.