hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Salami (JIRA)" <>
Subject [jira] Commented: (HIVE-287) count distinct on multiple columns does not work
Date Wed, 17 Jun 2009 21:14:07 GMT


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;
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



Patrick Salami | Senior Software Engineer
Extrabux, Inc | | (858) 449-2241

> count distinct on multiple columns does not work
> ------------------------------------------------
>                 Key: HIVE-287
>                 URL:
>             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.

View raw message