Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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?
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB