Hi, I had execute "ALTER TABLE tablename ADD COLUMNS (newcolumns STRING)" to add column, before i add this column, got 4 columns, the new column will after the 4th column, and before partition column, and now the new data in hdfs was exist in the 5th columns, but i execute "SELECT * FROM tablename", the newcolumns is empty.
Means i cat the file in hdfs is exist data, but how come the newcolumns is empty? Regards, Singo