首页>
外国专利>
Techniques for evaluating query predicates during in-memory table scans
Techniques for evaluating query predicates during in-memory table scans
展开▼
机译:在内存表扫描过程中评估查询谓词的技术
展开▼
页面导航
摘要
著录项
相似文献
摘要
Techniques are described herein for filtering data from a table during an in-memory scan. Predicates are pushed to in-memory scan to avoid scanning unnecessary columnar units and reduce the overhead of decompressing, row stitching and distributing data during evaluation. Techniques are described herein for generating implied predicates that have conditions on single columns from complex predicates that have multiple conditions on the same column, which can be evaluated during an in-memory scan. Techniques are also described herein to reduce the overhead of a table scan for processing a join query. When redistributing a first table for performing a hash-join, the nodes performing an in-memory scan of the first table may create a filter that tracks unique values from the join key. Data from the second table is only processed and transferred to other nodes in the cluster if the values from the join key pass through the filter.
展开▼