How to select particular column In a table in hive

Question

I tried this code but it didn't work:

Table name:Orders

Schema:retail_db

SET hive.support.quoted.identifiers=none; 

SET hive.cli.print.header=true;

SELECT "(order_status)?+.+" FROM orders limit 5;

Answer 1

Hive is a high-level language to analyze large volumes of data. The easiest way to select specific columns in the Hive query is by specifying the column name in the select statement.

SELECT col1, col3, col4 ....
FROM Table1;

But imagine your table contains many columns (i.e : more than 100 columns) and you need to only exclude a few columns in the select statement. Therefore, Hive query should be able to select all the columns excluding the defined columns in the query. To achieve it you need to follow these steps.

In ‘hive-site.xml’ add the following configuration

hive.support.quoted.identifiers=none​

and execute the query as

SELECT `(extract_date)?+.+` FROM <TABLE_NAME>;
with appropriate column and table name.

If you need to exclude only ‘transaction_date’ column in a select statement from a ‘cart’ table. Then the query will be,

SELECT `( transaction_date)?+.+`
FROM cart;