Re: Vectorised Query Execution extension

2016-08-04 Thread Jörn Franke
Even if it is possible it does only make sense to a certain limit given by your CPU and CPU caches. > On 04 Aug 2016, at 22:57, Mich Talebzadeh wrote: > > As I understand from the manual: > > Vectorized query execution is a Hive feature that greatly reduces the CPU

Re: Vectorised Query Execution extension

2016-08-04 Thread Gopal Vijayaraghavan
> Vectorized query execution streamlines operations by processing a block >of 1024 rows at a time. The real win of vectorization + columnar is that you get to take advantage of them at the same time. We get to execute the function once per 1024 rows when things are repeating - particularly true

Vectorised Query Execution extension

2016-08-04 Thread Mich Talebzadeh
As I understand from the manual: Vectorized query execution is a Hive feature that greatly reduces the CPU usage for typical query operations like scans, filters, aggregates, and joins. A standard query execution system processes one row at a time. This involves long code .. Vectorized query