About exa-Lennart

exa-Lennart · 18-03-2021

Background Let's face it: XML is dead. Source But just because new shiny alternatives like YAML or JSON are around does not mean we can abandon XML altogether. There are still companies hiring Cobol developers you know...So until the last 21 gun salu...

exa-Lennart · 20-10-2020

BackgroundPrerequisitesI don't care how it works, just give me the code!How to import XML data into ExasolHow the ftp_meta_load() UDF worksHow the parse_my_xml() UDF worksHow the xml_load() script worksAdditional Notes - Could we have done something ...

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 · 06-04-2021

Hi, could you elaborate what you mean by "pivot transformation" in this context? A preferred approach for batch inserting would be to use the IMPORT statement. However this greatly depends on your use case.

exa-Lennart · 26-03-2021

Hi there, without knowing your code - so knowing exactly what you are trying to do it is a little bit hard to give you specific advice but let me try anyway. First of all you are correct. LUA scripts commit once they finished the end of their executi...

exa-Lennart · 18-02-2021

Hi Kamal, from the top of my head I would say that the UDF+View approach is only another way of achieving the same thing. I would argue that the VS approach gives you a clearer interface on how to interact with the source. What I mean by that is that...

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

User Statistics

User Activity

XML-parsing in retail using Python3 UDFs

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: scripts performance

Re: scripts performance

Re: Using Virtual Schema on a REST API

Re: Free Certifications starting November 23rd!

Re: JSON_EXTRACT and ISO8601/JSON style timestamp format

New to the Exasol Community?