I use INPUT_FILENAME and BLOCKOFFSETINSIDE_FILE, but there is same error. hive> select INPUT_FILENAME, BLOCKOFFSETINSIDE_FILE from person1; FAILED: Error in semantic analysis: line 1:7 Invalid Table Alias or Column Reference INPUT_FILENAME
2010/9/20 Thiruvel Thirumoolan <thiru...@yahoo-inc.com> > I dont think https://issues.apache.org/jira/browse/HIVE-417 which added > virtual columns was committed to 0.6. > > <https://issues.apache.org/jira/browse/HIVE-417> > On Sep 20, 2010, at 3:47 PM, Thiruvel Thirumoolan wrote: > > 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? > > > > > >
