Hi Rishabh, You can get more logging info, including the full stack trace, by changing the logging level when starting Hive: hive -hiveconf hive.root.logger=INFO,console Cheers, Anthony
________________________________ From: Rishabh Bhardwaj [rbnex...@yahoo.com] Sent: Monday, March 31, 2014 11:57 PM To: Chinna Rao Lalam; user@hive.apache.org Subject: Re: FAILED: SemanticException [Error 10001]: Table not found answer Hi chinna, There was no caused by exception.Only the error which I mentioned. It is SemanticException [Error 10001]: Table not found Thanks, Rishabh. On Tuesday, 1 April 2014 12:24 PM, Chinna Rao Lalam <lalamchinnara...@gmail.com> wrote: Hi, Can you add what is the causedby excetion...or full exception. On Tue, Apr 1, 2014 at 11:09 AM, Rishabh Bhardwaj <rbnex...@yahoo.com<mailto:rbnex...@yahoo.com>> wrote: Hi all, I created the database 'test1' and a table 'my1' Now with show tables in test1 , hive shell is showing my1 but when I am trying to do, describe my1; then this error comes: FAILED: SemanticException [Error 10001]: Table not found answer and when I execute, describe test1.my1; then the following error comes up, FAILED: Error in metadata: Unable to fetch table my1 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask The problem is not with any other databases.I can query any table in any other database without any error. Please help. Thanks, Rishabh. -- Hope It Helps, Chinna