How to skip the malformatted records while loading data

Hi,everyone, Is there an option to ignore malformatted records while loading data into hive table? Or an option to ignore bad rows while querying data? For instance: 1. Specify a row format explicitly for a new table. hivecreate table tb (id int, pref string, zip string) row format delimited

How to skip the malformatted records while loading data

Hi,everyone, Is there an option to ignore malformatted records while loading data into hive table? Or an option to ignore bad rows while querying data? For instance: 1. Specify a row format explicitly for a new table. hivecreate table tb (id int, pref string, zip string) row format delimited