What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;
603While 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 ?
416As part of optimizing the queries in hive, what should be the order of table size in a join query?
424Post New Apache Hive Questions
How can you transfer data from hive to hdfs?
How to Write a UDF function in Hive?
What is available mechanism for connecting from applications, when we run hive as a server?
Mention what is HiveServer2 (HS2)?
What are the different Primitive Data Types available in Hive?
What will be the result when you do cast(‘abc’ as int)?
What is the difference between External and Internal Table in Hive?
Can you execute Hadoop dfs Commands from Hive CLI? How?
Explain the Use of Hive?
Explain how can you change a column data type in Hive?
What is the need for custom serde?
What is CONCATENATE command in Hive?
How do you write your own SerDe?
Why do we need hive?
What types of costs are associated with creating the index on hive tables?