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 ?
734As part of optimizing the queries in hive, what should be the order of table size in a join query?
697Post New Apache Hive Questions
what is the difference between order by and sort by in Hive?
Can we change the data type of a column in a hive table?
Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?
Differentiate between hive and hbase?
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 default database provided by Apache Hive for metastore?
Explain about the different types of join in Hive?
What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;
What is the default location where hive stores table data?
What are types of hive built-in functions?
What is the use of Hcatalog?
Why do we need buckets?
How can hive avoid mapreduce?
What are the Binary Storage formats supported in Hive?
What are the 2 types of table in hive?