Merging right. Some tests with data loading in HANA from Down Under.

Based on SAP HANA SPS 12 (HCP trial) When Jody Hesch recently send me an email with a question about HANA, he received what everyone receives when sending email questions about HANA. The reply is a version of "Usually I don’t do email Q&A as this simply doesn’t help with knowledge sharing. Instead, I advise everyone … Continue reading Merging right. Some tests with data loading in HANA from Down Under.

HANA in a pocket, a skull and some dirty hands on Linux

DISCLAIMER: this blog describes unsupported and unlicensed use of the SAP HANA software. I describe my personal try-out of a hardware/software combination. It's not in any way meant to be used productively or recommended to use the software in the way I describe. If you loose data, waste life-time, money, your good mood or damage … Continue reading HANA in a pocket, a skull and some dirty hands on Linux

SAP HANA community continues to grow and so does the moderator team

Hello HANA community! As of last week, we are happy to have a new moderator in our team: Michael Healy Michael lives and works in Dublin, Ireland and works in the SAP Digital Business Services group helping customers around the globe with their SAP HANA implementations. When he's not solving support incidents he is busy … Continue reading SAP HANA community continues to grow and so does the moderator team

Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11

Far fetched...   A colleague asked me over a year ago (2015 and SPS 9 ... sounds ancient now, I know) whether it is possible to leverage information models in a different SAP HANA instance via SDA (Smart Data Access - look it up in the documentation if you didn't know this yet). The scenario … Continue reading Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11

HANA dude analyses Python error and this happened next… (plus: something with Andy Warhol)

Fresh out of the Christmas/New Year vacation I yesterday received this question from one of my colleagues: Hi Lars I am trying to set up a demo to show MDC at FKOM. I am trying to configure MDC via the Python script method – although I have an issue where I am missing a file … Continue reading HANA dude analyses Python error and this happened next… (plus: something with Andy Warhol)

Fiddle riddle – Amazing: stuff gets faster and takes less space!

In Quick notes during a fiddle-session I played around with a table that contained all possible values for a date column. To fill it I used a FOR LOOP with an INSERT and a commit every 10000 records. That took 9:37 minutes for 3.652.061 records. That's terrible performance and nothing that needs to be accepted … Continue reading Fiddle riddle – Amazing: stuff gets faster and takes less space!