You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@beam.apache.org by "Xu Mingmin (JIRA)" <ji...@apache.org> on 2018/01/30 20:04:00 UTC
[jira] [Assigned] (BEAM-3509) PARTITION BY in Beam SQL In Select
Command
[ https://issues.apache.org/jira/browse/BEAM-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xu Mingmin reassigned BEAM-3509:
--------------------------------
Assignee: (was: Xu Mingmin)
> PARTITION BY in Beam SQL In Select Command
> ------------------------------------------
>
> Key: BEAM-3509
> URL: https://issues.apache.org/jira/browse/BEAM-3509
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Affects Versions: 2.2.0
> Reporter: Kishan Kumar
> Priority: Major
> Labels: performance
>
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)