There was an interesting (aka nerdy) question in the SAP Community Q&A the other day: "Are SQLScript and HANA SQL Turing complete?" I took a swing at it and the following is my result (a slightly edited version of my original answer). Alright, let's do this! (even though I don't have an idea why it … Continue reading Is SAP HANA SQL/SQLScript Turing complete?
Have you been using the ISNUMERIC() function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog for you. Just recently I've seen a customer using my old workaround (first published here) and then a few days later the related stackoverflow question got … Continue reading What’s your number?
Hey there! I recently presented a short session on my experiences with developing and debugging non-classic-SAP HANA solutions at the Leading Insights conference in Melbourne (27./28.3.2017). And since the slides are prepared in a way that they could be used without my talking as well, I thought, I might just post them. So, there they … Continue reading Eco-friendly slide recycling with HANA
Based on SAP HANA SPS 11 Update 1.6.2017 Retesting the APPLY_FILTER() approach on rev. 112.07 showed that it is now possible to simply hand APPLY_FILTER() an IN condition with a list of integers. This approach for the workaround of the general limitation on multiple input parameter values for scripted calculation views is also shown in … Continue reading On multiple mistakes with IN conditions
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!
For a while now I am working as a Solution Architect for the SAP Custom Development organisation. This is the team you'd call when you want custom-built solutions that perfectly fit into your standard solution landscape. My job there is not coding or implementing systems, but rather designing Solutions and turning those designs into commercial … Continue reading Quick notes during a fiddle-session
If you're not living behind some red moon and you're reading this blog, you will likely be aware that SAP HANA SPS 10 had just been released. With it also the SAP HANA Studio had been improved and extended. Since I personally like eye-candy and enjoy exploring new features when they come with a button … Continue reading The 7th Niceness of new toys’n’tools
Not sure you knew this already, but starting with SPS 8 (seemed to work with Rev. 74 as well), SAP HANA comes with an option to have an IDENTITY column in column store tables. The idea here is that you can insert data into the table and every row will automagically get a new unique … Continue reading Quick note on IDENTITY column in SAP HANA
based on SAP HANA revision 74 >>> update 09.02.2016 >>> if you are trying to work on a similar problem, please make sure to also review the solutions posted in discussion Fetch the first record with 24 hr interval based on first record timestamp >>> The solutions posted there are much more efficient and solve … Continue reading Of groups of serial shoppers…