MonetDB is an open-source implementation of a column-oriented database. It is focused on analytical applications on a main memory resident database. MonetDB is a relational database and provides an SQL top-level interface. It is actively developed at CWI in Amsterdam, The Netherlands.
Questions tagged [monetdb]
441 questions
0
votes
1 answer
Monetdb Conversion of string to blob failed
I have a Golang User struct with PasswordHash of type *[]byte
type User struct {
ID UserID `json:"id,omitempty" db:"u_user_id"`
PasswordHash *[]byte `json:"-" db:"u_password_hash"`
CreatedAt *time.Time `json:"-"…
Andrew K Odeki
- 1
- 1
0
votes
1 answer
MonetDB error when starting mclient, cannot set locale
I installed MonetDB on a Ubuntu 16.04 using the instructions: https://www.monetdb.org/easy-setup/ubuntu-debian/
When trying to start the client: mclient -u monetdb -d testdb
I get back this error:
monetdbd: internal error while starting mserver…
0
votes
1 answer
"Failed to extend the BAT" error in MonetDB 11.41.5
I'm using MonetDB 11.41.5 and I'm trying to bulk upload a very large CSV file (70 Gb) to a table using COPY INTO.
After a few minutes, I get the following message:
I checked the disk space and I still have more than 60 Gb available:
Isn't that…
Llorieb
- 25
- 5
0
votes
1 answer
How to pass table as a input parameter in function?
Is it possible to pass table as input parameter in Monetdb function/procedure?
I tried prepare statement but was not able to get it working.
Also it would be nice to get statementid returned directly by 'prepare' statement rather then query…
Alex O
- 1
- 1
0
votes
0 answers
An efficient way to group columns in MonetDB
I have the next INSERT with SELECT in MonetDB:`
insert into colombia.agregada_region_mes
(
cod_anomes
, cod_produto
, sg_estado
, cod_subcanal
, qtd_vendidas
, valor
, valor_dolar
, valor_euro
, fact_count
)
select
f.cod_anomes
, f.cod_produto
,…
Llorieb
- 25
- 5
0
votes
1 answer
Using WITH in MonetDB
I'm trying to execute the next query in MonetDB using "WITH":
with a as (select data_string from colombia.dim_tempo)
select
t.ano_mes
,f.sg_estado
,f.cod_produto
, sum(f.qtd_vendidas) as qtd_vendidas
, count(*) as fact_count
from…
Llorieb
- 25
- 5
0
votes
1 answer
UPDATE sentence using WITH doesn't work in MonetDB
I have this UPDATE in MonetDB (version 11.41.11):
with t as (select distinct cod_atc_nl_1 , desc_atc_nl_1 from uruguay.staging_rm_dims where desc_atc_nl_1 is not null order by 1)
update uruguay.staging_rm_dims
set
desc_atc_nl_1 =…
Llorieb
- 25
- 5
0
votes
0 answers
What happened with MonetDB last release and COPY INTO?
I'm using version 11.39.11 (Oct2020 SP2) of MonetDB database as part of a BI software. MonetDB feeds the fact table with a large flat file of 40 columns and 225 millions of rows. Everything works like a charm. 16Gb of RAM is enough to load that…
Llorieb
- 25
- 5
0
votes
1 answer
How to use "group by grouping sets" and "having" with total line?
I created this SQL command:
select
product_category_name a,
count(product_id) b
from
sys.odeds_2_20210811095253
group by
grouping sets ((product_category_name), ())
The result is this:
a b …
0
votes
1 answer
Sorting accented characters in MonetDB
When I run the command "select product_name from products order by product_name" the result is this:
enter image description here
But, I would like to get this result:
enter image description here
Note: The register "Água Oxigenada" does not need to…
0
votes
1 answer
how can we replace the ""(empty string) with NULL while loading the csv file data into monet db using csv bulk load command
i am trying to load some csv data into monet db using csv bulk load command. Monet team providing below command to load the data by replacing null values with "" but its not working.
Copy into sys.test from path NULL as '';
table structure:
crate…
RamohanReddy
- 3
- 2
0
votes
2 answers
data is converting to binary format while loading data into monet db using Apache pig
I am using MonetDb-Pig layer to load the csv data into Monet db. Internally it is using Binarybulkload commands to load the data but after loading data into table, the csv file values are not not matching with Monet db table values(int…
RamohanReddy
- 3
- 2
0
votes
1 answer
About "LOCKED MODE" (COPY INTO LOCKED)
Is the "lock" done on the entire database or only on the table involved in "COPY INTO"?
In case it is done only on the involved table: Can I have more than one connection in MonetDB, guaranteeing that only the "COPY INTO" connection will access the…
0
votes
0 answers
Monetdb on windows : unable to connect to mserver5 after upgrade
First message on this topic.
-I had an old monetdb installation on my windows laptop
-Did the upgrade in Oct2020-SP5
-It really looks like I can start the server
C:\Program Files\MonetDB\MonetDB5\bin>mserver5
# MonetDB 5 server v11.39.17…
saubert
- 1
- 3
0
votes
2 answers
MonetDB COPY INTO java.lang.NoSuchMethodError with new JDBC 3.0 driver
I'm trying to do a MonetDB "COPY INTO" statement inside Pentaho 8.1 (JDK 1.8.0_282) with new MonetDB JDBC 3.0 driver, and I get this, error message:
java.lang.NoSuchMethodError: java.nio.CharBuffer.mark()Ljava/nio/CharBuffer;
Everything works…
Llorieb
- 25
- 5