Showing posts with label tpc-h. Show all posts
Showing posts with label tpc-h. Show all posts

Sunday, 12 June 2016

Executed TPC-H Benchmark queries on SAP HANA

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.

Executed TPC-H Benchmark queries on SAP HANA