title: Can bigquery tables be accessed through .hql file which will run on dataproc
body: <p>I am trying to access a <code>BigQuery</code> table from my <code>.hql</code> file that I will be running on a <code>Dataproc</code> cluster.
  I have written the code below to set the tables as variables in the <code>Hive</code> environment: </p>
  
  <pre><code>Set hivevar:source_table_name=project_id:dataset_name:table_name;
  
  Set hivevar:destination_table_name=project_id:datasetname:dest_tablename; 
  </code></pre>
  
  <p>Then I wrote a query to insert the output into the table present in <code>BigQuery</code>.  </p>
  
  <pre><code>Insert into ${destination_table_name} select count(*) from ${source_table_name} where name like 'A%';
  </code></pre>
  
  <p>After running the job from Dataproc I am getting an error "table not found". But the table is present in BigQuery dataset. </p>
  
  <p>Can someone please help in resolve the issue.</p>