hive:select all column exclude two

How to select all column exclude columns ‘date’ and ‘cst_id’ in hive?

Answer

Try below –

For single session – set hive.support.quoted.identifiers=none;

select `(date|cst_id)?+.+` from myTable.

refer quotedIdentifiers for more information on hive select using regular expressions