About littlekoi

littlekoi · 02-06-2020

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...

littlekoi · 19-10-2020

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 representation * https://javadoc.io/doc/org.o...

littlekoi · 02-10-2020

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...

littlekoi · 14-09-2020

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 ...

littlekoi · 13-09-2020

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...

littlekoi · 27-08-2020

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...

User Statistics

User Activity

EXAjload: advanced techniques

Re: Exasol GEOMETRY to GeoJSON

Re: Exasol Storage Reporting

Re: Parallel connections/connection pools in Python?

Re: start sql query and dont wait for response in python

Re: CI/CD for Database Deployment

New to the Exasol Community?