Write a query to insert a new column(new_col int) into a hiev table (htab) at a position before an existing column (x_col)
What is a metastore in hive?
What is the importance of driver in hive?
How can hive avoid mapreduce?
What are hive operators and its types?
when to choose “internal table” and “external table” in hive?
How do you specify the table creator name when creating a table in hive?
what is partitions in hive?
What do you mean by schema on read?
What will be the result when you do cast(‘abc’ as int)?
If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?
How will you convert the string ’51.2’ to a float value in the price column?
What is the maximum size of string data type supported by hive? Mention the hive support binary formats.
What is available mechanism for connecting from applications, when we run hive as a server?
If you run a select * query in hive, why does it not run mapreduce?