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

fail to drop table after upgrade to hive 0.14.0

2015-02-22 Thread Jie Zhang
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 metastore, failing to drop table. Here are the exception stack trace. Does anyone have clue what the problem can be and how to resolve it? Feedback is r