Hi, A quick help on below issue would be much helpful.
We have a Hive managed table (say TableA) which was initially enabled with ACID property and later decided to disable (Alter Table set tblproperties ('transactional'='false')). For a business case, we have to copy all the records from TableA to TableB (Bucketed as TableA but not enabled for ACID).
The error says "Was expecting '<hdfs path for hive table>' to be bucket file." The need to have such query as Option2 is, we use Informatica Developer which would internally trigger HQL as mentioned in Option2.
Any help is appreciated.
Non-partitioned. Just bucketed so as to initially enable ACID. Both TableA and TableB are of similar structure. The only difference I see is TableA has TBLPROPERTIES (transactional = false) where TableB did not. I tried to alter TableB by setting the transactional as false so as to have both table's properties in-sync, still the same error.
Have transactional property of both the tables to true and then try inserting from table B to Table A. It should work.
I cannot do that at this point since we rolled back ACID property due to one of the limitation we have with Informatica Developer on ACID enabled tables. Thanks.
I did similar exercise on a test table and once after enabling ACID on both tables, am able to backup all records. But I cannot have this is as a solution due to the complexity we have with Informatica Developer.