[ASTERIXDB-2648][COMP] Fix dataset order in broadcast hint - user model changes: yes - storage format changes: no - interface changes: no
- Provides hash-bcast hint to replace bcast hint which makes broadcast join consistent with other types of joins for choosing the broadcasting dataset based on dataset order in FROM clause. - Chooses the build dataset to get broadcast based on the order in the FROM clause not the WHERE clause (which was the case for bcast hint).
[ASTERIXDB-2488][COMP] Support aggregate window functions - user model changes: yes - storage format changes: no - interface changes: no
Details: - Implement aggregate window functions: agg_func() OVER (frame_var AS)? (PARTITION BY ... ORDER BY ... frame_spec) - Where agg_func is a SQL/SQL++ aggregate function - Fix percent_rank() to always return 0 for the first tuple - Fix ntile() to handle NULL argument - Log query after each rewrite rule in SqlppQueryRewriter - Implement toString() for ADayTimeDuration, fix it for AYearMonthDuration - Add seek() method to RunFileReader