Clever Geek Handbook

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




2


, . . , , : SELECT * FROM stage_employees se WHERE se.cty = 'US' se.st = 'OR' "/tmp/or_employees".

SELECT , st = 'CA' st = 'IL'.



, Prasanth

0




"FROM" /. select, . , INSERT "FROM" (: SELECT * missing FROM FROM WHERE se.cty = 'US' se.st = 'OR ").

, , . , , FROM (FROM staged_employees se), .



, .

0








More articles:


All Articles