Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Virtual Columns error


Copy link to this message
-
Re: Virtual Columns error
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?