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...
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...
Thank you! I have a lot of stuff on my mind, but it's hard to measure
the actual interest. The best topics require a lot of text to explain
(e.g. UDFs logging and memory management), and only a small number of
customers can actually use it in product...
I think it's better to go other way and implement a simple ETL script,
which is going to: 1) Check if something needs to be imported /
synced.2) Run the actual IMPORT.3) Set "sync-status" in external
database. Running a simple query in Oracle is very...