About exa-Lennart

exa-Lennart · 20-10-2020

BackgroundExplanationCreating the Virtual SchemaUsing the Virtual Schema Background When looking at Exasol Virtual Schemas in our Documentation the first sentence states: Exasol Virtual Schemas are an abstraction layer that makes external data source...

exa-Lennart · 02-09-2020

Hi community, I recently had a talk with a prospect using IBM QRadar for monitoring its Oracle DB for suspicious user actions. I have not encountered this tool so far and was wondering if anyone of our community members might have some insights on QR...

exa-Lennart · 19-06-2020

Preface Handling very large, detailed polygons can result in subpar performance.If you are performing joins using geospatial functions like looking up if a point lies within an area (polygon) and you are experience unusual high query runtimes, this g...

exa-Lennart · 27-05-2020

Hello everyone, my name is Lennart Nieratschker and I have been working as a sales engineer for Exasol since 2019. The new community gives us the opportunity to work even closer with our customers and partners. With more communication, more knowledge...

exa-Lennart · 25-11-2020

A great way to increase adoption! Bring the knowledge to everyone who needs it!

exa-Lennart · 16-11-2020

Hi Steffen, in order to make the implicit cast work you need to set your NLS_TIMESTAMP_FORMAT session parameter to the corresponding timestamp format. Implicit casting will therefore only work with one timestamp layout at a time. ALTER SESSION SET NL...

exa-Lennart · 13-11-2020

Hi Steffen, JSON_EXTRACT only supports native JSON types. Those are a string. a number. an object (JSON object) an array. a boolean. null. according to: https://www.w3schools.com/js/js_json_datatypes.asp As the source states: JSON values cannot be on...

exa-Lennart · 02-11-2020

Hi @ceesvl, on Thursday last week we successfully deployed an Exasol 7.0.1 on a prospects VMware infrastructure without any issues. This was a fresh installation - not an update. We did not encounter any issues. Testing will start this week so this i...

exa-Lennart · 29-10-2020

Hi Rachel,as @mwellbro points out correctly you can't use multiple preprocessor scripts in parallel. However you can use them sequentially. This means that each transformation you apply to your SQL must not be broken by the next transformation - whic...

User Statistics

User Activity

Using Virtual Schema on a REST API

Usage of Q Radar with Exasol customers

Improving geospatial performance for large, detailed polygons

Hi everyone - Lennart Nieratschker (exa-Lennart)

Re: Free Certifications starting November 23rd!

Re: JSON_EXTRACT and ISO8601/JSON style timestamp format

Re: JSON_EXTRACT and ISO8601/JSON style timestamp format

Re: Has a 7.x version been deployed on en VMware (production) architecture?

Re: Multiple PreProcessor Scripts

New to the Exasol Community?