Executed TPC-H Benchmark queries on SAP HANA
Hi.My name is Naomy and I’m an intern in SAP. Recently, I have used TPC-H benchmark(2.17.1) to run some tests on HANA database.Although all of the queries are written in the SQL-92 language, some queries still need to be rectified so that they can be executed on HANA.But the syntax differences don’t necessary make SAP HANA SQL92 incompatible as the SQL standard leaves many aspects to the system implementation.
The fourth query ,for example, uses ‘interval‘ to calculate a period of time.
But it couldn’t be executed on HANA .It seems that HANA SQL doesn’t support ‘Interval’ as a reserved word.
So I used the ADD_MONTHS function to replace ‘Interval’.
Likewise,when I met the queries using ‘interval n day‘ or ‘interval n year‘, I used ADD_DAYS function or ADD_YEARS function to replace the part of queries.
What’s more, SAP HANA doesn’t support ‘AS‘ to set alias in parentheses.
The 13th query, for instance, couldn’t be executed in HANA.
So, I rectified it as shown in the following picture and it works.
Above information is what I have learned when I used TPC-H benchmark queries in my HANA project.I hope it helps fellows who meet //https://scn.sap.com/#//the //same problem.//https://scn.sap.com/#