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