HIVE, ?
o'reilly programmin:
FROM staged_employees se
INSERT OVERWRITE DIRECTORY '/tmp/or_employees'
SELECT * WHERE se.cty = 'US' and se.st = 'OR'
INSERT OVERWRITE DIRECTORY '/tmp/ca_employees'
SELECT * WHERE se.cty = 'US' and se.st = 'CA'
INSERT OVERWRITE DIRECTORY '/tmp/il_employees'
SELECT * WHERE se.cty = 'US' and se.st = 'IL';
, s ?
+3
Manish
2
, . . , , : SELECT * FROM stage_employees se WHERE se.cty = 'US' se.st = 'OR' "/tmp/or_employees".
SELECT , st = 'CA' st = 'IL'.
, Prasanth
0
Prasanth
"FROM" /. select, . , INSERT "FROM" (: SELECT * missing FROM FROM WHERE se.cty = 'US' se.st = 'OR ").
, , . , , FROM (FROM staged_employees se), .
, .
0
Manoj Kumar G