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.

How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

Highlighted

How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

This error occurs every time I select the table in the tables tab in hive view 2.0.

The source table from mysql does not have an int primary key. and the table size is 5.5GB

If you have any I dea how to fix it. I need your help. Thanks

9 REPLIES 9
Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

@Christian Lunesa

Refer to this link for the issue that you are facing. If this is the exact issue, you may need to update the RM config.

Let know if that helps!

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

I just experienced this kind of error in hive view 2.0 when TABLES tab and I try to view the table properties of a table with 5 GIG size. .

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

Please mark the answer as accepted if it resolved your problem. This way you can help other community users having similar issues identify the resolution faster.

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

hive-20-error.png I am having this in the ambari server logs. . please see if you have experience same thing as mine

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

@Christian Lunesa

Is this related to the earlier issue?

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

I am not sure where you are getting this issue, but the number looks too long for an integer! If this is your hive table etc, try using BigInt and not int. Or else post some more info about the issue :)

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

@Rahul Soni Yes, sir . . That's what I see in the ambari-server logs with regards to the error I posted above.

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

@Christian Lunesa

As you probably know, the 500 Internal Server Error is a very general HTTP status code that means something has gone wrong on the website's server, but the server could not be more specific on what the exact problem is.

You need to provide more information. There could be many reasons.

1) Does it happen with other tables?

2) Is your cluster kerberized?

3) Did you check Ambari server log for more details?

Highlighted

Re: How do I get rid of failed to fetch table information Status: 500 Message: Server Error?

1. it does not happened with other tables where the size of table table is lower than 5GB

2. it is not kerberized

3. Yes , I attached the screen shot of the logs


hive-20-error.png
Don't have an account?
Coming from Hortonworks? Activate your account here