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 |
Which company initially developed Hive ?
Why do we need buckets?
What are different Hive commands available for hive and beeline CLI?
What is the importance of driver in hive?
What are the various uses of explode hive?
What is the difference between Hive CLI and Beeline?
What is the reason for creating a new metastore_db whenever Hive query is run from a different directory?
Mention key components of Hive Architecture?
What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?
Mention Hive default read and write classes?
Why hive does not store metadata information in hdfs?
How would you drop a table in Hive?
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)