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:
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。