insert overwrite all into t1 into t1 (c1, c2, c3) values (n2, n1, default) into t2 (c1, c2, c3) into t2 values (n3, n2, n1) select n1, n2, n3 from src;