Explore topic-wise InterviewSolutions in .

Define the difference between Hive and HBase?
Below are the our main difference between Hive and HBase
HBase:-(1)HBase is built on the top of HDFS
Hive:-(1)On the other HAND it is a data warehousing infrastructure

HBase:-(2)HBase operations run in a real time on its database rather
Hive:-(2)On the other hand Hive queries are executed as MapReduce JOBS internally

HBase:-(3)In HBase it will provides low latency to single rows from huge datasets
Hive:-(3)In Hive it will provides high latency for huge datasets

HBase:-(4)It will provides RANDOM access to data
Hive:-(4)It will provides random access to data

Kind of applications which is supported by Apache HIVE?
Apache Hive will supports all the client application which is written in below langauages:-
(1)C++
(2)JAVA
(3)PHP
(4)Python
(5)Ruby
by EXPOSING its THRIFT server.

What is Hive or its BASIC defination
Hive is a data warehouse system which helps in data summarization, querying of large data systems and ANALYSIS in an open SOURCE hadoop platform. In another WAY we can say Hive is a data warehousing package or infrastructure built on top of hadoop.
Hive enables ADVANCED work on HDFS and MapReduce. We can query data stored in Hive using HiveQL which is similar to Transact-SQL.

How does partitioning help?
CHOOSE the CORRECT option from below LIST
(1)To create SUBDIRECTORIES under the table
(2)To create subdirectories inside the database

Answer:-(1)To create subdirectories under the table

How to CHANGE COLUMN data TYPE in Hive?
We can change data type of column in hive and below is the SYNTAX to change that
ALTER TABLE table_name CHANGE column_name column_name new_datatype;;

Name the different components of a Hive QUERY processor?
Below are the components of a Hive query processor:-
(1)Logical PLAN Generation
(2)Physical Plan Generation
(3)Execution Engine
(4)OPERATORS
(5)UDF's and UDAF's
(6)Optimizer
(7)Parser
(8)Semantic Analyzer
(9)Type Checking

Name the most famous Organizations Use Hive?
Below are the list of most common organiation which used. Actually Hive was DEVELOPED by Facebook.
(1)Netflix
(2)FINRA
(3)AMAZON
(4)Facebook

Which of the following HIVE uses for logging?
CHOOSE the correct option from below LIST
(1)None of the options
(2)LOGJ4
(3)log4i
(4)log4j

Answer:-(4)log4j

A UDF is CREATED to ACCEPT arguments of different data types. Which of the following option defines the given statement?
Choose the correct option from below list
(1)Super functions
(2)Aggregate Function
(3)Standard UDF
(4)Generic Function

Answer:-(3)Standard UDF

Where is DATA stored?
CHOOSE the correct option from below list
(1)MYSQL
(2)HDFS
(3)None of the options
(4)Hive

Answer:-(2)HDFS

Which of the following FILE format was designed to overcome limitations of the other Hive file FORMATS?
Choose the CORRECT option from below list
(1)ORC
(2)OPC
(3)None of the options
(4)ODC

Answer:-(1)ORC

Which of the following is the advantage of CREATING partitions?
Choose the correct option from below list
(1)effective MEMORY utilization
(2)NameNode using LESS RAM
(3)FASTER RESULTS
(4)Query syntax simpler

Answer:-(3)faster results

In this command, where will Hive search for a FILE?
LOAD DATA INPATH into table < tablename>;
Choose the correct option from below LIST
(1)It will search the file inpath.
(2)It will search for file in HDFS.
(3)None of the options
(4)It will throw error.

Answer:-(1)It will search the file inpath.

Which of the FOLLOWING does Hive use for logging?
CHOOSE the correct option from below list
(1)log4i
(2)LOG4J
(3)logj4
(4)None of the options

Answer:-(2)log4j

Which of the following are types of metastore?
(1)LOCAL metastore
(2)All of the OPTIONS
(3)Embedded metastore
(4)Remote metastore

Answer:-(2)All of the options

When there is a LARGE SET of data and you want to retrieve a small set of data. What is the CONCEPT called?
Choose the correct option from below list
(1)BUCKETING
(2)Partitioning
(3)None of the options
(4)Data Sampling

Answer:-(4)Data Sampling

What can be altered using ALTER COMMAND?
Choose the correct OPTION from below list
(1)database name
(2)dbproperties
(3)database creation name
(4)DIRECTORY where the database is stored

Answer:-(2)dbproperties

Which of the following command can be used to show partitions?
Choose the CORRECT OPTION from below LIST
(1)show
(2)describe extended < tablename>
(3)show extended
(4)describe extended

Answer:-(1)show

Which of the FOLLOWING will overwrite any existing data in the table or partition?
CHOOSE the correct option from below list
(1)insert write
(2)insert overwrite
(3)insert into
(4)NONE of the options

Answer:-(3)insert into

Which of the FOLLOWING is the new CLI?
Choose the correct OPTION from below list
(1)CliLine
(2)SqlLine
(3)BeeLine
(4)HiveLine

Answer:-(3)BeeLine

Hive STORES metadata by default in
Choose the correct option from below list
(1)Derby
(2)Tez
(3)None of the options
(4)Hadoop

Answer:-(1)Derby

The result of a Hive query is saved in _______________.
Choose the CORRECT option from below list
(1)HDFS
(2)None of the OPTIONS
(3)local File
(4)both

Answer:-(1)hdfs

Hive allows the feature to COPY __________.
Choose the correct option from below LIST
(1)Both Schema and DATA
(2)Data
(3)Schema
(4)NONE of the options

Answer:-(3)Schema

Thrift service is USED for
Choose the correct option from below list
(1)Using multiple HIVE versions
(2)INSTALLING Hive
(3)SUBMITTING hive queries from a REMOTE client
(4)Moving data files between different servers

Answer:-(3)Submitting hive queries from a remote client

In what language is HIVE written?
CHOOSE the correct option from below LIST
(1)Python
(2)Gama
(3)Java
(4)NONE of the options

Answer:-(3)Java

Which of the FOLLOWING is true about drop command in Hive?
CHOOSE the correct option from below list
(1)When an EXTERNAL table is dropped, the table with its data is also dropped.
(2)When an external table is dropped, only the METADATA is effected.
(3)Both of the options

Answer:-(2)When an external table is dropped, only the metadata is effected.

Which of the FOLLOWING, does Hive USE for logging?
Choose the correct OPTION from below LIST
(1)log4j
(2)None of the options
(3)log4i
(4)logj4

Answer:-(1)log4j

Which of the FOLLOWING are not the components of HIVE architecture?
CHOOSE the correct option from below list
(1)COMPILER
(2)metastore
(3)Interpreter
(4)Driver

Answer:-(3)Interpreter

When the schema of the table does not match with the DATA types of the file that is to be loaded, what does HIVE do?
Choose the CORRECT option from below LIST
(1)DROPS the file
(2)Throws error
(3)Corrects the data
(4)Returns null

Answer:-(4)Returns null

Hive can REPLACE RDBMS.
Choose the correct option from below list
(1)True
(2)FALSE

Answer:-(2)False

Apache Hive was initially DEVELOPED by ____________.
Choose the correct option from below list
(1)Amazon
(2)FACEBOOK
(3)TWITTER
(4)Microsoft

Answer:-(2)Facebook

If the DATABASE contains some tables, then using which keyword can it be forced to drop the tables?
Choose the correct OPTION from below LIST
(1)Restrict
(2)CASCADE
(3)Overwrite
(4)Drop

Answer:-(2)Cascade

If the partition of an index table is dropped, then ____________.
Choose the correct option from below LIST
(1)Corresponding partitions are also dropped
(2)Error is THROWN
(3)INDEXES are refreshed by default.
(4)None of the indexes are dropped

Answer:-(1)Corresponding partitions are also dropped

Which of the FOLLOWING is USED for disabling the substitution of variables?
Choose the correct option from below list
(1)set hive.variable.substitute=false;
(2)set hive.variable.substitute=true;
(3)all of the MENTIONED
(4)set hive.variable.substitutevalues=false;

Answer:-(1)set hive.variable.substitute=false;

Which of the following options HIVE doesn t convert QUERIES to?
Choose the CORRECT option from below list
(1)MAPREDUCE
(2)None of the options
(3)Spark jobs
(4)Apache Tez

Answer:-(1)MapReduce