Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error while running query on HIVE;

avatar
Explorer

HI All,

 

I am unable to run the simple query on HIVE i.e. describe tablename; and getting the below error. Also when I tried to check it on hue it also give me the same error. Even Ive tried to do the same with admin user and it gives me the same error. can anybody help me here.

 

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. cannot find field lbs_retail_celleliste_jakntest from [0:id, 1:timestamp, 2:lid, 3:kundenr, 4:kundenavn, 5:gadenavn, 6:husnr, 7:postnr, 8:postdistrikt, 9:kisnr, 10:kismoder, 11:kismoder_navn, 12:sys34_x, 13:sys34_y, 14:celle_01_y, 15:celle_02, 16:celle_03, 17:celle_04, 18:celle_05, 19:celle_06, 20:celle_07, 21:celle_08, 22:celle_09, 23:celle_10, 24:utm_e, 25:utm_n]

1 ACCEPTED SOLUTION

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
14 REPLIES 14

avatar
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.

avatar

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

avatar
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

avatar
Champion

Pls try this and see any luck

 

ANALYZE TABLE Table_Name COMPUTE STATISTICS;

avatar
Explorer

Hi,

 

Nops, no luck...

 

BR,

Salman