Background EXAjload is a standard tool for bulk data loading. Its
documentation is brief, but the tool is more powerful than you might
think. It is possible to: import data from STDOUT of other processes
without creating a tmp file on disk; import da...
We have an alternative implementation in Java: CREATE OR REPLACE JAVA
SCALAR SCRIPT geo_to_json (geo VARCHAR(2000000), srid DECIMAL(9,0))
RETURNS VARCHAR(2000000) AS /* * Convert the geometry to a GeoJSON
Yep, the current disk space usage available in stat tables is not
useful. Interestingly enough, the reporting in ExaOperation is usually
correct.This is the formula / function in PyEXASOL which gets as close
as possible to disk space usage reported b...
Unlike classic row-store databases (MySQL, PostgreSQL), analytical
column-store databases cannot serve hundreds and thousands of
simultaneous connections efficiently. The main goal for analytical
databases is to serve small number of complex queries ...
Hello, Currently it won't be possible in any programming language. As
soon as network socket closes on client side, Exasol server will
terminate session and rollback the current transaction. "Abandoning" the
connection is not a good idea because IMPO...
We have CREATE sql stored as plain text files and a small custom script.
The script parses SQL text and compares it with object actually
presented in database. Views, functions, scripts are compared as text.
Tables are compared on per-column basis. S...