Executed TPC-H Benchmark queries on SAP HANA

[naomy_xu]

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 //http://scn.sap.com/#//the //same problem.//http://scn.sap.com/#

[remi_astier]

What about the compression rates from flat files ?

Did you measure the effects of different partitionning strategy on large tables ?

[lbreddemann]

Hi Remi,

despite the catchy title this blog was about the syntactic differences of SQL-92 and the SAP HANA implementation - not about the benchmark results.

The questions you posted sound interesting. Maybe you open a discussion thread and describe a bit more in detail what you want to know about.

- Lars

[naomy_xu]

Hi Remi,

I haven't measure the different partitionning strategy on large tables yet,but I 'm going to do it this month.I hope I can provide some valuable results later.

BTW,does the 'flat files' you mention is the data generated by TPC-H DBGEN?

[remi_astier]

Yes, the "flat files" are the files generated by this program that contain the data.

TPC-H results is a sensitive topic, I suggest that we align internally before you publish anything externally.

[Former Member]

Do you have the set of scripts and data that ran against HANA in a package I might download?  I am anxious to find a way to load test our HANA appliances.

Thanks!

[naomy_xu]

Hi Scott,

I attached the scripts I used in my project to this blog, maybe you can refer to it.

Hope it helps. :smile: