title: "Response too large to return" even with --allow_large_results
body: <p>Sometimes after many successful processing of 1 million rows dataset, I got “Response too large to return” error message. Same message was thrown when I tried 2 million rows datasets. Is there a limit for transaction size?</p>
  
  <p>Error message:
  BigQuery error in query operation: Error processing job '...': Response too large to return.</p>
  
  <p>Query submitted:
  bq --project_id=... query --destination_table ... --append_table --use_cache --allow_large_results   "select  ...   from ...  limit 1000000"</p>