在直线中使用蜂巢时使用简单select查询我想返回表without列名中的表名作为默认值。

Example

Data

以一个简单的表格为例（教程点） https://www.tutorialspoint.com/hive/hive_create_table.htm:

CREATE TABLE IF NOT EXISTS employee ( eid int, name String,
salary String, destination String)
COMMENT 'Employee details'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

The SELECT查询返回：

SELECT * FROM employee;
+---------------+----------------+------------------+-----------------------+--+
| employee.eid  | employee.name  | employee.salary  | employee.destination  |
+---------------+----------------+------------------+-----------------------+--+
+---------------+----------------+------------------+-----------------------+--+

期望的结果

使用以下方法可以达到预期的结果AS:

SELECT eid AS eid, name AS name, salary AS salary, 
       destination AS destination FROM employee;

+------+-------+---------+--------------+--+
| eid  | name  | salary  | destination  |
+------+-------+---------+--------------+--+
+------+-------+---------+--------------+--+

Problem

我想避免打字AS每次我跑步select默认行为是查询并返回列名中没有表名的结果。

set hive.resultset.use.unique.column.names=false

配置属性 https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties

Demo

hive> create table t (i int,j int,k int);
hive> select * from t;

t.i t.j t.k

hive> set hive.resultset.use.unique.column.names=false;
hive> select * from t;

i   j   k