[jira] [Commented] (HIVE-4142) Remove inferring partition specification behavior

["Harish Butani (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-4142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13599251#comment-13599251 ] 

Harish Butani commented on HIVE-4142:
-------------------------------------

Ashutosh, Prajakta, Brock: please take a look.
Had to revise a good portion of the tests.
All the tests have the same result, except 2: ptf.q: q11 and windowing.q q10
Both these have to do with support for having with windowing.
Now that a Window Function has to explicitly have a Window Spec (unless it is the partition by constant case) it is harder to associate a fn invocation in having with a UDAF with an over clause. You cannot say:
{noformat}
having rank() over(..) > 5
{noformat}
Will address this in another Jira; probably remove the code that tries to associate a having clause with a WindowingSpec.
                
> Remove inferring partition specification behavior
> -------------------------------------------------
>
>                 Key: HIVE-4142
>                 URL: https://issues.apache.org/jira/browse/HIVE-4142
>             Project: Hive
>          Issue Type: Bug
>          Components: PTF-Windowing
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>         Attachments: HIVE-4142.D9285.1.patch
>
>
> Remove behavior that:
> - implicitly sets the partition specification of a UDAF
> this interferes with:
> - the user wanting to apply a UDAF on the entire dataset
> - is ambiguous once we support multiple partitions in 1 query.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira