Data, Process, Insights & things I write about
In a recent blog post SAP presented several ways to load data into a HANA instance. The main approach shown was to use a combination of Python, SQLAlchemy, and Pandas (a Python data analysis library) as well as the… Read More » Getting data into HANA - the easy way
A recent question on StackOverflow brought up a topic that is not well covered in the official HANA documentation: the index structures used in HANA’s row-store. The term CPB tree shows up in several locations in the… Read More » What is CPB+-Tree in SAP HANA?
On the last weekend in May, just a few days ago, the SAP Online Track was held. A volunteer-driven, online developer, and user event around SAP technology. https://twitter.com/Sygyzmundovych/status/1250811896737005570 A… Read More » SAP Online Track 2020
In his recent blog post " Code Pushdown"Paul Hardy, a long-time SAP community contributor described his first foray into HANA SQLScript programming. Paul picked a very ABAP-y problem to solve: Finding records with… Read More » Find the ONE ... or the other
A recent question in the HANA Q&A forum brought up an error message that I recently encountered myself. Modification of table variable is not supported in current SQLScript configuration The way to produce this error is… Read More » Using new features not supported?!
In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?
SQL is an easy language to learn. A few commands to learn ( SELECT/FROM/WHERE/GROUP BY) and you are good to go. One downside of the simple syntax and small vocabulary is that it can lead many SQL users to the assumption… Read More » Matchmaker
A recent question on StackOverflow about how to “format” date values in WHERE-conditions in HANA brought up an aspect of date-handling that is easily overlooked and that can lead to unexpected results. Read More » Be careful with dates and timestamps
On Saturday, 15.02.2020, a rather rain-drenched stormy day in Melbourne, Australia, the SAP Inside Track #sitMEL – Full Day Event was held. I was honored to get a speaker slot and the chance to talk about “Humane DB… Read More » SAP Inside Track #sitMEL – Full Day Event in Melbourne
Q&A forums can be a treasure trove of interesting questions that turn out to have counter-intuitive answers. In “Why does select statement taking too long when primary key is present?” the OP made an interesting… Read More » One in a Million