It worked Perfectly Venkat R... ... View more

That makes sense ... ... View more

🙂 Thanks a bunch. That single Quote is a big miss on my part and I'm checking all other big ones :). I removed that single quite and also make sure Bucketed column is not in my delete where condition statement - then it worked as expected. So here are 2 questions. For all Updates, the limitation is Bucketed column should not be in UPDATE where condition. Why even small transaction Updates and Deletes are taking lot of time. Infact, total Transaction Table itself is running slow. Thanks a lot for your timely response. ... View more

🙂 Thanks a bunch. That single Quote is a big miss on my part and I'm checking all other big ones :). I removed that single quote and also make sure Bucketed column is not in my update SET condition statement - then it worked as expected. So here are 2 questions. For all Updates, the limitation is Bucketed column should not be in UPDATE's SET condition. Why even small transaction Updates and Deletes are taking lot of time. Infact, total Transaction Table itself is running slow. Thanks a lot for your timely response. ... View more

Thanks Eugene for Quick Response. Yes, DbTxnManager is set(Sorry, I missed that in original post). Yes, Select from XYZ is working fine. FYI, when I do simple 2/3 recordings for DELETE and Updatete with my own insert ACID is working. But I created the XYZ_OLD from a csv file for actual real time testing. describe formated XYZ; Details are below... ------------------------------------- # Detailed Table Information Database: default Owner: raj_ops CreateTime: Mon Jan 16 08:21:09 UTC 2017 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Location: hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/XYZ Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE{\"BASIC_STATS\":\"true\"} numFiles 8 numRows 1000 rawDataSize 1563286 totalSize 44374 transactional' true transient_lastDdlTime1484557025 # Storage Information SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat Compressed: No Num Buckets: 8 Bucket Columns: [state] Sort Columns: [] Storage Desc Params: serialization.format1 Time taken: 0.137 seconds, Fetched: 49 row(s) ... View more