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
+ }}}
+