官网地址:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VirtualColumns
1.功能
可以在查询结果中添加一列,显示hive文件位置或者偏移量
2.INPUT__FILE__NAME
(1)功能:代表这行数据在哪个文件中,这个文件的名称
(2)SQL语句以及结果:
0: jdbc:hive2://bigdata.ibeifeng.com:10000> select deptno ,dname ,INPUT__FILE__NAME from dept;
+---------+-------------+---------------------------------------------------------------------+--+
| deptno | dname | input__file__name |
+---------+-------------+---------------------------------------------------------------------+--+
| 10 | ACCOUNTING | hdfs://bigdata.ibeifeng.com:8020/user/hive/warehouse/dept/dept.txt |
| 20 | RESEARCH | hdfs://bigdata.ibeifeng.com:8020/user/hive/warehouse/dept/dept.txt |
| 30 | SALES | hdfs://bigdata.ibeifeng.com:8020/user/hive/warehouse/dept/dept.txt |
| 40 | OPERATIONS | hdfs://bigdata.ibeifeng.com:8020/user/hive/warehouse/dept/dept.txt |
+---------+-------------+---------------------------------------------------------------------+--+
3.BLOCK__OFFSET__INSIDE__FILE
(1)功能:偏移量的值,是当前全局的位置。
(2)SQL语句以及结果:
select deptno ,dname ,BLOCK__OFFSET__INSIDE__FILE from dept;