Re: fail to drop table after upgrade to hive 0.14.0

2015-02-23 Thread Srinivas Thunga
hi, Table should be created as orc table like create table HiveTest (eid int,ename string,desig string,sal int,dept string) clustered by (dept) into 3 buckets stored as orc TBLPROPERTIES ('transactional'='true') ; *Thanks & Regards,* *Srinivas T* On Tue, Feb 24, 2015 at 9:47 AM, Srinivas Thun

Re: fail to drop table after upgrade to hive 0.14.0

2015-02-23 Thread Srinivas Thunga
Hi, Below are new properties to be set in Hive-Site.xml hive.support.concurrency – true hive.enforce.bucketing – true hive.exec.dynamic.partition.mode – nonstrict hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager hive.compactor.initiator.on – true hive.compactor.worker.threa

Re: fail to drop table after upgrade to hive 0.14.0

2015-02-23 Thread Jessica Zhang
Thanks for the reply! Would you please elaborate which new properties for hive 0.14? Jessica > On Feb 23, 2015, at 1:03 AM, Srinivas Thunga > wrote: > > Apply new configuration properties for hive0.14 in hive-site.xml file then > drop or delete table > >> On Monday, February 23, 2015, Jie Z

Re: fail to drop table after upgrade to hive 0.14.0

2015-02-23 Thread Srinivas Thunga
Apply new configuration properties for hive0.14 in hive-site.xml file then drop or delete table On Monday, February 23, 2015, Jie Zhang wrote: > Hi, > > I have an application using hive, and just upgraded from 0.13.1 to 0.14.0. > However, a bunch of unit testcases, which are using embedded derby