Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Ask a Question
Top 100+ questions and answers in Hive
Home
Questions
Hive
0
votes
Q: What is the difference between an external table and a managed table in Hive?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-managed-tables
#hive-external-tables
0
votes
Q: What is a partition in Hive and why is partitioning required in Hive
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-partitions
#hive-partitioning
0
votes
Q: What are the components used in Hive query processors?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-query-processors
#query
#hive-query
0
votes
Q: Suppose there are several small CSV files present in /user/input directory in HDFS and you want to create a single Hive table from these files.
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-csv-files
#hdfs-format
0
votes
Q: Write a query to insert a new column(new_col INT) into a hive table (h_table) at a position before an existing column (x_col).
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-query
#hive-table
#hive-coloumn
0
votes
Q: What are the key differences between Hive and Pig?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#hive-vs-pig
#hive
#pig
#
0
votes
Q: How is Apache Pig different from MapReduce?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#pig-vs-mapreduce
#mapreduce
#pig
#mapreduce-vs-pig
0
votes
Q: What are the different ways of executing a Pig script?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
#pig-script
#script
0
votes
Q: Which of the following is an assertion library?
answered
Nov 3, 2020
in
Hive
by
rahuljain1
#assertion-library
0
votes
Q: Which of the following command can be used to show partitions?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-show-partition
#show-partition
0
votes
Q: Which is the following is more convenient to get table details?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-table-detail
#table-detail
0
votes
Q: The result of a Hive query is saved in _______________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-results
0
votes
Q: When there is a large set of data and you want to retrieve a small set of data. What is the concept called?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#large-set-of-data
#hive-dataset
0
votes
Q: If the database contains some tables, then using which keyword can it be forced to drop the tables?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-dataset
#hive-contains
0
votes
Q: Where is data stored?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-data-store
#data-store
0
votes
Q: If the partition of an index table is dropped, then
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#partition-index-table
#index-table
0
votes
Q: Hive is a __________________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hivedata-warehouse
0
votes
Q: A UDF is created to accept arguments of different data types. Which of the following defines the given statement?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-udf
#udf-hive
0
votes
Q: When the schema of the table doesn’t match with the data types of the file. What does Hive do?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-schema
#schema-hive
0
votes
Q: Hive will provide Data Warehousing Layer to data over Hadoop.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
#hive-data-warehousing
To see more, click for all the
questions in this category
.
...
