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)
No Answer is Posted For this Question
Be the First to Post Answer
Give the command to see the indexes on a table?
Clarify about the smb join in hive?
How will you convert the string ’51.2’ to a float value in the price column?
When to use Hive?
Can we run unix shell commands from hive? Can hive queries be executed from script files? How? Give an example.
What are collection data types in Hive?
Mention the date data type in hive. Name the hive data type collection.
LOWER or LCASE function in Hive with example?
What is the need for custom serde?
How can you add a new partition for the month December in the above partitioned table?
What is Hive Present Version ?
Explain process to access sub directories recursively in hive queries.
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)