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