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 2009/05/01 23:49:35 UTC
[Hadoop Wiki] Update of "Hive/LanguageManual/Select" by ZhengShao
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 ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/Select
------------------------------------------------------------------------------
SELECT * FROM sales SORT BY amount DESC LIMIT 5
}}}
+ * A SELECT statement can take regex-based column specification.
+ * We use java regex syntax. Try http://www.fileformat.info/tool/regex.htm for testing purposes.
+ * The following query select all columns except ds and hr.
+ {{{
+ SELECT `(ds|hr)?+.+` FROM sales
+ }}}
+