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