About exa-SebastianB

exa-SebastianB · 31-03-2021

About the project Exasol's BucketFS is a distributed file system that automatically synchronizes files uploaded on one cluster node to all other nodes. It is intended for providing shared configuration, scripts and libraries used in User Defined Func...

exa-SebastianB · 23-03-2021

Whether you are a user of Exasol or a software developer working on a SQL client, keywords are an important concept to know. SQL key words are part of the syntax of SQL statements — the smallest building blocks if you will. SELECT for example is a ke...

exa-SebastianB · 26-02-2021

Release 2.1.0 of Exasol's Row-Level-Security contains a fix for a security issue, classification "medium" in an administration script. The issue can lead to giving unintended row access to users. You are likely affected if: you are using role-based r...

exa-SebastianB · 19-01-2021

About the Project Exasol Testcontainers provide an abstraction to Exasol running on Docker for the purpose of integration testing based on Java Testcontainers. You can create a dockerized instance of Exasol with a few Java commands from within the te...

exa-SebastianB · 08-12-2020

What's new? In the 3.4.0 release we've added the ability to override the docker image used via the Java system property com.exasol.dockerdb.image. You can use this in a continuous integration build for example to iterate through a list of Exasol vers...

exa-SebastianB · 24-03-2021

Flexibility is great, I agree with that. I still shudder when I remember times when filenames were restricted to 8-dot-3 character (on some OSes at least). It's probably the software engineer inside of me speaking, but I would like SQL better if all ...

exa-SebastianB · 09-03-2021

EXPLAIN VIRTUAL uses the VS adapter to rewrite the original query before feeding it into the ExaLoader via IMPORT. There are other, rarer cases, but let's focus on this one. If EXPLAIN VIRTUAL does not succeed, you know that the problem is either the...

exa-SebastianB · 19-02-2021

The main use for VS is attaching to other SQL-based RDBMS. That's where it has the biggest benefit architecture-wise. It is designed to make external tables appear to be an integral part of Exasol. The VS adapter is responsible for projecting the met...

exa-SebastianB · 21-12-2020

VS have no direct access to the local file system. You can however use HTTP to r/w from BucketFS. Alternatively you could in theory write the content to tables. Be aware of locking in that case. Also the size of an Exasol VARCHAR is limited to 2 mill...

exa-SebastianB · 14-12-2020

The first thing I recommend when debugging Virtual Schemas is getting remote debugging running. It's explained in detail in the developer documentation on GitHub: https://github.com/exasol/virtual-schemas/blob/master/doc/development/remote_debugging....

User Statistics

User Activity

BucketFS Java 1.0.0 released

SQL keywords: reserved vs. non-reserved

Row-Level Security 2.1.0 released

Exasol Testcontainers 3.4.1 released

Exasol Testcontainers 3.4.0 released

Re: SQL keywords: reserved vs. non-reserved

Re: What’s the best query trick you are using?

Re: Using Virtual Schema on a REST API

Re: virtual schemas / local files

Re: Virtual schema creation hanging

New to the Exasol Community?