Virtual Columns in Hive

Reference from: Https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VirtualColumns

Directly available in hive. Input__file__name

Input file block__offset__inside__file in Maptask

Record the offset scenario in the file

Find the file location and offset of the record

Select Line  , Input__file__name, Block__offset__inside__file
from  temp_test_vitural_column
where Line like '%df5f5388967697a6% ';  

Results:
20170823230242/home/test/filter_result/combinelog_merge_filter_uniq/tmp_test/20170823/part-m-07635 12183296
20170823230242/home/test/filter_result/combinelog_merge_filter_uniq/tmp_test/20170823/part-m-07634 12183278