Questions tagged [hive]

Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
55 views

Hive query to get all rows where a particular column value lies in a particular precentile

I am trying to filter my rows in hive table named id_counts based on percentile values. Lets considers the following table. ...
1
vote
0answers
5 views

Hive Bring Table to Local Driver for Fast Debugging on CLI

I have a large Hive table on HDFS. Every time I query it, it runs a map reduce job which is slow. For debugging my code on CLI, I want a fast query. Is it possible to sample rows of the table and ...
1
vote
0answers
237 views

Mapreduce jobs not working in hive

I was trying to execute a hive query: select name, count(*) from amazon where review != NULL group by name ; Number of reduce tasks not specified. Estimated ...
0
votes
0answers
12 views

Failed: ParseException line 1:0 cannot recognize input near 'Closing' ':' '0' (state = 42000, code=40000)

While trying to exit the hive container in docker I am getting the following error: Error: Error while compiling statement:Failed: ParseException line 1:0 cannot recognize input near 'Closing' ':' '0' ...
0
votes
1answer
108 views

How to store subset of columns from a csv file?

I need to create a table in hive (or Impala) by reading from a csv file (named file.csv), ...