Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Virtual Columns

Hive 0.8.0 provides support for two virtual columns:


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

Since Hive 0.8.0 the following virtual columns have been added:



  • ROW__ID


It is important to note, that all of the virtual columns listed here cannot be used for any other purpose (i.e. table creation with columns having a virtual column will fail with "SemanticException Error 10328: Invalid column name..")

Simple Examples

select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src;