Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Top 100 Hadoop Complex interview questions (Part 4 of 4)

Hadoop framework is most popular in data analytics and data related projects. I have given here my 4th set of questions for you to read quickly.

hadoop part 4

1) What is MapReduce?
Ans) It is a framework or a programming model that is used for processing large data sets over clusters of computers using distributed programming.

2). What are ‘maps’ and ‘reduces’?
Ans). ‘Maps‘ and ‘Reduces‘ are two phases of solving a query in HDFS. ‘Map’ is responsible to read data from input location, and based on the input type, it will generate a key-value pair, that is, an intermediate output in the local machine. ’Reducer’ is responsible to process the intermediate output received from the mapper and generate the final output.

3). What are the four basic parameters of a mapper?

Ans) The four basic parameters of a mapper are LongWritable, text, text, and IntWritable. The first two represent input parameters and the second two represent intermediate output parameters.

4). What are the four basic parameters of a reducer?
Ans). The four basic parameters of a reducer are text, IntWritable, text, IntWritable. The first two represent intermediate output parameters and the second two represent final output parameters.

5). What do the master class and the output class do?
Ans). Master is defined to update the Master or the job tracker and the output class is defined to write data onto the output location.

6). What is the input type/format in MapReduce by default?
Ans). By default, the type input type in MapReduce is ‘text’.

7). Is it mandatory to set input and output type/format in MapReduce?
Ans) No, it is not mandatory to set the input and output type/format in MapReduce. By default, the cluster takes the input and the output type as ‘text’.

8) What does the text input format do?
Ans). In the text input format, each line will create a line object, that is a hexadecimal number. Key is considered as a line object and value is considered as a whole line text. This is how the data gets processed by a mapper. The mapper will receive the ‘key’ as a ‘LongWritable‘ parameter and value as a ‘text‘ parameter.

9)What does job conf class do?
Ans). MapReduce needs to logically separate different jobs running on the same cluster. ‘Job conf class‘ helps to do job level settings such as declaring a job in the real environment. It is recommended that Job name should be descriptive and represent the type of job that is being executed.

10). What does conf.setMapper Class do?
Ans) Conf.setMapper class sets the mapper class and all the stuff related to map job such as reading a data and generating a key-value pair out of the mapper.

11). What do sorting and shuffling do?
Ans). Sorting and shuffling are responsible for creating a unique key and a list of values. Making similar keys at one location is known as Sorting. And the process by which the intermediate output of the mapper is sorted and sent across to the reducers is known as Shuffling.

12). What does a split do?
Ans). Before transferring the data from hard disk location to map method, there is a phase or method called the ‘Split Method‘. Split method pulls a block of data from HDFS to the framework.

The Split class does not write anything, but reads data from the block and pass it to the mapper. By default, Split is taken care by the framework. Split method is equal to the block size and is used to divide the block into a bunch of splits.

13). How can we change the split size if our commodity hardware has less storage space?
Ans) If our commodity hardware has less storage space, we can change the split size by writing the ‘custom splitter‘. There is a feature of customization in Hadoop which can be called from the main method.

14). What does a MapReduce partitioner do?
Ans). A MapReduce partitioner makes sure that all the value of a single key goes to the same reducer, thus allows even distribution of the map output over the reducers. It redirects the mapper output to the reducer by determining which reducer is responsible for a particular key.


15). How is Hadoop different from other data processing tools?
Ans). In Hadoop, based upon your requirements, you can increase or decrease the number of mappers without bothering about the volume of data to be processed. this is the beauty of parallel processing in contrast to the other data processing tools available.

16). Can we rename the output file?
Ans). Yes, we can rename the output file by implementing multiple format output class.

17). Why we cannot do aggregation (addition) in a mapper? Why we require reducer for that?
Ans). We cannot do aggregation (addition) in a mapper because sorting is not done in a mapper. Sorting happens only on the reducer side. Mapper method initialization depends upon each input split. While doing aggregation, we will lose the value of the previous instance. For each row, a new mapper will get initialized. For each row, the input split again gets divided into mapper, thus we do not have a track of the previous row value.

18) What is Streaming?
Ans). Streaming is a feature with Hadoop framework that allows us to do programming using MapReduce in any programming language which can accept standard input and can produce standard output. It could be Perl, Python, Ruby and not necessarily be Java. However, customization in MapReduce can only be done using Java and not any other programming language.

19). What is a Combiner?
Ans). A ‘Combiner’ is a mini reducer that performs the local reduce task. It receives the input from the mapper on a particular node and sends the output to the reducer. Combiners help in enhancing the efficiency of MapReduce by reducing the quantum of data that is required to be sent to the reducers.

20). What is the difference between an HDFS Block and Input Split?

Ans). HDFS Block is the physical division of the data and Input Split is the logical division of the data.

21). What happens in a text input format?
Ans). In text input format, each line in the text file is a record. Key is the byte offset of the line and value is the content of the line. For instance, Key: longWritable, value: text.

22). What do you know about key-value text input format?
Ans). In key value text input format, each line in the text file is a ‘record‘. The first separator character divides each line. Everything before the separator is the key and everything after the separator is the value. For instance, Key: text, value: text.

23). What do you know about Sequence file input format?
Ans). Sequencefileinputformat is an input format for reading in sequence files. Key and value are user-defined. It is a specific compressed binary file format which is optimized for passing the data between the output of one MapReduce job to the input of some other MapReduce job.

24). What do you know about Nlineoutputformat?

Ans). Nlineoutputformat splits ‘n’ lines of input as one split.

Related Posts

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers