Member since
06-12-2019
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2711 | 06-12-2019 03:39 PM |
06-12-2019
03:39 PM
I was able to solve the problem. For detailed information see this.
... View more
06-12-2019
03:38 PM
I found this solution in another post: **************************************************************** I tried doing the steps with following details database host name : quickstart.cloudera database type Mysql But was not sure of the database name, user name, password. Then went into terminal, loged into Mysql using $mysql -uroot -pcloudera And then listed all databases using mysql> show databases; use one of them mysql> use database_name; And then listed all tables using mysql> show tables; created a table name as reportdb. used table name as Reportdb, user as root and password as cloudera to create the report manager role succesfully. This is just the next steps in the same chain. I thought it is better to keep it updated that might help people to see that. **************************************************************** Now I do not get the error anymore. Another problem I have had was solved as well.
... View more
06-12-2019
04:39 AM
Hello! My problem is to make hive queries. Using Impala works fine. Both in HUE The query I tried to make is: e.g. load data local inpath '/tmp/expectancy_country.csv' overwrite into table expectancy_country; After 2:45 i get the message time out and the log shows: INFO : Compiling command(queryId=hive_20190612043030_466f94db-6fb9-41c4-ad84-098d8f8decbe): load data local inpath '/tmp/expectancy_country.csv' overwrite into table expectancy_country
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling command(queryId=hive_20190612043030_466f94db-6fb9-41c4-ad84-098d8f8decbe); Time taken: 0.061 seconds On the left side is still the red quader indicating that the query is running. I also tried: create table expectancy_country (expectancy int, country string) row format delimited fields terminated by ','; With the same result. But show tables works fine. The quickstart does not show any issues. The only change I made is <property> 150 150 <name>spark.executor.cores</name> 151 - <value>1</value> 151 + <value>4</value> But it did not work before as well. Any ideas Edit: On the upper left side under hive and databases I get the message: Error loading databases
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Manager
06-12-2019
04:26 AM
Hello!
In the Cloudera Manager I get the following Configuration Errors:
Cloudera Management Service: Service mgmt has 0 Reports Managers. Cloudera Management Service requires at least 1 Reports Manager.
Cloudera Management Service: Reports Manager Database Name
Missing required value: Reports Manager Database Name
Cloudera Management Service: Reports Manager Database Username
Missing required value: Reports Manager Database Username
If I add a Reports Manager as an Instance I have to configure the Database. The name, the pasword and the username is not set. The database is pre-defined as mysql and the database is cloudera. Do I have to get rid of this error and if so how.
I am a bit confused since it looks like no database is set but impala queries are working but hive does not, I will open another question about this.
br!
... View more
Labels:
- Labels:
-
Cloudera Manager
-
Quickstart VM