只需要设置参数
set hive.support.quoted.identifiers=None;
指定要剔除哪个字段
select (剔除的字段)? .
from table
示例:
选择tableName表中除了name、id、pwd之外的所有字段:
set hive.support.quoted.identifiers=None;
select (name|id|pwd)? .
from tableName;
选择tableName表中除了ds之外的所有字段:
set hive.support.quoted.identifiers=None;
select (ds)? .
from tableName;