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 arraystructname : string, value : string, instance
mapstring,string, true_as_of_secs string
)
PARTITIONED BY (type string, dth string)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3n://com...xx.xxx/tables/pl0/ctg=';
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