hadoop - 仅在 Hive 中打印表头

Question

是否可以在没有表名前缀的情况下在 Hive 中打印表头？

我做了:set hive.cli.print.header=true;

然后:select * from brands limit 3;

结果是:

brands.id  brands.name brands.tag      brands.value
7     Brand      50      DeLorme
0     Brand      50      U-Line
27    Brand      50      Elcon

而真正想要得到的是:

id    name       tag      value
7     Brand      50      DeLorme
0     Brand      50      U-Line
27    Brand      50      Elcon

“brands”是我创建的表而不是主数据库表。

谢谢你的帮助，
妮娜

Answer 1

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

---

hive.resultset.use.unique.column.names

Default Value: true.
Added In: Hive 0.13.0 with HIVE-6687

Make column names unique in the result set by qualifying column names with table alias if needed. Table alias will be added to column names for queries of type "select *" or if query explicitly uses table alias "select r1.x..".

https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties