What is difference between internal and external tables in hive?
Answer / rajasekhar
if you drop a table in internal mode then table schema and files get deleted.
If you drop a table in external mode then table shema will be gone but files will be present.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to change the column data type in hive? Explain rlike in hive.
What is the stable version of Hive ?
How data transfer happens from HDFS to Hive?
What is Hive ?
Differentiate between PigLatin and Hive?
Whenever we run hive query, new metastore_db is created. Why?
What is dynamic partitioning and when is it used?
what is partitions in hive?
Say what the views are in hive?
Does the archiving of hive tables give any space saving in hdfs?
Is it possible to change the default location of Managed Tables in Hive, if so how?
What is the difference between Hiveserver1 and Hiveserver2?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)