Using new features not supported?!
What do you do when HANA tells you that the new feature you want to use is actually not supported?
This post has an answer for that.
Lars Breddemann
Matchmaker – quick quick?
You’ve come up with a clever SQL to solve a problem but now you want to make it fast?
No worries! This post shows how I shaved off 50% runtime and memory by copy & paste.
Matchmaker
Finding alternative order-documents where the lineitems match a certain percentage of a reference document? In SQL? With no cursors? See how it’s done!
Be careful with dates and timestamps
Ever mixed timestamps and dates and wondered why your result wasn’t quite what you expected?
Find one possible answer to this in this blog post.
SAP Inside Track #sitMEL – Full Day Event in Melbourne
Looking for the content of Lars’ presentation from #sitMEL-2020? Look no further, it’s all here.
One in a Million
In which I analyze why a SELECT takes longer when the primary key column is included…
The time is now, isn’t it?
Doing calculations with dates in your queries? Better read this post and make sure your code does what you think it does.
Machine learnings of hana, odbc, and macos
In which I try out something seemingly simple and chase problems down a rabbit hole.
hana.ml.r library for R on macOS is not for the casual user…
Types of NULL
In which I deal with non-obvious type conversion problems and NULLs.
[NTM] HANA STUDIO NoClassDefFoundError: javax/xml/soap/SOAPException
Note-To-Myself: solution for “”java.lang.NoClassDefFoundError: javax/xml/soap/SOAPException” error.” with SAP HANA Studio on macOS.