title: Cannot insert data in virtual table (HIVE) from SAP HANA
body: <p>I have a Hive table (visible from HBase) in a Hadoop system and ODBC from Hortonworks installed in SAP HANA server. Then, I Have a SAP HANA Studio Remote Source from where I can see the Hive tables. The Remote Source definition appears in the following image:</p>
  
  <p><img src="https://i.stack.imgur.com/vMVjC.png" alt="enter image description here"></p>
  
  <p>The DML Mode is "readwrite"</p>
  
  <p>I create a bicing_test virtual table. Then, I can to run Select queries to this virtual table, but cannot run Insert/Update Queries:</p>
  
  <p><img src="https://i.stack.imgur.com/8mNk4.png" alt="enter image description "></p>
  
  <p>The log error is de following:</p>
  
  <pre><code>Could not execute 'insert into "BICING_USER"."HIVE_bicing_test" values (3)' SAP DBTech JDBC: [7]: feature not supported: datasource doesn't support insert statement: line 1 col 27 (at pos 26)
  </code></pre>
  
  <p>Is it possible to run Insert queries in a virtual table?</p>
  
  <p>Thanks for the support.</p>