Stack Overflow
Stack Overflow

Questions tagged [duckdb]

Issues related to the usage of DuckDB (www.duckdb.org)

180 questions
0
votes
1 answer

DuckDB won't compile on free AWS EC2 instance. Are precompiled packages the solution?

I'm trying to set up a shiny server on the free tier AWS EC2 to test my app but I can't get all the packages compiled and installed. e.g. duckdb in the terminal connected to my instance I paste: sudo su - -c "R -e \"install.packages(c('duckdb'),…
HCAI
  • 2,213
  • 8
  • 33
  • 65
0
votes
0 answers

R: How to shut down database in flexdashboard?

I have a flexdashboard which queries from a local DuckDB (similar to SQLite) but every so often it says: Warning: Error in initialize: duckdb_startup_R: Failed to open database There is no "onStop dbdisconnect" style command in my code (I'm not…
HCAI
  • 2,213
  • 8
  • 33
  • 65
0
votes
1 answer

How to create multi-column indices DuckDB/SQLite?

I have a DuckDB with columns of data which I would like to query using multiple columns. I'm in R but I'm not sure how to create a multicolumn index (or even a single column index). Can anyone suggest a reference please? I've added SQLite as a tag…
HCAI
  • 2,213
  • 8
  • 33
  • 65
0
votes
1 answer

CSV reader behavior

I like this feature : CREATE VIEW ontime AS SELECT * FROM read_csv_auto('test.csv'); but noticed it does not properly identify type of columns loading big csv files and fails reading rows that do not fit into identified column type. What is default…
Alex O
  • 1
  • 1
0
votes
3 answers

Error compiling a c++ database on windows with cmake

For my Masters degree I need to work on a database called duckdb (its on git hub). Normally on Linux you can simply clone it and "make" it to install. I tired the same on windows after installing CMake and Cygwin. But halfway through compiling I…
Student01
  • 93
  • 7
-1
votes
1 answer

Quote should be followed end of value, end of row or another quote?

I'm trying to read a 20M records tsv in R, but keep getting errors because aparently the file was not generated correctly. However, the data is always uploaded to Adobe's servers, for a product we use. It gives warning about values not been…
Omar Gonzales
  • 3,806
  • 10
  • 56
  • 120
-1
votes
1 answer

How to extract VARCHAR from DuckDB by C API?

I am developing with Duckdb C API. As recommended, I use data chunk and vector to extract value from the database. In duckdb, string is stored as VARCHAR. But I can't extract it and turn to string. Infomations duckdb version: 0.8.1 with C API When I…
yiyang
  • 3
  • 1
-1
votes
0 answers

DuckDB C++ not selecting any data

I try to run the C++ code, which is more-less taken from the DuckDB documentation, but I can't make it work. Compilation is fine, but the output from Print() function is an error message: Parser Error: syntax error at or near "..." The "..."…
query
  • 329
  • 7
  • 18
-1
votes
1 answer

how to stream events with duckdb node js client?

I wonder if such thing works? Trying to subscribe to new additions to a table and send them to my browser client.
n79qk272x57w46w9
  • 51
  • 5
-1
votes
2 answers

convert string yyyymmdd to date in duck db

Hi does anyone know how to convert a string in YYYYMMDD format to yyyy-mm-dd in duck db? have tried to cast, have tried strptime(date, 'yyyymmdd'), have tried convert, to_date
Pistachio_Kulfi
  • 21
  • 4
-1
votes
1 answer

Remove newline characters in my data with Duckdb

I've received a csv file with some issues, I've noticed a few issues when attempting to load into BigQuery. I'm using duckdb to quickly sanitise the data, and I'm noticing a bunch of newline characters in my data. Is there a quick way to remove…
Tom K
  • 145
  • 1
  • 13
-1
votes
1 answer

how to add DuckDB library in c++ program?

I downloaded the file https://github.com/duckdb/duckdb/releases/download/v0.3.2/libduckdb-linux-amd64.zip, but I do not know how to use it in C++. This file contains the following files: duckdb.h duckdb.hpp libduckdb.so What should I do after…
user18736718
  • 1
-1
votes
2 answers

Trying to manually creating unique_ptr class instances with virtual parts

As a Master Thesis I need to expand the database duckdb on github with functionality. One of the first steps was to create a fixed internal plan that represents something like "select 42;" just on physical level. To that end I tired to manually…
Student01
  • 93
  • 7
-3
votes
1 answer

How to test if names are nicknames of each other?

I'm an experienced SWE, just new to SQL and would love a walkthrough on how to solve this particular problem. I have an input table of name pairs. I need to determine if each pair of names are nicknames of each other or…
Nick Crews
  • 837
  • 10
  • 13
-5
votes
1 answer

How to count the number of instances of a substring in sqlite or duckdb across all rows?

I have a simple table. It's format is: Column 1: Integer Column 2: String which consists of a bunch of words separated by spaces An example of column 2 might be: "foo bar bax bux qux" Given 2 rows: (1, "foo bar baz bux qux") (2, "foo baz bux qux…
Foobar
  • 7,458
  • 16
  • 81
  • 161
1 2 3
…
11
12