Hi, The input/output formats do not appear to be ORC, have you tried 'stored as orc'? Additionally you'll need to set the property 'transactional=true' on the table. Do you have the original create table statement?
Cheers - Elliot. On Tuesday, 22 December 2015, Mich Talebzadeh <m...@peridale.co.uk> wrote: > Hi, > > > > I am trying this code on table tt defined as an ORC table > > > > 0: jdbc:hive2://rhes564:10010/default> show create table tt; > > +-----------------------------------------------------------------+--+ > > | createtab_stmt | > > +-----------------------------------------------------------------+--+ > > | CREATE TABLE `tt`( | > > | `owner` varchar(30), | > > | `object_name` varchar(30), | > > | `subobject_name` varchar(30), | > > | `object_id` bigint, | > > | `data_object_id` bigint, | > > | `object_type` varchar(19), | > > | `created` timestamp, | > > | `last_ddl_time` timestamp, | > > | `timestamp2` varchar(19), | > > | `status` varchar(7), | > > | `temporary2` varchar(1), | > > | `generated` varchar(1), | > > | `secondary` varchar(1), | > > | `namespace` bigint, | > > | `edition_name` varchar(30), | > > | `padding1` varchar(4000), | > > | `padding2` varchar(3500), | > > | `attribute` varchar(32), | > > | `op_type` int, | > > | `op_time` timestamp, | > > | `new_col` varchar(30)) | > > | ROW FORMAT SERDE | > > | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | > > | STORED AS INPUTFORMAT | > > | 'org.apache.hadoop.mapred.TextInputFormat' | > > | OUTPUTFORMAT | > > | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | > > | LOCATION | > > | 'hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/tt' | > > | TBLPROPERTIES ( | > > | 'COLUMN_STATS_ACCURATE'='true', | > > | 'numFiles'='546', | > > | 'numRows'='8299588', | > > | 'rawDataSize'='18611443520', | > > | 'totalSize'='18619743108', | > > | 'transient_lastDdlTime'='1450337155') | > > +-----------------------------------------------------------------+--+ > > > > The following delete statement: > > > > delete from tt where exists(select 1 from t where tt.object_id = > t.object_id); > > Error: Error while compiling statement: FAILED: SemanticException [Error > 10294]: Attempt to do update or delete using transaction manager that does > not support these operations. (state=42000,code=10294) > > > > > > > > Mich Talebzadeh > > > > *Sybase ASE 15 Gold Medal Award 2008* > > A Winning Strategy: Running the most Critical Financial Data on ASE 15 > > > http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf > > Author of the books* "A Practitioner’s Guide to Upgrading to Sybase ASE > 15", ISBN 978-0-9563693-0-7*. > > co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN > 978-0-9759693-0-4* > > *Publications due shortly:* > > *Complex Event Processing in Heterogeneous Environments*, ISBN: > 978-0-9563693-3-8 > > *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, volume > one out shortly > > > > http://talebzadehmich.wordpress.com > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Technology > Ltd, its subsidiaries or their employees, unless expressly so stated. It is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its subsidiaries nor their employees > accept any responsibility. > > >
