About exa-SebastianB

exa-SebastianB · 31-05-2021

If you are familiar with Exasol's Lua capabilities you probably know that they are based on a specially adapted version of Lua 5.1. Just like our customers we felt, it was about time for an update, so we took on the endeavor to build a new embedded v...

exa-SebastianB · 30-04-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 · 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 · 31-05-2021

Johannes, you made my day with that comment. 🤣

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

User Statistics

User Activity

Exasol loves Lua (part 4) - New in Lua 5.2

BucketFS Java (library and API) 2.0.0 released

BucketFS Java 1.0.0 released

SQL keywords: reserved vs. non-reserved

Row-Level Security 2.1.0 released

Re: SQL keywords: reserved vs. non-reserved

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

New to the Exasol Community?