hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/VirtualColumns" by HeYongqiang
Date Tue, 10 Aug 2010 21:20:26 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/LanguageManual/VirtualColumns" page has been changed by HeYongqiang.


New page:

== Virtual Columns ==

Right now hive can only support 2 simple virtual columns:

One is {{{INPUT__FILE__NAME}}}, which is the input file's name for a mapper task.

the other is {{{BLOCK__OFFSET__INSIDE__FILE}}}, which is the current global file position.

For block compressed file, it is the current block's file offset, which is the current block's
first byte's file offset.

=== Simple Examples ===

select {{{INPUT__FILE__NAME}}}, key, {{{BLOCK__OFFSET__INSIDE__FILE}}} from src;

select key, count({{{INPUT__FILE__NAME}}}) from src group by key order by key;

select * from src where {{{BLOCK__OFFSET__INSIDE__FILE}}} > 12000 order by key;

View raw message