[PHOENIX-3560] Aggregate query performance is worse with encoded columns for schema with large number of columns

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Information Provided
• Fix Version/s: 4.11.0
• Assignee: Samarth Jain
• Reporter: Mujtaba Chohan
• Created: 03/Jan/17 23:11
• Updated: 24/Mar/17 00:11
• Resolved: 24/Mar/17 00:11

Description

Schema with 5K columns

create table (k1 integer, k2 integer, c1 varchar ... c5000 varchar CONSTRAINT PK PRIMARY KEY (K1, K2)) 
VERSIONS=1, MULTI_TENANT=true, IMMUTABLE_ROWS=true

In this test, there are no null columns and each column contains 200 chars i.e. 1MB of data per row.

Count * aggregation is about 5X slower with encoded columns when compared to table non-encoded columns using the same schema.