It should be INPUT__FILE__NAME and BLOCK__OFFSET__INSIDE__FILE. On Sep 20, 2010, at 3:15 PM, lei liu wrote:
> I use hive0.6 version and execute 'select INPUT_FILE_NAME, > BLOCK_OFFSET_INSIDE_FILE from person1' statement, hive0.6 throws below error: > FAILED: Error in semantic analysis: line 1:7 Invalid Table Alias or Column > Reference INPUT_FILE_NAME error. > > Don't hive0.6 support virtual columns? > >