[Q]: Use retail_db_orders, order_items table and find the maximum revenue generated per year. If any value is not present in either tables then show max revenue? [A]: CREATE EXTERNAL TABLE orders (order_id INT, order_date STRING, order_customer_id BIGINT, order_status STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ STORED AS TEXTFILE LOCATION…

I attempted Cloudera CCA175 after preparing for the same for almost a month or so. I would attempt to split the details into multiple blogs, in here I plan to list down all resources needed so that time is spent on learning rather than researching for the certificate. 1) Check…

Cloudera is the pioneer in the field of data analysis, data engineering and data science and Cloudera certification go a big way in confirming your ability to increase your knowledge in the big data world. Unlike multiple choice questions based certifications all Cloudera exams are hands-on on live environment with…