Error while running query on HIVE;

[#1]

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]

[#2]

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.

[#3]

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

[#4]

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

[#5]

Pls try this and see any luck

ANALYZE TABLE Table_Name COMPUTE STATISTICS;

[#6]

Hi,

Nops, no luck...

BR,

Salman