hive 数据操作

1:  Loading Data into Managed Tables

LOAD DATA LOCAL INPATH'${env:HOME}/california-employees'

OVERWRITE INTO TABLE employees

PARTITION (country = 'US', state = 'CA');

2:Inserting Data into Tables from Queries

INSERT OVERWRITE TABLE employees

PARTITION (country= 'US', state ='OR')

SELECT * FROM staged_employees se

WHEREse.cnty = 'US' AND se.st ='OR';

3:Creating Tables and Loading Them in One Query

CREATE TABLE ca_employees

AS SELECT name,salary, address

FROM employees

WHEREse.state = 'CA';

4: