[ https://issues.apache.org/jira/browse/HIVE-4394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13638842#comment-13638842 ]
Ashutosh Chauhan commented on HIVE-4394: ---------------------------------------- Yeah, I ran the query as it is on pg, it ran fine and produced results. I read standard but couldn't determine if it actually says anything for this scenario. Reading online documentation for DB2, Sql Server and Oracle seems to indicate all of them return NULL in such cases. So, seems like only postgres has a different behavior. At this point to me either way is an acceptable solution. Harish, what do you think? > test leadlag.q fails > -------------------- > > Key: HIVE-4394 > URL: https://issues.apache.org/jira/browse/HIVE-4394 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Reporter: Namit Jain > > ant test -Dtestcase=TestCliDriver -Dqfile=leadlag.q fails. > cc [~rhbutani] -- 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