What is difference between internal and external tables in hive?
- 1 Answers
- 1335 Views
- I also Faced
- E-Mail Answers
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 |
Does Hive support record level Insert, delete or update?
How to Rename a table in Hive
Difference between external table and internal table in HIVE ?
What are the components of Hive architecture?
Explain process to access sub directories recursively in hive queries.
What will happen in case you have not issued the command?
Can you give us some examples, how Hadoop is used in real time environment?
Why hive does not store metadata information in hdfs?
What is the difference between Hiveserver1 and Hiveserver2?
What are the three different modes in which hive can be run?
How to Alter Hive Database?
What do you understand by 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)
