How to select particular column In a table in hive

0 votes

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;
Jul 31, 2019 in Big Data Hadoop by Sejal
10,241 views

1 answer to this question.

0 votes

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;
answered Jul 31, 2019 by Killian

Related Questions In Big Data Hadoop

0 votes
1 answer

How to add a column in Hive table?

Hi@akhtar, You can use the alter table command ...READ MORE

answered Oct 19, 2020 in Big Data Hadoop by MD
• 95,460 points
1,894 views
0 votes
1 answer

How to create a Hive table from sequence file stored in HDFS?

There are two SerDe for SequenceFile as ...READ MORE

answered Dec 18, 2018 in Big Data Hadoop by Omkar
• 69,220 points
4,977 views
0 votes
1 answer

How to create a parquet table in hive and store data in it from a hive table?

Please use the code attached below for ...READ MORE

answered Jan 28, 2019 in Big Data Hadoop by Omkar
• 69,220 points
18,646 views
0 votes
2 answers

How to change the location of a table in hive?

Changing location requires 2 steps: 1.) Change location ...READ MORE

answered Feb 12, 2020 in Big Data Hadoop by Saksham Sehrawet
9,047 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
11,007 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,518 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,693 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
4,601 views
0 votes
1 answer

How to add column inside a table in Hive?

Hi, Yes, we can add column inside a ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Gitika
• 65,770 points
54,267 views
0 votes
1 answer

How to create a managed table in Hive?

You can use this command: create table employee(Name ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 69,220 points
5,372 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP