蜂巢：SELECT AS和GROUP BY

Question

我有一个蜂房查询像

SELECT Year, Month, Day, Hours, Minutes, 
      cast((cast(Seconds as int)/15) as int)*15 
AS secondMod, Count(*) AS PerCount FROM LoggerTable 
GROUP BY Year, Month, Day, Hours, Minutes, secondMod 
ORDER BY PerCount; 

上述查询失败，错误

FAILED: Error in semantic analysis: line 1:175 Invalid Table Alias or Column Reference secondMod

“LoggerTable”是一个蜂巢表与字符串类型的所有列。

任何办法解决这个问题？

Answer 1

尝试这种情况：

SELECT Year, Month, Day, Hours, Minutes, 
cast((cast(Seconds as int)/15) as int)*15 
AS secondMod, Count(*) AS PerCount FROM LoggerTable 
GROUP BY Year, Month, Day, Hours, Minutes, 
    cast((cast(Seconds as int)/15) as int)*15 
ORDER BY PerCount; 

Answer 2

在蜂房0.11.0和以后，列可以由位置指定如果hive.groupby.orderby.position.alias设置为true。 请确认以下查询是否适合您。

SET hive.groupby.orderby.position.alias=true; 
SELECT Year 
     ,Month 
     ,Day 
     ,Hours 
     ,Minutes 
     ,cast((cast(Seconds as int)/15) as int)*15 AS secondMod 
     ,count(*) AS PerCount 
FROM LoggerTable 
GROUP BY 1, 2, 3, 4, 5, 6 
ORDER BY 7;