Hadoop Hive查询-SQL

Question

我在 hive 中写了一个查询。它不起作用 查询：

hive>> select country ,max(total_count) from (select country, count(airlineid) from airport group by country) t2;

它显示了'country'的表达式组。

Answer 1

多个问题。如果格式化它，则应该可以看到它。

select
  country, -- you need to add this in group by after t2.
  max(total_count) -- you need to create/alias a column called total_count
from
  (
    select
      country,
      count(airlineid)
    from
      airport
    group by
      country
  ) t2;

固定SQL-

select
  country,  
  max(total_count) max_total_count
from
  (
    select
      country,
      count(airlineid)total_count
    from
      airport
    group by
      country
  ) t2
group by country
;