hive 常见set字段1

use adst;
set mapreduce.job.queuename=${hiveconf:mp_queue};
set mapreduce.reduce.java.opts=-=-Xmx10000m;
set mapred.reduce.tasks=5;
set mapred.min.split.size.per.node=3200000;
set mapred.min.split.size.per.rack=3200000;
set mapred.max.split.size=25600000;
set hive.auto.convert.join=true;
set hive.groupby.skewindata=true;
set hive.mapjoin.smalltable.filesize=25000000;
set hive.map.aggr=true;
set hive.exec.orc.default.stripe.size=268435456;
set hive.exec.max.dynamic.partitions=100000;
set hive.exec.max.dynamic.partitions.pernode=100000;
set hive.exec.parallel=true;
set hive.exec.parallel.thread.number=10;
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.reducers.bytes.per.reducer=107374182;
set orc.compress.size=4096;

1. Hive 中select除了某些字段之外的剩余所有字段

-- 选择tableName表中除了name、id、pwd之外的所有字段
set hive.support.quoted.identifiers=None;
select `(name|id|pwd)?+.+` from tableName;

2. 显示表头

set hive.cli.print.header=true;
-- 显示表头且字段不带表名（非table.id格式）
set  hive.resultset.use.unique.column.names=false;