You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2010/01/21 02:07:37 UTC

[Hadoop Wiki] Update of "Hive/LanguageManual/Select" by JohnSichi

Dear Wiki user,

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

The "Hive/LanguageManual/Select" page has been changed by JohnSichi.
http://wiki.apache.org/hadoop/Hive/LanguageManual/Select?action=diff&rev1=8&rev2=9

--------------------------------------------------

  [LIMIT number]
  }}}
   * A SELECT statement can be part of a [[Hive/LanguageManual/Union|union]] query or a [[Hive/LanguageManual/SubQueries|subquery]] of another query.
-  * table_reference indicates the input to the query. It can be a regular table, a [[Hive/LanguageManual/Joins|join construct]] or a [[Hive/LanguageManual/SubQueries|subquery]].
+  * table_reference indicates the input to the query. It can be a regular table, [[Hive/LanguageManual/DDL#Create_View|a view]], a [[Hive/LanguageManual/Joins|join construct]] or a [[Hive/LanguageManual/SubQueries|subquery]].
   * Simple query. For example, the following query retrieves all columns and all rows from table t1.
  {{{
  SELECT * FROM t1