89307/how-to-add-a-column-in-hive-table
Hi Team,
I have created a Hive table. I want to add a new column to the table. How can I do that?
Hi@akhtar,
You can use the alter table command to add a new column to the hive table. This command can alter your table according to your requirement as shown below.
$ ALTER TABLE employee ADD COLUMNS (dept STRING COMMENT 'Department name');
Hi, Yes, we can add column inside a ...READ MORE
Hive is a high-level language to analyze ...READ MORE
You can use this command: create table employee(Name ...READ MORE
There are two SerDe for SequenceFile as ...READ MORE
It stores metadata for Hive tables (like their schema ...READ MORE
Hey, Hive chooses respective database servers to store ...READ MORE
Hey, Yes, it is correct that Hive is ...READ MORE
I use this code to get the ...READ MORE
Hi@akhtar, You can list down all the partitions ...READ MORE
Hi, You can use ToDate() and SubtractDuration() function ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.