Impala – Create Table AS Select * FROM Table – is SLOW
Below query seems like the simplest way to create a replica of table. But simplicity comes with some cost as well. Above query will : NOT create partitions if there are any on TABLE_NAME_2 run very slow Instead of above we should follow following 2 way approach : CREATE TABLE TABLE_NAME Like TABLE_NAME_2; — … Read more