32 / 577
32
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
SAP HANA Technology
Column Store
Stores table by column, columns can be accessed in one read..
ID Artist
Genre Title hits
1 Adele soul
Rolling In
The Deep
352
2 Lady Gaga pop
Born this
way
216
3 Katy Perry house E.T.
183
4 Jason Mraz pop I am yours 96
1
2
3
4
Adele
Lady Gaga
Katy Perry
Jason
Mraz
soul
pop
house
pop
Rolling In
The Deep
Born this
way
E.T.
I am yours
352
216
183
96
Single-scan aggregation:
SELECT SUM(hits) FROM Tophits
∑
Result
:
847