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
Thiruvel Thirumoolan 2010-09-20, 10:17
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?
>
>