The script for this table is add jar json-serde-1.1.3-jar-with-dependencies.jar; list jars;
CREATE EXTERNAL TABLE IF NOT EXISTS table1 ( instance_type string, category string, session_id string, nonce string, user_id string, properties array<struct<name : string, value : string>>, instance map<string,string>, true_as_of_secs string ) PARTITIONED BY (type string, dth string) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' LOCATION 's3n://com.xxxx.xxxx.xx.xxx/tables/pl0/ctg=xxxx'; MSCK REPAIR TABLE table1; Thanks, Shouvanik From: Haldar, Shouvanik Sent: Monday, September 30, 2013 10:39 PM To: nitinpawar...@gmail.com; user@hive.apache.org Subject: Doing FSCK throws error Hi, On executing "MSCK REPAIR TABLE table1", I get the below error. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask What can possibly be the error. Thanks, Shouvnik ________________________________ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. ______________________________________________________________________________________ www.accenture.com
