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.

Hive View not populating databases

Highlighted

Hive View not populating databases

Rising Star

@Neeraj Sabharwal

Not sure what happened but all of a sudden, hive view is not showing any databases. Earlier Hive shell wasn't working from console but then I created a folder /user/root, then I could see the Hive prompt. On hive prompt I could see all the databases and tables but not via Ambari view (screen shot).

2449-hive.jpg

hive> show tables punjtest;
OK
Time taken: 0.278 seconds
hive> show tables default;
OK
Time taken: 0.275 seconds
hive> show tables;
OK
avg_mileage
drivermileage
finalresults
geolocation
geolocation_stage
nrel_onshore_twh
riskfactor
truck_mileage
trucks
trucks_stage
Time taken: 0.273 seconds, Fetched: 10 row(s)
hive> show databases;
OK
arvindtest
dbforall
default
kemr_fst
kemrfst
punj
punjtest
Time taken: 0.025 seconds, Fetched: 7 row(s)
hive> show tables from default;
OK
avg_mileage
drivermileage
finalresults
geolocation
geolocation_stage
nrel_onshore_twh
riskfactor
truck_mileage
trucks
trucks_stage
Time taken: 0.377 seconds, Fetched: 10 row(s)
hive> show tables from punjtest;
OK
batting_data
master_data
Time taken: 0.401 seconds, Fetched: 2 row(s)
hive>
19 REPLIES 19
Highlighted

Re: Hive View not populating databases

@Prakash Punj

1) tail -f /var/log/ambari-server/ambari-server.log then refresh or click hive view

2) check hive metastore and HS2 logs

This may give you hint on the issue

Highlighted

Re: Hive View not populating databases

Rising Star
@Neeraj Sabharwal

Below is log information.


29 Feb 2016 02:03:57,653  INFO [qtp-ambari-client-404] ConfigurationBuilder:105 - HdfsApi configured to connect to defaultFS='hdfs://hdp-m.asotc:8020'
29 Feb 2016 02:03:57,682  INFO [qtp-ambari-client-404] HdfsUtil:127 - HdfsApi connected OK
29 Feb 2016 02:03:57,692  INFO [qtp-ambari-client-328] Connection:497 - Hive session opened
tail: cannot open ‘then’ for reading: No such file or directory
tail: cannot open ‘refresh’ for reading: No such file or directory
tail: cannot open ‘or’ for reading: No such file or directory
tail: cannot open ‘click’ for reading: No such file or directory
==> hive <==
tail: error reading ‘hive’: Is a directory
tail: hive: cannot follow end of this type of file; giving up on this name
tail: cannot open ‘view’ for reading: No such file or directory


Highlighted

Re: Hive View not populating databases

@Prakash Punj You said that it used to work but suddenly stopped working..correct?

Anything changed at mysql level?

Highlighted

Re: Hive View not populating databases

Rising Star

Yes it was working just right. All of a sudden one of the user reported that he cannot see database in database explorer.

No change in MySql that I know of..

Highlighted

Re: Hive View not populating databases

@Prakash Punj That's weird. Restart Hive process from Amabri.

Can you use pastebin to share HS2 and metastore logs? http://pastebin.com/

Highlighted

Re: Hive View not populating databases

@Prakash Punj /var/log/hive in HS2 server

Highlighted

Re: Hive View not populating databases

Rising Star
Highlighted

Re: Hive View not populating databases

@Prakash Punj See this

ERROR [Thread-8]: client.RangerAdminRESTClient (RangerAdminRESTClient.java:getServicePoliciesIfUpdated(81)) - Error getting policies. request=http://hdp-m.asotc:6080/service/plugins/policies/download/hadoop_hive?lastKnownVersion=-1&pluginId=hiveServer2@hdp-m.asotc-hadoop_hive, response={"httpStatusCode":400,"statusCode":1,"msgDesc":"Serivce:hadoop_hive not found","messageList":[{"name":"DATA_NOT_FOUND","rbKey":"xa.error.data_not_found","message":"Data not found"}]}, serviceName=hadoop_hive

java.lang.Exception: Serivce:hadoop_hive not found

It looks like that you have deleted that repo in ranger. Can you create hadoop_hive repo?

Highlighted

Re: Hive View not populating databases

Rising Star
@Neeraj Sabharwal

I did notice that error. I don't recall deleting it. How can I install it. Do you mean remove the service from the ambari interface and reinstall it or I can download somefile to Ranger server.

Thx

Don't have an account?
Coming from Hortonworks? Activate your account here