Top "Hive" questions

Hive is a database built on top of Hadoop and facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible distributed file system.

How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How …

hadoop hive sql-delete
How to know Hive and Hadoop versions from command prompt?

How can I find which Hive version I am using from the command prompt. Below is the details- I am …

hadoop hive
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like …

sql hadoop hive hiveql
How to select current date in Hive SQL

How do we get the current system date in Hive? In MySQL we have select now(), can any one please …

hive hiveql
How to Update/Drop a Hive Partition?

After adding a partition to an external table in Hive, how can I update/drop it?

hive hiveql
Difference between Pig and Hive? Why have both?

My background - 4 weeks old in the Hadoop world. Dabbled a bit in Hive, Pig and Hadoop using Cloudera's Hadoop …

hadoop hive apache-pig
How to set variables in HIVE scripts

I'm looking for the SQL equivalent of SET varname = value in Hive QL I know I can do something like …

hive hiveql
How to export a Hive table into a CSV file?

I used this Hive query to export a table into a CSV file. INSERT OVERWRITE DIRECTORY '/user/data/output/…

csv hive
What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

I am getting: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask While trying to make …

hadoop mapreduce hive
How do I output the results of a HiveQL query to CSV?

we would like to put the results of a Hive query to a CSV file. I thought the command should …

database hadoop hive hiveql