About exa-Lennart

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

Hi Steffen, I would strongly recommend you to use a python dictionary as buffer for your JSON string, as this data-structure is already JSON compliant. Then use json.dumps() to return an encoded JSON string. exa.meta.input_columns[i].name Contains th...

exa-Lennart

Hi Flo,welcome to the Exasol community.What you are asking for is basically the reverse of our recently implemented JSON functions. Because those functions only feature JSON -> relational structure operations and not the reverse operation those funct...

exa-Lennart · 08-09-2020

Let me explain a little bit why Charlie's answer is correct. To interact with the database there is exactly one interface available: SQL. Whether the SQL is directed to the database via JDBC or ODBC is irrelevant. In any case it must be SQL. If you u...

exa-Lennart · 02-09-2020

Thank you very much Charlie, that was very helpful 👌

exa-Lennart · 15-06-2020

Hi Tom, this might be because of the SET EMIT function you are using. Could you please share the UDF code you are using? This will make it way easier to find the issue 🙂 BestLennart

User Statistics

User Activity

Usage of Q Radar with Exasol customers

Improving geospatial performance for large, detailed polygons

Hi everyone - Lennart Nieratschker (exa-Lennart)

Re: How to create a JSON from table data

Re: How to create a JSON from table data

Re: LUA Scrip -How to Emit data from table by filtering based on a parameter

Re: Usage of Q Radar with Exasol customers

Re: Issue with execution speed of Python UDF script

New to the Exasol Community?