title: hive beeline use ACID transaction manager
body: <p>I'm trying to run this command using beeline. </p>
  
  <pre><code>create table &lt;table_1&gt; like &lt;table_2&gt;
  </code></pre>
  
  <p>but it appears my Hive is configured to run in ACID mode. So this query fails with </p>
  
  <blockquote>
    <p>Error: Error while compiling statement: FAILED: SemanticException
    [Error 10265]: This command is not allowed on an ACID table 
    with a non-ACID transaction manager. Failed command: create table
     like  (state=42000,code=10265)</p>
  </blockquote>
  
  <p>What's correct syntax to run beeline query using ACID transaction manager without changing any global configuration ? </p>
  
  <p>my beeline command is :</p>
  
  <pre><code>beeline -u &lt;jdbc_con&gt; -e "create table &lt;table_1&gt; like &lt;table_2&gt;";
  </code></pre>
  
  <p>I suppose I should use something like </p>
  
  <pre><code>hive&gt;set hive.support.concurrency = true;
  hive&gt;set hive.enforce.bucketing = true;
  hive&gt;set hive.exec.dynamic.partition.mode = nonstrict;
  hive&gt;set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
  hive&gt;set hive.compactor.initiator.on = true;
  hive&gt;set hive.compactor.worker.threads = a positive number on at least one instance of the Thrift metastore service;
  </code></pre>
  
  <p>But how should I include this into beeline ? 
  When I tried </p>
  
  <pre><code>beeline -u $jdbc_con -e "set hive.support.concurrency = true; create table &lt;table_1&gt;_test like &lt;table_2&gt;";
  </code></pre>
  
  <p>It seems it's not possible to change theses parameter this way.</p>
  
  <blockquote>
    <p>Error: Error while processing statement: Cannot modify
    hive.support.concurrency at runtime. It is not in list of params that
    are allowed to be modified at runtime (state=42000,code=1)</p>
  </blockquote>
  
  <p>Thank you for any help. </p>