Which version are you using - I am able to parse the below statement successfully
________________________________________ From: 施兴 [EMAIL PROTECTED] Sent: Wednesday, December 03, 2008 8:03 PM To: [email protected] Subject: Fwd: Meet a problem ---------- Forwarded message ---------- From: 施兴 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> Date: Thu, Dec 4, 2008 at 10:32 AM Subject: Meet a problem To: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> FROM hive_test INSERT OVERWRITE TABLE domain_compute SELECT hive_test.domain, COUNT(DISTINCT hive_test.id<http://hive_test.id>) GROUP BY hive_test.domain INSERT OVERWRITE LOCAL DIRECTORY '/tmp/hive_test2' SELECT hive_test.domain, COUNT(DISTINCT hive_test.ip) GROUP BY hive_test.domain; shows this information: FAILED: Parse Error: line 1:23 required (...)+ loop did not match anything at input 'OVERWRITE' I am learning hive statement by :Data/Hive/Hive 2.0 Tutorial Concepts -- Best wishes! My Friend~ -- Best wishes! My Friend~
