title: Hive Bucketed Tables enabled for Transactions
body: <p>So we are trying to create a Hive table with ORC format bucketed and enabled for transactions using the below statement</p>
  
  <pre><code>create table orctablecheck ( id int,name string) clustered by (sno) into 3  buckets stored as orc TBLPROPERTIES ( 'transactional'='true')
  </code></pre>
  
  <p>The table is getting created in Hive and also Reflects in Beeline both in the Metastore as well as Spark SQL(which we have configured to run on top of Hive JDBC)</p>
  
  <p>We are now inserting data into this table via Hive. However we see after insertion the data doesnt reflect in Spark SQL. It only reflects correctly in Hive.</p>
  
  <p>The table only shows the data in the table if we restart the Thrift Server.</p>