question Whether Hive supports Hive Select All Query with Except Columns, like SQL supports?? in Archives of Support Questions (Read Only)

Whether Hive supports Hive Select All Query with Except Columns, like SQL supports??

colorsoflife — Wed, 23 Dec 2015 01:49:16 GMT

Whether Hive supports Hive Select All Query with Except Columns, like SQL supports. E.g. in SQL if I want tioexclude few columns, i can do by writing in except e.g. SELECT * [except Injury,Detailed_Body_Part, Detailed_Injury_Type] FROM Claim_Grouped). Is the same thing Hive supports??

Re: Whether Hive supports Hive Select All Query with Except Columns, like SQL supports??

agillan — Wed, 23 Dec 2015 01:56:25 GMT

According to this Hive Language documentation, you can achieve the same thing using regular expressions:

A SELECT statement can take regex-based column specification in Hive releases prior to 0.13.0, or in 0.13.0 and later releases if the configuration property hive.support.quoted.identifiers is set to none.

* We use Java regex syntax. Try http://www.fileformat.info/tool/regex.htm for testing purposes.

* The following query selects all columns except ds and hr.

SELECT `(ds|hr)?+.+` FROM sales

Re: Whether Hive supports Hive Select All Query with Except Columns, like SQL supports??

colorsoflife — Wed, 23 Dec 2015 02:36:20 GMT

@ Ana Gilan, Thanks, it works.

Re: Whether Hive supports Hive Select All Query with Except Columns, like SQL supports??

pratikmbm1122 — Mon, 17 Apr 2017 23:42:16 GMT

Could you please elaborate how this regex works ?