How can a partition be added on the date column in Hive?

Asked by Last Modified  

1 Answer

Learn Hadoop

Follow 1
Answer

Please enter your answer

Abhilash

up vote 22 down vote accepted First start with the right table definition. In your case I'll just use what you wrote: CREATE EXTERNAL TABLE test ( foo string, time string, bar string ) PARTITIONED BY (dt string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LOCATION 's3://test.com/'; Hive...
read more
up vote 22 down vote accepted First start with the right table definition. In your case I'll just use what you wrote: CREATE EXTERNAL TABLE test ( foo string, time string, bar string ) PARTITIONED BY (dt string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LOCATION 's3://test.com/'; Hive by default expects partitions to be in subdirectories named via the convention s3://test.com/partitionkey=partitionvalue. For example s3://test.com/dt=2014-03-05 If you follow this convention you can use MSCK to add all partitions. If you can't or don't want to use this naming convention, you will need to add all partitions as in: ALTER TABLE test ADD PARTITION (dt='2014-03-05') location 's3://test.com/2014-03-05' read less
Comments
Dislike Bookmark

Related Questions

I want to pursue career in Data Analyst i.e. Hadoop, currently working in testing professional from last 4 year. Please let me know what�s the opportunity and is my work experience is considerable in Hadoop. Also let me know what need to be prepare for that. Please guide me. Thanks in advance.
Sachin, YEs your work experience will consider as total IT experience. But you need to prepare BigData Hadoop analytic from scratch(start-to end). That means you need to know Hadoop as BigData Hadoop developer...
Sachin
Hi I am looking for Storm Trident support for my job, is this the right place to look for?
Yes
Sowjanya
0 0
9
Do I need to learn the Java-Hibernate framework to be a Hadoop developer?
Not At All . To be Hadoop Developer , you need the knowledge of basic core Java programming along with SQL . No one will ask any question in interview on hibernate .
Pritam
0 0
6
Which is easy to learn for a fresher Hadoop or cloud computing?
Hadoop is completely easy . You can learn Hadoop along with other ecosystem also . If you need any support then feel free contact me on this . i can help you to lean Hadoop in very simple manner .
Praveen
0 0
5

What is difference between data science and SAP. Which is best in compare for getting jobs as fast as possible
Hi Both have different uniquness with importance value. you will get a good prospectives on SAP for career growth.
Ravindra

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Python Programming or R- Programming
Most of the students usually ask me this question before they join the classes, whether to go with Python or R. Here is my short analysis on this very common topic. If you have interest/or having a job...

Jatin Miglani

2 0
0
Solving the issue of Namenode not starting during Single Node Hadoop installation
On firing jps command, if you see that name node is not running during single node hadoop installation , then here are the steps to get Name Node running Problem: namenode not getting started Solution:...
B

Biswanath Banerjee

1 0
0
Why is the Hadoop essential?
Capacity to store and process large measures of any information, rapidly. With information volumes and assortments always expanding, particularly from web-based life and the Internet of Things (IoT), that...

Bright Computer Education

1 0
0
How can you recover from a NameNode failure in Hadoop cluster?
How can you recover from a Namenode failure in Hadoop?Why is Namenode so important?Namenode is the most important Hadoop service. It contains the location of all blocks in the cluster. It maintains the...
B

Biswanath Banerjee

0 0
0
CheckPointing Process - Hadoop
CHECK POINTING Checkpointing process is one of the vital concept/activity under Hadoop. The Name node stores the metadata information in its hard disk. We all know that metadata is the heart core...

Silvia P.

0 0
0

Recommended Articles

Some Popular IT Courses in Current Market

In the domain of Information Technology, there is always a lot to learn and implement. However, some technologies have a relatively higher demand than the rest of the others. So here are some popular IT courses for the present and upcoming future: Cloud Computing Cloud Computing is a computing technique which is used...

Read full article >

Why Should you Become a Data Scientist

We have already discussed why and how “Big Data” is all set to revolutionize our lives, professions and the way we communicate. Data is growing by leaps and bounds. The Walmart database handles over 2.6 petabytes of massive data from several million customer transactions every hour. Facebook database, similarly handles...

Read full article >

Growth and Career Prospects in Big Data

Big data is a phrase which is used to describe a very large amount of structured (or unstructured) data. This data is so “big” that it gets problematic to be handled using conventional database techniques and software.  A Big Data Scientist is a business employee who is responsible for handling and statistically evaluating...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find Hadoop near you
Hadoop in Hyderabad

Looking for Hadoop ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you