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 |
What do you understand by hive?
Explain the Use of Hive?
Explain SHOW and DESCRIBE Commands in Hive?
Explain about Hive Buckets with Example ?
How can client interact with Hive?
Say when to pick “inward table” and “outside table” in hive?
Mention what is the difference between Hbase and Hive?
Describe REVERSE function in Hive with example?
Hive new version supported Hadoop Versions ?
How do you list all databases whose name starts with p?
How do you write your own custom SerDe ?
When we are using queries instead of scripting?
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)