[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886769#action_12886769 ] Arvind Prabhakar commented on HIVE-287: --- I vote for a meeting to hash this out

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886780#action_12886780 ] John Sichi commented on HIVE-287: - I'll see if I can clear it up with Zheng today, and if so,

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886794#action_12886794 ] Zheng Shao commented on HIVE-287: - The plan looks good to me. Just one comment: I think we

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886804#action_12886804 ] Arvind Prabhakar commented on HIVE-287: --- I think keeping two different interfaces for

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886882#action_12886882 ] Zheng Shao commented on HIVE-287: - Talked with John offline also. I agree that we can use

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-09 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886950#action_12886950 ] Arvind Prabhakar commented on HIVE-287: --- bq. 1. Change the comments for the 2 new

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-08 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886339#action_12886339 ] Arvind Prabhakar commented on HIVE-287: --- @Zheng: Welcome to the party. bq. Why do we

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-07 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12886183#action_12886183 ] Zheng Shao commented on HIVE-287: - Hi Arvind, sorry for coming late for the party. I have 2

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-06 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12885766#action_12885766 ] Arvind Prabhakar commented on HIVE-287: --- Review board review posted:

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-06 Thread HBase Review Board (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12885788#action_12885788 ] HBase Review Board commented on HIVE-287: - Message from: Carl Steinbach

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-02 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884580#action_12884580 ] Arvind Prabhakar commented on HIVE-287: --- Thanks for the explanation John. The SQL BNF

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-02 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884699#action_12884699 ] Ashish Thusoo commented on HIVE-287: @John Another disadvantage for doing C that I can

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884770#action_12884770 ] John Sichi commented on HIVE-287: - A couple of DBMS's I just tried actually do use something

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-07-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884776#action_12884776 ] John Sichi commented on HIVE-287: - @Ashish: given where we are currently, the keyword

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-30 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884125#action_12884125 ] Arvind Prabhakar commented on HIVE-287: --- @John - are you suggesting that the grammar be

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12884134#action_12884134 ] John Sichi commented on HIVE-287: - Yes, if you can do get it to work in the grammar itself

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-25 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12882792#action_12882792 ] John Sichi commented on HIVE-287: - Sorry, my commit for HIVE-1387 just introduced a new

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-21 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12881020#action_12881020 ] Arvind Prabhakar commented on HIVE-287: --- @John: Can you please take a look at the

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-18 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12880325#action_12880325 ] John Sichi commented on HIVE-287: - The object creation and method call here are negligible

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-17 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12879929#action_12879929 ] John Sichi commented on HIVE-287: - Sorry to chime in late on this one, but I have one big

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-06-15 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12879147#action_12879147 ] Namit Jain commented on HIVE-287: - Arvind, I am sorry about the delay in getting back to

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-05-25 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12871310#action_12871310 ] Namit Jain commented on HIVE-287: - I am sorry about 1 and 3 - you can ignore those. 2. It

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2010-05-25 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12871494#action_12871494 ] Arvind Prabhakar commented on HIVE-287: --- Modified the implementation as per review

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2009-06-17 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12720511#action_12720511 ] Namit Jain commented on HIVE-287: - can you try: select count(1) from (select col1, col2,

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2009-06-17 Thread Patrick Salami (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12720900#action_12720900 ] Patrick Salami commented on HIVE-287: - Thanks for the reply! However, I get a parse error

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2009-06-17 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12720917#action_12720917 ] Namit Jain commented on HIVE-287: - You need to use an alias for the sub-query select

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2009-06-16 Thread Patrick Salami (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12720500#action_12720500 ] Patrick Salami commented on HIVE-287: - confirmed: happened to me as well; anyone have any

[jira] Commented: (HIVE-287) count distinct on multiple columns does not work

2009-03-10 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12680731#action_12680731 ] Raghotham Murthy commented on HIVE-287: --- results in a compiler error: FAILED: Error in