[
https://issues.apache.org/jira/browse/HIVE-287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12720900#action_12720900
]
Patrick Salami commented on HIVE-287:
-------------------------------------
Thanks for the reply! However, I get a parse error when I try this query:
hive> select count(1) from (select product_url, name, count(1) from
raw_product group by product_url, name);
FAILED: Parse Error: line 0:-1 mismatched input '<EOF>' expecting
Identifier in group by expression
here is my schema:
hive> describe raw_product;
OK
id int
merchant_product_id int
network_id int
network_merchant_id int
name string
brand string
category_name string
sku string
product_url string
[...]
Thanks!
--Patrick
--
___________________________________
Patrick Salami | Senior Software Engineer
Extrabux, Inc | http://www.extrabux.com
patr...@extrabux.com | (858) 449-2241
> count distinct on multiple columns does not work
> ------------------------------------------------
>
> Key: HIVE-287
> URL: https://issues.apache.org/jira/browse/HIVE-287
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
>
> The following query does not work:
> select count(distinct col1, col2) from Tbl
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
