diff options
author | Wenchen Fan <wenchen@databricks.com> | 2016-01-20 15:08:27 -0800 |
---|---|---|
committer | Reynold Xin <rxin@databricks.com> | 2016-01-20 15:08:27 -0800 |
commit | f3934a8d656f1668bec065751b2a11411229b6f5 (patch) | |
tree | a353c7b5de468627aeb1c63a673a54cf122db960 /sql/hive/compatibility/src/test | |
parent | 8f90c151878571e20625e2a53561441ec0035dfc (diff) | |
download | spark-f3934a8d656f1668bec065751b2a11411229b6f5.tar.gz spark-f3934a8d656f1668bec065751b2a11411229b6f5.tar.bz2 spark-f3934a8d656f1668bec065751b2a11411229b6f5.zip |
[SPARK-12888][SQL] benchmark the new hash expression
Benchmark it on 4 different schemas, the result:
```
Intel(R) Core(TM) i7-4960HQ CPU 2.60GHz
Hash For simple: Avg Time(ms) Avg Rate(M/s) Relative Rate
-------------------------------------------------------------------------------
interpreted version 31.47 266.54 1.00 X
codegen version 64.52 130.01 0.49 X
```
```
Intel(R) Core(TM) i7-4960HQ CPU 2.60GHz
Hash For normal: Avg Time(ms) Avg Rate(M/s) Relative Rate
-------------------------------------------------------------------------------
interpreted version 4068.11 0.26 1.00 X
codegen version 1175.92 0.89 3.46 X
```
```
Intel(R) Core(TM) i7-4960HQ CPU 2.60GHz
Hash For array: Avg Time(ms) Avg Rate(M/s) Relative Rate
-------------------------------------------------------------------------------
interpreted version 9276.70 0.06 1.00 X
codegen version 14762.23 0.04 0.63 X
```
```
Intel(R) Core(TM) i7-4960HQ CPU 2.60GHz
Hash For map: Avg Time(ms) Avg Rate(M/s) Relative Rate
-------------------------------------------------------------------------------
interpreted version 58869.79 0.01 1.00 X
codegen version 9285.36 0.06 6.34 X
```
Author: Wenchen Fan <wenchen@databricks.com>
Closes #10816 from cloud-fan/hash-benchmark.
Diffstat (limited to 'sql/hive/compatibility/src/test')
0 files changed, 0 insertions, 0 deletions