title: how to delete the content of a temporary table in SAP HANA?
body: <p>I create a temp table in SAP HANA this way: </p>
  
  <pre><code>  create local temporary table #sometable(table definition);
  </code></pre>
  
  <p>however, the delete statement is not supported on this table. i.e calling: </p>
  
  <pre><code> delete from #sometable; 
  </code></pre>
  
  <p>will throw an error: </p>
  
  <pre><code> feature not supported
  </code></pre>
  
  <p>When using this table within a stored procedure, the content is concatenated with the new data instead of being replaced with it. How can I resolve this issue? </p>