Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error while running query on HIVE;

SOLVED Go to solution

Re: Error while running query on HIVE;

New Contributor

Can you please check database name, which are being used while creating table. As you are not using any database name in the query, might be its pointing to some other database on which you might not have access.

Re: Error while running query on HIVE;

Contributor

Please check DB name and make sure Table is not existed already 

Re: Error while running query on HIVE;

Explorer

Hi All,

 

Facing below error while running the hive command.

 

MSCK REPAIR TABLE flexdto_standin_avro;

 

  • Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Your inputs is much appreciated.

 

Thanks

Yasmin

Highlighted

Re: Error while running query on HIVE;

Champion

Pls try this and see any luck

 

ANALYZE TABLE Table_Name COMPUTE STATISTICS;

Re: Error while running query on HIVE;

Explorer

Hi,

 

Nops, no luck...

 

BR,

Salman