Home > database >  Hive data import
Hive data import

Time:09-23


Hive, will be imported into the storage of data in the temporary table format for orc target table, found in the target table data block size was 256 m? Why is this excuse me? Did not change the default of HDFS 128 m block size

Insert the overwrite table test_orc select * from test_ori;

But after data import, data content on HDFS is compressed, but data block size was 256 m, the temporary table still retain,

Will analysis, because the import data from the temporary table target table, the data with the target table mapping relationship is established, due to the temporary table with the data have a layer of mapping (metadata stored in the mysql), isn't changed the goal because the file is in the table the default block size? Think impassability, ask for advice,,
  • Related