About logon2pp

logon2pp · ‎06-23-2019

@Mayank Bhatt @sundeep dande We had to contact Hortonworks support to fix it. As per them the metadata was corrupted. I don't have the steps to fix that. P.S.One of the reasons why the metadata was getting corrupted was someone had created many managed table pointing external hdfs location. Though the table in question was not one of those tables.

logon2pp · ‎01-08-2019

0: jdbc:hive2://zaplncb00009q39-hs.qa.hadoop.> drop table testDB.TestTable; Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table testDB.TestTable. null (state=42000,code=40000) While performing any query on this table, I'm getting this error. Not able to delete database as well.

logon2pp · ‎01-05-2019

select row_number(),* from testDB.testTable; Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: Only COMPLETE mode supported for row_number function (state=42000,code=40000)

logon2pp · ‎01-05-2019

@zszj999 where you able to solve this.We are facing the same issue.

Online	Offline
Last Visited	‎06-23-2019 08:54 AM

Member Since	‎01-03-2019 02:12 PM
Last Visited	‎06-23-2019 08:54 AM
Posts	5

Cloudera Community

Cloudera Community

Re: Error: Error while compiling statement: FAILED...

Error: Error while compiling statement: FAILED: Se...

row_number in hive query giving error : Only COMPL...

Re: Grouping sets size cannot be greater than 64