Re: [Vote] Please provide valuable feedback's and vote for Like filter query performance optimization

+1 On Mon, Nov 14, 2016, 3:54 PM sujith chacko wrote: > Hi liang, > Yes, its for high cardinality columns. > Thanks, > Sujith > > On Nov 14, 2016 2:01 PM, "Liang Chen" wrote: > > > Hi > > > > I have one query : for no dictionary columns

Re: [Vote] Please provide valuable feedback's and vote for Like filter query performance optimization

Hi liang, Yes, its for high cardinality columns. Thanks, Sujith On Nov 14, 2016 2:01 PM, "Liang Chen" wrote: > Hi > > I have one query : for no dictionary columns which are high cardinality > like phone number, Whether the pruning cost is hight,or not ? > > Regards >

[Vote] Please provide valuable feedback's and vote for Like filter query performance optimization

Hi All, I am going to optimize the LIKE Filter query flow for no-dictionary columns, please find the details mentioned below. *Current design:* For Like filter queries no push down is happening to carbon layer, because of this there will be no block/blocklet level pruning which can happen