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)
788Post New Apache Hive Questions
When you are dealing with static data instead of dynamic data?
What is the difference between the external table and managed table?
What is the definition of Hive?
Can we run unix shell commands from hive? Give example?
Clarify about the smb join in hive?
What is the major difference between local and remote meta-store?
Is it possible to use same metastore by multiple users, in case of embedded hive?
In case of embedded Hive, can the same metastore be used by multiple users?
What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;
What is CONCATENATE command in Hive?
What is the significance of the line set hive.mapred.mode = strict;?
what does /*streamtable(table_name)*/ do?
What is the default location where hive stores table data?
When you point a partition of a hive table to a new directory, what happens to the data?
What is the precedence order of hive configuration?