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?
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
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,
On Mon, Sep 20, 2010 at 6:29 AM, lei liu liulei...@gmail.com wrote:
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__FILE__NAME, BLOCK__OFFSET__INSIDE__FILE
Both virtual column names use TWO underscores .
On Mon, Sep 20, 2010 at 9:26 AM, Edward Capriolo edlinuxg...@gmail.com wrote:
On Mon, Sep 20, 2010 at 6:29 AM, lei liu liulei...@gmail.com wrote:
I use INPUT_FILENAME and BLOCKOFFSETINSIDE_FILE, but
http://wiki.apache.org/hadoop/Hive/LanguageManual/VirtualColumns
On Mon, Sep 20, 2010 at 10:42 AM, yongqiang he heyongqiang...@gmail.com wrote:
INPUT__FILE__NAME, BLOCK__OFFSET__INSIDE__FILE
Both virtual column names use TWO underscores .
On Mon, Sep 20, 2010 at 9:26 AM, Edward Capriolo