[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-09-11 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Resolution: Fixed
Status: Resolved  (was: Patch Available)

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch, PIG-892_v3.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-30 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Status: Open  (was: Patch Available)

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch, PIG-892_v3.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-30 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Status: Patch Available  (was: Open)

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch, PIG-892_v3.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-29 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Attachment: PIG-892_v3.patch

Patch with addressed comments from Santhosh

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch, PIG-892_v3.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-20 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Status: Patch Available  (was: Open)

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-20 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Attachment: PIG-892_v2.patch

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-20 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Status: Open  (was: Patch Available)

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[jira] Updated: (PIG-892) Make COUNT and AVG deal with nulls accordingly with SQL standar

2009-07-20 Thread Olga Natkovich (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Olga Natkovich updated PIG-892:
---

Status: Patch Available  (was: Open)

resubmitting the patch with resolved findbug warnings which was related to 
using Long constructor. We are actually using it in many other cases and might 
have to review this later

 Make COUNT and AVG deal with nulls accordingly with SQL standar
 ---

 Key: PIG-892
 URL: https://issues.apache.org/jira/browse/PIG-892
 Project: Pig
  Issue Type: Improvement
Affects Versions: 0.3.0
Reporter: Olga Natkovich
Assignee: Olga Natkovich
 Fix For: 0.4.0

 Attachments: PIG-892.patch, PIG-892_v2.patch


 both COUNT and AVG need to ignore nulls. Also add COUNT_STAR to match 
 COUNT(*) in SQL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.