Web Technologies
Android
Angular
BootStrap
ECMAScript
HTML
Image Processing
JavaScript
MVC
Onsen UI
React JS
SOAP UI
Vue.js
Cloud/DevOps Technologies
Amazon EC2
Ansible
Augmented Reality
AWS
Azure
Big Data
Cache Teachniques
Cassandra
Commercial Insurance
Cloud
CD
CI
Data Handling
Data using R
Data Science
DevOps
Gradle
Hadoop
HBase
HDFS
Hive
IOT
Jenkins
Machine Learning
MangoDB
NGINX
SOAP UI
Latest Technologies
5G Network
Agile
Android
Arduino
Augmented Reality
Commercial Insurance
C#
C++
Cyber Security
Data Handling
Data using R
Data Science
DBMS
Design-Pattern
Fortify
Ethical Hacking
Framework
GIT
GIT Slack
Image Processing
Java
Jenkins
Jira
JUnit
Kibana
Linux
MangoDB
Oracle
PHP
Python
QTP
R Language
Regression Analysis
Robotic
Salesforce
SAP
Selenium
Service Discovery
Service Now
Spark SQL
Testing
TOGAF
Research Method
Virtual Reality
Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Recent questions and answers in Hive
Home
Questions
Hive
0
votes
What is the difference between an external table and a managed table in Hive?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-managed-tables
#hive-external-tables
+1
vote
What is a partition in Hive and why is partitioning required in Hive
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-partitions
#hive-partitioning
+1
vote
What are the components used in Hive query processors?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-query-processors
#query
#hive-query
+1
vote
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
(
30.5k
points)
#hive-csv-files
#hdfs-format
+1
vote
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
(
30.5k
points)
#hive-query
#hive-table
#hive-coloumn
0
votes
What are the key differences between Hive and Pig?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-vs-pig
#hive
#pig
#
0
votes
How is Apache Pig different from MapReduce?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#pig-vs-mapreduce
#mapreduce
#pig
#mapreduce-vs-pig
0
votes
What are the different ways of executing a Pig script?
answered
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#pig-script
#script
0
votes
Which of the following is an assertion library?
answered
Nov 3, 2020
in
Hive
by
rahuljain1
(
6.0k
points)
#assertion-library
0
votes
Which of the following command can be used to show partitions?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-show-partition
#show-partition
0
votes
Which is the following is more convenient to get table details?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-table-detail
#table-detail
0
votes
The result of a Hive query is saved in _______________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-results
0
votes
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
(
30.5k
points)
#large-set-of-data
#hive-dataset
0
votes
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
(
30.5k
points)
#hive-dataset
#hive-contains
0
votes
Where is data stored?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-data-store
#data-store
+1
vote
If the partition of an index table is dropped, then
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#partition-index-table
#index-table
0
votes
Hive is a __________________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hivedata-warehouse
0
votes
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
(
30.5k
points)
#hive-udf
#udf-hive
+1
vote
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
(
30.5k
points)
#hive-schema
#schema-hive
0
votes
Hive will provide Data Warehousing Layer to data over Hadoop.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-data-warehousing
0
votes
Apache Hive was initially developed by ____________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#apache-hive
#hive-apache
0
votes
In which mode, HiveServer2 accepts real Thrift calls.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-server2
0
votes
Which of the following are types of metastore?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-metastore
0
votes
Which of the following options Hive doesn’t convert queries to?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-query-convert
0
votes
Hive can replace RDBMS.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-vsrdbms
0
votes
Hive stores metadata by default in ____________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-metadata
+1
vote
When the schema of the table doesn’t match with the data types of the file that is to be loaded, what does Hive do?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-error
0
votes
Which of the following command is to be used in a DDL statement to create Avro-backed tables?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-ddl-statement
0
votes
Hive allows the feature to copy __________.
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-copy
#copy-hive
0
votes
If you create a table but don't create a database then where will the table be stored?
answered
Oct 25, 2020
in
Hive
by
sharadyadav1986
(
30.5k
points)
#hive-database-create
To see more, click for all the
questions in this category
.
...