CODEWITHSUNDEEP
hive
Ajay
Ajay

Reputation: 3086

what happens when you load data into hive internal table?

what happens when you load data into hive internal table ? will the data be copied over from the existing location to a new location?

Upvotes: 0

Views: 51

Answers (1)

user3327034
user3327034

Reputation: 405

It won't be copied. During the time of the load, wherever the internal table is pointing to, data will be written there. It also depends on the insert statement - insert into vs insert overwrite.

check the location using

desc extended table <tablename>;

If you want to change the location, then do

alter table <Tablename> set location 'new location';

Upvotes: 1

Related Questions