Problems with Hive (need to make a fix)

[ibobak]

HiveDialect.java needs a fix: requiresOrderByAlias() and allowsOrderByAlias() should both return false (instead of true).

Mondrian generated a code for me that did the following:

select time_by_day.the_year as c0 from time_by_day time_by_day group by time_by_day.the_year order by ISNULL(c0) ASC, c0

And this is wrong, because you cannot have c0 inside the "order by" - Hive doesn't support it. As soon as I fixed it, everything started to work fine.

[ibobak]

By the way, I am making a connection from Excel -> Mondrian -> Spark SQL. And I see more bugs. But I need to know if the author is interested in applying fixes.