MonetDB | official mirror of the MonetDB Mercurial repository | Database library

by MonetDB C Version: Jan2022_27 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | MonetDB Summary

MonetDB is a C library typically used in Database, PostgresSQL, MariaDB, Oracle applications. MonetDB has no bugs and it has low support. However MonetDB has 1 vulnerabilities and it has a Non-SPDX License. You can download it from GitHub.

This is the official mirror of the MonetDB Mercurial repository. Please note that we do not accept pull requests on github. The regression test results can be found on the MonetDB Testweb https://www.monetdb.org/testweb/web/status.php .For contributions please see: https://www.monetdb.org/documentation/dev-guide/

Support

Quality

Security

License

Reuse

Support

MonetDB has a low active ecosystem.

It has 270 star(s) with 39 fork(s). There are 18 watchers for this library.

It had no major release in the last 6 months.

There are 116 open issues and 7253 have been closed. On average issues are closed in 45 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of MonetDB is Jan2022_27

Quality

MonetDB has 0 bugs and 0 code smells.

Security

MonetDB has 1 vulnerability issues reported (0 critical, 1 high, 0 medium, 0 low).

MonetDB code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

MonetDB has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

MonetDB releases are not available. You will need to build from source code and install.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of MonetDB

Get all kandi verified functions for this library.

MonetDB Key Features

No Key Features are available at this moment for MonetDB.

MonetDB Examples and Code Snippets

No Code Snippets are available at this moment for MonetDB.

Community Discussions

Trending Discussions on MonetDB

Monetdbe Python UDF

Using WITH in MonetDB

data is converting to binary format while loading data into monet db using Apache pig

MonetDB COPY INTO java.lang.NoSuchMethodError with new JDBC 3.0 driver

Problems debugging mserver5

Golang cannot import a forked repository

How to express "either the single resulting record or NULL", without an inner-query LIMIT?

Querying available (global) variables in MonetDB

How to implement SUM aggregation for strings

Lazy Logical Replication - wlr.replicate error

QUESTION

Monetdbe Python UDF

Asked 2022-Jan-26 at 13:55

Given that monetdbe is a Python package, I'm optimistic that Python user-defined-functions are possible, but I haven't been able to find an example. I've tried this:

...

ANSWER

Answered 2022-Jan-26 at 13:55

The LANGUAGE PYTHON UDF's are a nice development feature in MonetDB's server installation but this feature requires an additional Python module to be loaded. And there is currently no way to configure monetdbe to load the required python module.

However assuming you have performance requirement for some production setting that are not met with the out-of-the-box SQL toolset in monetdbe, it makes more sense to implement a custom UDF extension written in C/C++. In regular MonetDB's server installation, the database server mserver5 can load an arbitrary extension module using the --loadmodule= command option. But there is no equivalent monetdbe_option as of yet.

You might consider adding a feature request for this on monetdbe-python's github repository.

However there seems to exist a functioning undocumented workaround for adding UDF extensions to monetdbe. During its initialization, monetdbe attempts to load a set of hard coded modules. One of those is a module named "udf". You can create your own implementation of this module and load it into monetdbe.

Creating a native UDF extension is outside of the scope of this question and answer but there exist a nice up-to-date tutorial for writing UDF extensions for MonetDB here. Following the steps described in that tutorial, you end up with a SQL function revstr which has a user defined native implementation. The following Python script demonstrate its use:

Source https://stackoverflow.com/questions/70761223

QUESTION

Using WITH in MonetDB

Asked 2021-Oct-15 at 13:05

I'm trying to execute the next query in MonetDB using "WITH":

...

ANSWER

Answered 2021-Oct-15 at 13:05

The WHERE clause needs to be:

Source https://stackoverflow.com/questions/69585141

QUESTION

data is converting to binary format while loading data into monet db using Apache pig

Asked 2021-Aug-09 at 08:04

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 ,double).Seems to be data converted into binary format.

How can we get back the actual values in monetdb? .

Table Structure that I am using CREATE TABLE "test" ( "s_suppkey" INT, "s_name" CLOB, "s_address" CLOB, "s_nationkey" INT, "s_phone" CLOB, "s_acctbal" DOUBLE, "s_comment" CLOB );

Load command that I am using COPY BINARY INTO "test" FROM ( '$PATH/part-1/col-0.bulkload', '$PATH/part-1/col-1.bulkload', '$PATH/part-1/col-2.bulkload', '$PATH/part-1/col-3.bulkload', '$PATH/part-1/col-4.bulkload', '$PATH/part-1/col-5.bulkload', '$PATH/part-1/col-6.bulkload' );

...

ANSWER

Answered 2021-Aug-06 at 08:41

The information provided is insufficient to isolate the issue. The most probable issue is a mis-alignment of the number of values in each of the binary columns.

Check the size of the elements in 's_acctbal' input file, to see if it produced Floats instead of Double binary values.

btw. the MonetDB-Pig project is not actively maintained, but we welcome patches.

Source https://stackoverflow.com/questions/68669267

QUESTION

MonetDB COPY INTO java.lang.NoSuchMethodError with new JDBC 3.0 driver

Asked 2021-Jun-01 at 05:39

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 perfectly when I use MonetDB JDBC driver 2.8 or even 2.29. Does anyone know what is happening?

Thank you!

...

ANSWER

Answered 2021-Jun-01 at 05:39

You also fell into the Java 8 vs Java 9 API break. This issue was fixed here: https://dev.monetdb.org/hg/monetdb-java/rev/5ddfc0aa7f0e You can either use Java 9+ to get rid of the error, or download the tip of MonetDB JDBC driver source and install it or just wait for the next release.

Source https://stackoverflow.com/questions/67780038

QUESTION

Problems debugging mserver5

Asked 2021-May-09 at 13:35

I have recently started debugging the mserver5 application using vscode and a very comfy plugin for cmake called CMake Tools. Moreover, I am using gcc 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04) as a compiler together with the following launch.json debug configuration for mserver5 in vscode:

...

ANSWER

Answered 2021-May-07 at 18:07

If your database was created using monetdb and you want to start it directly using mserver5, you need to tell mserver5 where the .vaultkey is.

In you dbfarm, do a grep monet_vault_key merovingian.log, copy the whole --set monet_vault_key=//dbfarm/demo/.vaultkey and add this option to the start-up command of your mserver5.

Source https://stackoverflow.com/questions/67439492

QUESTION

Golang cannot import a forked repository

Asked 2021-May-03 at 14:32

I'm extending an existing database driver (https://github.com/MonetDB/MonetDB-Go).

I use the github url as an import in my main.go, and in the go.mod:

replace github.com/fajran/go-monetdb@latest => github.com/MonetDB/MonetDB-Go v1.0.0

Yet when I try to go get/go install/go run it, it says:

...

ANSWER

Answered 2021-May-03 at 14:32

You don't need to replace anything, since you already import github.com/MonetDB/MonetDB-Go.

Your error comes from the fact that the source code in github.com/MonetDB/MonetDB-Go is under the src directory.

Final go.mod file:

Source https://stackoverflow.com/questions/67368327

QUESTION

How to express "either the single resulting record or NULL", without an inner-query LIMIT?

Asked 2021-Apr-23 at 18:52

Consider the following query:

...

ANSWER

Answered 2021-Apr-23 at 18:52

Without the MonetDB limitation, you would seem to want:

Source https://stackoverflow.com/questions/67233874

QUESTION

Querying available (global) variables in MonetDB

Asked 2021-Mar-30 at 12:38

Is there a way to query all the available global variables, such as current_schema, current_user, in MonetDB?

...

ANSWER

Answered 2021-Mar-30 at 12:38

You can do: select * from sys.var();

Source https://stackoverflow.com/questions/66871063

QUESTION

How to implement SUM aggregation for strings

Asked 2021-Feb-24 at 10:50

We're using MonetDB to implemnent an idea. For our purposes we need to implement the SUM Aggregation for Strings. My first step in trying to realize it was to just add a sum pattern in the mal files that define these patterns for the other datatypes. Then I tried to pinpoint the exact point where the list of possible implementations is compared with the input datatype but I'm making slow progress.

Where/how are mal files evaluated?
How to go about adding own sum command/pattern so that string data reaches the sum function without MonetDB trying to convert it to bte?

...

ANSWER

Answered 2021-Feb-24 at 10:50

As of Oct2020 release, MAL files are integrated into the C source code, hence, MAL files are no longer used. The MAL files are in the source code repository for documentation purpose only and once that information has been moved to proper places, the MAL files will be gradually removed.

If you want to implement your own function, please have a look at the examples in this repository: https://dev.monetdb.org/hg/MonetDB-extend You can clone it using hg clone https://dev.monetdb.org/hg/MonetDB-extend

I'm not sure how up-to-date this repository now is => depends on which MonetDB version you're using. If you have problems with those examples, please open new tickets in https://github.com/monetdb/monetdb/issues

Source https://stackoverflow.com/questions/66348708

QUESTION

Lazy Logical Replication - wlr.replicate error

Asked 2021-Feb-23 at 15:10

I am attempting to setup LLR on MonetDB. Starting the master (named monet-db-0-tenant) works fine, but when I attempt to clone a replica (named monet-db-1-tenant) using wlr.replicate, I receive the error: "Timestamp (monet-db-0-tenant) has incorrect format"

Example:

...

ANSWER

Answered 2021-Feb-23 at 15:10

Reviewing the source code, I did find where the wlr.master can be designated instead of providing it in the call to wlr.replicate. So, it appears the documentation should be updated to reflect a call to wlr.master.

Source https://stackoverflow.com/questions/66179507

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install MonetDB

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: