I imported all tables from MySQL to HIVE using the snappy compression codec. Once the import was done, I issued the ‘describe formatted’ command for one of the tables imported and saw that compression is specified as ‘No’ in the storage information as below. However, I could see the part files of the table appended with ‘.snappy’ when I issue the ‘dfs -ls /apps/hive/warehouse/DB/TABLE’ command. Can someone please clarify?
SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe