About Gerva

Gerva · ‎07-30-2021

I still think it's a Cloudera mistake. I am very angry. In my exam I verified that the output file was generated in the directory. It's recorded, you can check it out. And now they tell me that nothing is generated. This is a hoax

Gerva · ‎07-13-2021

Good Morning. I present my problem to you. I hope that some user can help me. I took my CCA Data Analyst certification exam (159). In the Score Report I have 3 problems = Incorrect SQL solution The Cloudera FAQ states that this error is because: An SQL file was found, but it did not generate any output when run. This could include a lack of database references for the tables. I don't agree with the solution because I ran my script with the command $ hive –f ‘file.sql’ and verified that it generated an output file. Cloudera doesn't tell me if the results are wrong because the number of records is wrong or the output directory is wrong. The exam is recorded and it can be verified that it generates an output file. Have a good day

Gerva · ‎05-03-2021

Good morning Riccardo. Was your problem solved? It happened to me exactly the same. I am angry because the questions do not indicate an output directory for the report. Maybe that could be the mistake.

Gerva · ‎04-03-2021

Hi Riccardo. I have the same problem as you. I took my certification exam and the answer to three problems was: Failed - Incorrect solution SQL. They didn't give me any more answers. Nothing. In my exam I verified that the output was correct and that the data was being created in HDFS. Like you, I have requested that you review the video of the exam. In other problems they answered me: Failed - Incorrect number of records. I have complained to Cloudera by emailing them at certification@cloudera.com. A week has passed and I have received no response. I think it is a very bad service.

Gerva · ‎10-14-2019

@Shu_ashu Great!. With the instructions you have given me, the output file is created correctly. I also tried the option: CREATE TABLE AS scenariox_out AS SELECT select count (*) from scenariox; And the output file was created in: /user/hive/warehouse/scenariox.db/scenariox/scenariox_out/000000_0 Thank you. You have a good day

Gerva · ‎10-11-2019

Good Morning. I am doing a small example with HIVE and MANAGED TABLE. My environment is Oracle VM virtual Box 6.0 Hive 1.1.0-cdh5.13.0 I indicate the steps I have taken: 1st) CREATE DATABASE scenariox 2nd) USE scenariox CREATE TABLE scenariox ( smallint order; name string; ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; 3rd) I load the table with my csv file that is stored in HDFS HDFS> /scenariox/scenariox.csv LOAD DATA LOCAL INPATH '/scenariox/scenariox.csv' INTO TABLE scenariox The table loads correctly. I can run: '' Select * from scenariox ''. I recover data correctly. The table has been loaded successfully. The directories in hive are created correctly: /user/hive/warehouse/scenariox.db/scenariox/scenariox.csv I execute the sentence: SELECT COUNT (1) FROM scenariox; MAP / REDUCE launched My problem is: I can't find the output file that produces the map / reduce. What directory is it stored in? I thought that a file of type '00000_0' was generated and stored in the HDFS. Can somebody help me? Thank you. Greetings

Online	Offline
Last Visited	‎07-30-2021 03:24 AM

Member Since	‎10-11-2019 04:55 AM
Last Visited	‎07-30-2021 03:24 AM
Posts	11

Cloudera Community

Re: Incorrect SQL solution

Incorrect SQL solution

Re: Certification cloudera - incorrect evaluation...

Re: Certification cloudera - incorrect evaluation...

Re: HIVE MANAGED TABLE

HIVE MANAGED TABLE