title: Hadoop Count Query -
body: <p>New to Hadoop, trying to summarize records for a project.  </p>
  
  <pre><code>select ops, ops_desc, count (*)from scm_cso_me.dailyparameters122117
  Group by ops_desc
  where oh in (0);
  </code></pre>
  
  <p>I receive the following error:  </p>
  
  <blockquote>
    <p>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'</p>
  </blockquote>
  
  <p>The code has several lines -- out.  </p>
  
  <p>Assistance is much appreciated!!</p>