Table Creation
1 2 3 4 | CREATE TABLE HomeNeeds(Type STRING, Product STRING, No INT)ROW FORMAT DELIMITEDFIELDS TERMINATED BY ','STORED AS TextFile; |
Insertion
1 2 | LOAD DATA LOCAL INPATH '/home/turbo/workspace/Sample Datas/Test.csv'OVERWRITE INTO TABLE HomeNeeds; |
Create Table with Partition
1 2 3 4 | CREATE TABLE HomeNeeds(Type String, Product String, No Int)PARTITIONED BY (Date String, Country String) ROW FORMAT DELIMITEDFIELDS TERMINATED BY ','; |
The Partitioned columns and Table columns have no Relations with one another
Inserting into Partitioned Table
1 2 3 | LOAD DATA LOCAL INPATH '/home/turbo/workspace/Sample Datas/Test.csv'INTO TABLE HomeNeedsPARTITION (Date='2001-01-25', Country='India'); |
Partition and Bucketing
1 2 3 4 5 | CREATE TABLE HomeNeeds(Type String, Item String, No Int)PARTITIONED BY (Area String)CLUSTERED BY (Type) INTO 4 BUCKETSROW FORMAT DELIMITEDFIELDS TERMINATED BY ','; |
1 |
1 |
1 |
1 |