title: Convert unsigned int to signed int through google BigQuery
body: <p>I tried to run a query on google BigQuery api and got an exception as follows:</p>
  
  <blockquote>
    <p>"Argument type mismatch in function IF: 'distinctPlayers' is type 'TYPE_UINT64', '0' is type 'TYPE_INT32'."</p>
  </blockquote>
  
  <p>The query is too big so I wrote only part of it where it fails.</p>
  
  <blockquote>
    <p>QUERY : sum(if(action_type == 3, distinctPlayers, 0)) as  Game_Viral_Acceptor_Count</p>
  </blockquote>
  
  <p>What I understood is: </p>
  
  <pre><code>if condition is true 
  then set distinctPlayers of type unsigned int64 
  otherwise set 0 which is of type int32
  </code></pre>
  
  <p>Can anyone throw some light on how to convert <code>unsigned int64</code> to <code>signed int</code> through <code>BigQuery</code>.</p>
  
  <p>Thanks in advance,
  Omkar</p>