Member since
09-09-2014
17
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
49399 | 01-05-2015 01:24 PM |
01-05-2015
01:24 PM
1 Kudo
Thanks Romain for your time and your answer. I have restarted CDH and the isused has fixed! This is strange but still a very good news 🙂 I have not changed any configuration and have had restarted the service many times before. Anyway, I will wait couple of more days and then update the case. Thanks again. Kind regards Andy
... View more
01-01-2015
03:17 PM
This is exactly what we did and it fixed the problem. Thanks much Darren. FYI: Before that step, we had to temporarily re-enable the user which is capable to create the credentials. We have decided earlier to disable that user to improve security and that was the main source of the issue. Appreciate your support. Kind regards Andy
... View more
12-30-2014
05:04 PM
Thanks much Romain From the URL you kindly shared with me, I just ran beeline and I was able to get into it command line: then I ran the following command all in one line (not sure I need to do that) by replacing my AD username and password below: !connect jdbc:hive2://localhost:10000 <ADUserName> <Password> org.apache.hive.jdbc.HiveDriver 0: jdbc:hive2://localhost:10000> SHOW TABLES; but I got this error message: Connecting to jdbc:hive2://localhost:10000 Error: Could not open connection to jdbc:hive2://localhost:10000: Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0) 0: jdbc:hive2://localhost:10000 (closed)> I also try the following: sudo service hive-server2 start but got the error: hive-server2: unrecognized service Can you tell me if I missed something and how to run the above commands correctly or is there any way I can test to see if HiveServer2 is running correctly? Thanks much Romain. P.S. Originally, running beeline from the default location ((/usr/lib/hive/bin/beeline) did not work so I just ran it by typing beeline and it worked 🙂 Cheers Andy
... View more
12-29-2014
04:47 PM
Thanks Romain We do not have Sentry service added in CM but I can see "sentry table'' item under "hadoop security" in Hue and when I select it, it generates the following error: Could not connect to localhost:8038 (code THRIFTTRANSPORT): TTransportException('Could not connect to localhost:8038',) Can you help me verify if my user have access to default database as you mentioned? I use my network AD user to login to Hue using Kerberos/LDAP and we set Hue up for this purpose. P.S. The strange thing is, yesterday, when I logged in to Hue, I did not see the error message but today, I got the same Hive error message again. and as mentioned before, this error is new, right after we have upgraded both CDH and CM from 5.2 to 5.3 last week. Appreciate your support and case. Please let me know if you have any question. Kind regards Andy
... View more
12-27-2014
04:02 PM
Dear Friends We have just upgraded our CM and CDH from 5.2 to 5.3 successfully. Hue was also working fine. Today, when I login to Hue, I got the following message: Potential misconfiguration detected. Fix and restart Hue. Hive Editor: The application won't work without a running HiveServer2. Then I clicked on the Hive editor link in Hue, the database area just try to refresh the sample table list and running a simple select statement generates the error below. Would you please help? Your query has the following error(s):java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient The strange thing is, if I login with another user to Hue, it do not show me this message above and also I can run the sample query in Hive error fine. I can see other people have the same issue as below: http://community.cloudera.com/t5/Apache-Hadoop-Concepts-and/Problem-with-CDH-5-VM-quot-Potential-misconfiguration-detected/m-p/13744/thread-id/1141 P.S. Manually refreshing the table in Hive editor did not work and even reinstalling the same tables in Hue generated the following info: Could not install table: Error creating table sample_07: Bad status for request TExecuteStatementReq(confOverlay={}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='e\(replaced by me for security reason J)', guid='\x(again replaced by me for security reason J)')), runAsync=True, statement="CREATE TABLE `sample_07` (\n `code` string ,\n `description` string ,\n `total_emp` int ,\n `salary` int )\nROW FORMAT DELIMITED\n FIELDS TERMINATED BY '\t'\nSTORED AS TextFile"): TExecuteStatementResp(status=TStatus(errorCode=10072, errorMessage='Error while compiling statement: FAILED: SemanticException [Error 10072]: Database does not exist: default', sqlState='42000', infoMessages=None, statusCode=3), operationHandle=None). Thanks much for your support and please let me know if you have any question. Kind regards Andy
... View more
12-27-2014
02:15 PM
Dear Friends I have started using Flume and have added its service using CM. Then, added the two lines below in the Flume Configuration file: tier1.sinks.sink1.hdfs.kerberosPrincipal = $KERBEROS_PRINCIPAL tier1.sinks.sink1.hdfs.kerberosKeytab = $KERBEROS_KEYTAB But Flume service did not start rather generated the following configuration error: Agent(<our_name_node_name>):Role is missing Kerberos keytab. Would you please help? P.S. I have previously enabled Kerberos in CM (by following the link belew) before adding the Flume service. I can see all services principals (for all of our hosts) in CM EXCEPT Flume one on Administration > Kerberos >Credentials tab. http://blog.cloudera.com/blog/2014/07/new-in-cloudera-manager-5-1-direct-active-directory-integration-for-kerberos-authentication/ Thanks much in advance and please let me know if you have any question. Kind regards Andy
... View more
Labels:
- Labels:
-
Apache Flume
-
Cloudera Manager
-
HDFS
-
Kerberos