Member since
11-02-2021
182
Posts
1
Kudos Received
0
Solutions
08-05-2026
06:59 AM
@mohammad_shamim For copying ACID tables from one cluster to another you can use import and export commands .Below are the steps in detail 1)On source cluster create new table using create-table-as-select on source acid table. create table src_table as select * from src_acid_table; 2)Then run export on src_table. export table src_table to '/data/src_table_export' 3)Copy the directory /data/src_table_export to destination cluster 4)Run import on destination cluster as below once data is copied. import table dst_table from '/data/src_table_export' 5)Create new acid table same as source and then insert the data as below: insert into table dst_acid_table select * from dst_table; Verify that data on both source and target table were consistent by taking count of rows.
... View more