blob: 9e67c2e2cbf3dd4fc75a2fb1b1ef6cf5a3150238 [file] [log] [blame]
set hive.mapred.mode=nonstrict;
DROP TABLE Employee_Part_n0;
CREATE TABLE Employee_Part_n0(employeeID int, employeeName String) partitioned by (employeeSalary double, country string)
row format delimited fields terminated by '|' stored as textfile;
LOAD DATA LOCAL INPATH "../../data/files/employee.dat" INTO TABLE Employee_Part_n0 partition(employeeSalary='2000.0', country='USA');
analyze table Employee_Part_n0 partition (employeeSalary='2000.0', country) compute statistics for columns employeeName, employeeID;
describe formatted Employee_Part_n0 partition (employeeSalary='2000.0', country='USA') employeeID;
describe formatted Employee_Part_n0 partition (employeeSalary='2000.0', country='usa') employeeID;