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 |
Is there a date data type in Hive?
Is Hive supports Temporary Tables?
How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?
What is the prerequisite for Apache Hive installation?
In which scenario Hive is good fit?
Explain how Hive Deserialize and serialize the data?
Explain about Hive Buckets with Example ?
Can you give us some examples, how Hadoop is used in real time environment?
What is the significance of ‘IF EXISTS” clause while dropping a table?
In case of embedded Hive, can the same metastore be used by multiple users?
When executing Hive queries in different directories, why is metastore_db created in all places from where Hive is launched?
Mention what is ObjectInspector functionality 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)