查询HIve表"data_entity_id", "data_time", "ia", "ib", "ic"这些字段，并且指定 "ia", "ib", "ic"不为空，不为0的sql语句

以下是查询Hive表中指定字段并且指定字段不为空、不为0的SQL语句：

SELECT data_entity_id, data_time, ia, ib, ic
FROM database.table_name
WHERE ia IS NOT NULL AND ia <> 0
  AND ib IS NOT NULL AND ib <> 0
  AND ic IS NOT NULL AND ic <> 0;