Hi,
I reinstalled MonetDB as well as the ODBC driver after last week's update
to SP2. How could I troubleshoot my system if I get a Memory allocation
error SQLSTATE=HY001 if Stata would query the database?
Otherwise I do see the data source listed, both in Stata (with -odbc
query-) and Microsoft ODBC Data Source Administrator. (The latter lists the
database under System DSN with the right name, platform and driver.)
Thanks,
Laszlo
The MonetDB team at CWI/MonetDB BV is pleased to announce the
Jan2014-SP2 bugfix release of the MonetDB suite of programs.
More information about MonetDB can be found on our website at
<http://www.monetdb.org/>.
For details on this release, please see the release notes at
<http://www.monetdb.org/Downloads/ReleaseNotes>.
As usual, the download location is <http://dev.monetdb.org/downloads/>.
Jan 2014-SP2 bugfix release
Build Environment
* Lots of minor fixes were made for potential defects found by
Coverity Scan.
* On Windows we now build the geom module against version 3.4.2 of
the geos library.
Client Package
* ODBC: Implemented {call procedure-name(...)} escape. The version
{?=call ...} is not implemented.
Bug Fixes
* 3424: numeric values at the front of strings determines whether
CAST works successfully
* 3439: Python driver drops milliseconds from timestamps
* 3446: SET READ ONLY forgets previous changes
* 3455: String columns unusable from 64-bit .NET via ODBC
* 3456: Insert fails
* 3457: When kernel of remote client crashes, the connection remains
established on server side
* 3458: mserver5 crash on SQL: SELECT COUNT(*) FROM SYS.TABLES HAVING
COUNT(*) > 0
* 3461: mserver5 crash on SQL: SELECT * FROM SYS.ARGS WHERE FUNC_ID
NOT IN (SELECT ID FROM SYS.FUNCTIONS) OR FUNC_ID NOT IN (SELECT *
FROM SYS.FUNCTIONS)
* 3462: Invalid SQL (IN with subquery which returns multiple columns)
is accepted
* 3463: Crash on SELECT with SERIAL aggregation and GROUP BY column
alias's
* 3468: Local temporary table persists across sessions
* 3469: Absolute network paths considered invalid for COPY INTO ...
FROM statement.
* 3473: Various memory leaks in SQL compilation
* 3477: ODBC driver raises "unexpected end of input" for prepared
string parameter from .NET application
* 3481: Cannot run multiple COPY INTO statements in one 's'-command
* 3482: Crossproduct error
Hello,
I've been looking at monetdb for a while, and I've been very impressed with
the project.
I would like to use monetdb to analyze web log data from a very active
site. I have no doubt that it can handle the quantity of data, but I'm not
sure how to perform some of the queries that I have used in other systems.
For example, I would like in particular to be able to perform click-stream
analysis of the data. On other systems I've used proprietary extensions
which allowed me to create a window by pattern matching a certain column.
Do you have any suggestions about where I should look to perform similar
kinds of queries?
Thanks!
-={C}=-
Hi,
This might be less of MonetDB-specific question about features than about
RDBMS (or just SQL) in general, but I would still appreciate your advice
in these matters.
I have data with a few "cross-sectional" tables (e.g. the parents of an
individual) and many longitudinal/panel tables in annual chunks (e.g. tax
records for each year separately).
I wonder if it is a good idea to merge/union the annual tables into long
panels.
The benefits seems to be a much cleaner structure for the consistent
columns, correspondingly easier code to write, fewer loops, tables names,
lines of code. Also, fast joins on individual IDs and years across the
tables without intermediary steps.
However, the downsides are that not all columns are consistent across
years, and there are simply some that appear only in certain years. Storing
missing values for other years for these variables is a waste of disk space
and memory. The merged tables could be too big anyway — if it matters in
MonetDB (think of tables ~70 GB in some cases, while my server has 128 GB
RAM), while many use cases would focus on a subset of years anyway.
Do you have any thoughts about this? Maybe more concrete questions would be:
— How cumbersome would it be (for a novice!) to code joining data from the
annual tables separately, for multiple series of tables? (E.g. union all
tax returns for 1997-2008, then join all residential data for these 12
years year-by-year, then employment records year-by-year etc.)
— How much slower would this *run* than simply selecting years from the
longitudinal tables?
— Shall I be worried about the longitudinal tables having the size on the
same order of magnitude as my physical memory, or MonetDB handles it
equally efficiently (it would need to access many of the small annual
tables anyway, that also takes memory).
Thanks,
Laszlo
Hello,
I am new to MonetDB, and I am very interested in the SciQL functionality.
I downloaded and installed the windows build of MonetDB. When I tried some
SciQL on the client, it seems that it does not work. I followed the
commands in paper Kersten et. al (2011) as follows:
sql>start transaction;
auto commit mode: off
sql>CREATE ARRAY A1 (
more> x INTEGER DIMENSION[4],
more> v FLOAT DEFAULT 0.0);
syntax error, unexpected IDENT, expecting INDEX in: "create array"
Do I miss something important? Please advise.
Thanks,
yingwei
Hi,
With today's Jan2014-SP2 update, I wanted to uninstall and reinstall using
the .msi files in Windows Server 2012. (I also wanted to change the install
locations, as I have no access to the default location on C to change the
bat files and edit where my dbfarm should be.)
Maybe because I ran MonetDB5-SQL-Installer-x86_64-20140514.msi
before MonetDB-ODBC-Installer-x86_64-20140514.msi, but now the ODBC remove
fails, repairing also. A desperate deletion of the entire C:/Program
Files/MonetDB, did not make things better, maybe it made worse.
Could you let me know how I could proceed with uninstalling the ODBC
driver? I do want to have a clean, stable reinstall (under the new
location) which I can trust.
Thanks!
Laszlo
Hi,
I found previous
notes<https://www.monetdb.org/pipermail/users-list/2010-November/004529.html>here
that the server would expect UTF-8 input from the client or COPY INTO,
so I need to work on my my Western ISO Latin 1 files. However, the error
message is confusing about, COPY INTO complains about "'ascii' codec can't
decode byte 0xc4 in position 8: ordinal not in range(128)."
Shall I convert the data to UTF-8 then, or is that futile? What has the
ascii codec to do with UTF-8?
Thanks,
Laszlo
Hi,
I investigated further, and actually I cannot get any CSV file working with
monetDB's COPY INTO on Windows.
Hannes filed a bug report today:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3484
However, I tried other things since his/our attempts, e.g. removing the
final end-of-line (EOL, still CRLF on Windows) or switching EOL to LF only
for the temporary file (and changing the COPY INTO call's delimiters too,
of course). Neither helped. Still the same error: Incomplete record at end
of file. (Which I am not sure whether it literally means the end of the
source textfile or simply the last line before breaking.)
Basically, the question is, is there a way to get this working on Windows
in Jan14-SP1? Or could someone please verify it's worth downgrading to a
previous because it definitely can do COPY INTO?
Thanks!
Laszlo