NEW
Font size
WorksheetsApache Hive - Introduction
Total questions: 15
Worksheet time: 4mins
Hive created by
Amazon
Yahoo!
Hive is a
Data Warehousing Tool
DataBase Management Tool
Data Scrapping Tool
Hadoop Data Tool
Hive don't make use of following:
HDFS for Storage
MapReduce for Execution
Stores metadata in a RDBMS
GPU for Processing
HQL is ______________ to SQL
Similar
Dissimilar
Hive __________ SQL queries _________ MapReduce Jobs
create, convert into
compiles, into
execute, from
interpret, of
Which of them is not hive feature?
easy to code
support rich datatypes
supports group-by
UDF not supported
A database is namespace for
tables
fields
records
keys
Separation of data on basis of specific attribute is
Partition
Bucketting
Fragmentation
Slicing
Separation of data on basis of mathematical hash function is
Partition
Bucketting
Fragmentation
Slicing
What is the right visual charter of HIVE Application?
What hive is not
online transaction processing
Data Warehousing tool
Similar to SQL
Analyze log data
Hive is suitable for
real-time queries
row-level updates
queries over small data sets
analyze historical data
Applications of Apache Hive
Log processing
OLTP
Billing systems
Processing Web Forms
Hive enables easy data summarization, ad-hoc querying and analysis of large volumes of data.
true
false
In _________ due to equal volumes of data in each partition, joins at Map side will be quicker.
bucketing
partitioning
