Versions Compared

Old Version 2

changes.mady.by.user Namit Jain

Saved on

compared with

New Version 3

changes.mady.by.user Namit Jain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

=External Tables=
Hive supports both partitioned and unpartitioned external tables. In both cases, when a new table/partition is being added, the location is also specified for the new table/partition. Let us consider a specific example:

create table T (key string, value string) partitioned by (ds string, hr string);
insert overwrite table T partition (ds='1', hr='1') ...;
..
insert overwrite table T partition (ds='1', hr='24') ...;

T is a partitioned table