Re: Doing FSCK throws error
total speculation here given there isn't much to go one. basically all we have here is an issue thrown by "DDLtask" - that's typically a method that is responsible for interrogating the meta store. So first thing is does the table exist? do a show tables. On Mon, Sep 30, 2013 at 10:10 AM, wrote: > 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 >
RE: Doing FSCK throws error
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>, instance map, 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
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