hadoop - Hadoop计数查询-

Question

Hadoop的新增功能，试图汇总项目的记录。

select ops, ops_desc, count (*)from scm_cso_me.dailyparameters122117
Group by ops_desc
where oh in (0);

我收到以下错误:

java.lang.Exception: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 23:0 missing EOF at 'where' near 'ops_desc'

该代码有几行-出。

非常感谢协助!!

Answer 1

将我的评论变成答案:

问题是您需要按ops和ops_desc分组。您还可以使用not null消除字段值为null的记录。

select ops,
       ops_desc,
       count (*)
  from scm_cso_me.dailyparameters122117
group by ops, ops_desc
where oh in (0)
  and cso_active_indicator is not null;