如何在impala中使用distinct

mcvgt66p 于 2021-05-29 发布在 Hadoop

关注(0)|答案(1)|浏览(537)

嗨，我想在我的表中查询不同的位置。
这是我的问题。

select distinct city,locality, avg_sqft from real_estate.re_search where city = 'bangalore'  AND locality != 'jayanagar';

结果

+-----------+--------------+----------+
| city      | locality     | avg_sqft |
+-----------+--------------+----------+
| bangalore | bannerghatta | 13500    |
| bangalore | kormangala   | 18000    |
| bangalore | kodipur      | 7000     |
| bangalore | kormangala   | 16000    |
| bangalore | horamavu     | 9000     |
| bangalore | bellandur    | 15500    |
| bangalore | kodipur      | 9000     |
| bangalore | madivala     | 12000    |
| bangalore | varthur      | 12000    |
| bangalore | kormangala | 13500    |
| bangalore | bellandur    | 13000    |
| bangalore | kodipur      | 11500    |
| bangalore | kormangala   | 14000    |

问题是我需要在结果中显示不同的位置。任何帮助都将不胜感激。

sql hadoop Hive impala bigdata

来源：https://stackoverflow.com/questions/34893240/how-to-use-distinct-in-impala

1条答案

按热度按时间

wa7juj8i1#

您应该能够通过使用 COUNT 以及 GROUP BY 操作员：

SELECT city
      ,locality
      ,COUNT(locality)
FROM database.table
WHERE city = 'Bangalore'
GROUP BY city
        ,locality;

赞(0）回复(0）举报 2021-05-30

我来回答

如何在impala中使用distinct

1条答案

相关问题

热门标签

最新问答