What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;
921While loading data into a hive table using the load data clause, how do you specify it is a hdfs file and not a local file ?
730As part of optimizing the queries in hive, what should be the order of table size in a join query?
697Post New Apache Hive Questions
when to choose “internal table” and “external table” in hive?
How to optimize Hive Performance?
What are the default record and field delimiter used for hive text files?
What is “serde” in “hive”?
Explain what is Hive?
Difference between order by and sort by in Hive?
what are views in Hive?
What is the functionality of Query Processor in Apache Hive?
Mention the date data type in hive. Name the hive data type collection.
How do we write our own custom serde?
Does Hive support record level Insert, delete or update?
How to enable buckets in Hive?
Mention what are the type of database does Hive support ?
How to managed create a table in hive ?
What are the file formats that Hive supports and can use be used for storage?