[BEAM-3509] PARTITION BY in Beam SQL In Select Command

• Type: New Feature
• Status: Resolved
• Priority: P2
• Resolution: Duplicate
• Fix Version/s: Not applicable
• Component/s: dsl-sql
• Labels: performance stale-P2
• Flags: Important
• Assignee: Unassigned
• Reporter: Kishan Kumar
• Created: 22/Jan/18 11:55
• Updated: 24/Jul/20 20:14
• Resolved: 10/Jun/20 19:36

Description

Partition By Option Will Be Very Help Full for DataFlow Developer To Migrate Query and Do Transformation on That because of Many Netezza Query and Oracle Query Consists Of Partition By Which Makes SQL Query More Efficient. The alternative is Making Joins And Filtering It Can Be Done But It Makes Code Unreadable And Performance Become bad for DataFlow Job.

Examples: SELECT MIN(COLUMN) OVER (PARTITION BY COLUMN NAME) FROM TABLENAME

Issue Links

• is blocked by: BEAM-9198 BeamSQL aggregation analytics functionality