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 2008/12/08 23:06:40 UTC
[Hadoop Wiki] Update of "Hive/HiveQL" by RaghothamMurthy
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by RaghothamMurthy:
http://wiki.apache.org/hadoop/Hive/HiveQL
------------------------------------------------------------------------------
select_list: expression, expression, ...
table_source
- : table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] [alias]
+ : table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] [table_sample] [alias]
| ( select_statement ) alias
}}}
@@ -170, +170 @@
=== Sampling ===
{{{
- table_sample: TABLESAMPLE (BUCKET number OUT OF number)
+ table_sample: TABLESAMPLE (BUCKET number OUT OF number ON colname)
}}}
=== Union ===
{{{