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
Where does the data of a Hive table gets stored?
Home
Big Data | Hadoop
Where does the data of a Hive table gets stored?
asked
Jan 10, 2020
in
Big Data | Hadoop
by
sharadyadav1986
(
31.7k
points)
Where does the data of a Hive table gets stored?
#hive-table
Bigdata-questions-answers
Hadoop-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 10, 2020
by
SakshiSharma
(
32.2k
points)
By default, the Hive table is stored in an HDFS directory – /user/hive/warehouse. One can change it by specifying the desired directory in hive.metastore.warehouse.dir configuration parameter present in the hive-site.xml.
Related questions
+1
vote
Q: Where is data stored?
asked
Feb 10, 2020
in
Big Data | Hadoop
by
miceperry
(
775
points)
#hive-table
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: Can we use same name for a TABLE and VIEW in Hive?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
(
31.7k
points)
#hive-table
#hive-view
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: The name of a view in Hive
asked
Apr 6, 2020
in
Big Data | Hadoop
by
GeorgeBell
(
5.2k
points)
#hive-table
#hive-view
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: LOAD DATA INPATH into table <tablename>; In this command, where will Hive search for a file?
asked
Apr 1, 2020
in
Big Data | Hadoop
by
AdilsonLima
(
6.3k
points)
#hive-view
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: Where does the data of a Hive table gets stored?
asked
Jun 7, 2020
in
Hive
by
SakshiSharma
(
32.2k
points)
#hive-tables
#hive-sort
+1
vote
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).
asked
Dec 3, 2020
in
Hive
by
sharadyadav1986
(
31.7k
points)
#hive-query
#hive-table
#hive-coloumn
0
votes
Q: How does OVERWRITE clause work in CREATE TABLE statement in Hive?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
(
31.7k
points)
#hive-overwrite
#hive-create-table
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: The results of a hive query can be stored as
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
#hive-query
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: The tables created in hive are stored as
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
#hive-query
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: Each database created in hive is stored as
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
#hive-query
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: To see the partitions present in a Hive table the command used is
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: The partitioning of a table in Hive creates more
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
#hive
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: The 2 default TBLPROPERTIES added by hive when a hive table is created is
asked
Apr 3, 2020
in
Big Data | Hadoop
by
Tate
(
883
points)
#hive
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What is a Managed table in Hive?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
(
31.7k
points)
#hive-managed-table
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What is a Skewed table in Hive?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
(
31.7k
points)
#hive-skewed-table
Bigdata-questions-answers
Hadoop-questions-answers
...