cannot recognize input near in hive
<pre><code>select household,COUNT(*),(COUNT(*))/(select COUNT(*) from finalcampaign) *100 as Higndecimal from finalcampaign group by household;
</code></pre>

<blockquote>
  <p>FAILED: ParseException line 1:37 cannot recognize input near 'select' 'COUNT' '(' in expression specification</p>
</blockquote>