[HPCC-17002] Spot dedupped RHS feeding into a lookup Join and optimize away - HPCC

XML

Word

Printable

Details

Type: Improvement
Status: Active
Priority: Minor
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: Code Generator
Labels:
None

Compatibility:
Minor

Description

Not sure how common it is, but have seen an example of a global sort feeding into a lookup join (rhs).

Lookup join implicitly dedupped the RHS already (as opposed to JOIN, LOOKUP MANY), so a sort->dedup is not needed and wasteful. It would be good to spot and remove these operations.

Attachments

Activity

People

Assignee:: Available for anyone

Reporter:: Jake Smith

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 06/Feb/17 1:53 PM

Updated:: 08/Feb/17 3:08 PM