Questions tagged [hive]
Questions about Hive and HiveQL.
14
questions
0
votes
0answers
19 views
Sum of integers between two rows in Hive
Suppose I have a Hive table that looks like this:
a b
41 77
8 32
31 76
I would like to have another column say c which applies a function that loops through all integers between columns a ...
0
votes
0answers
31 views
Do Hive Materialized Views respond to added partitions to source tables?
Hive Materialized Views support partitions,
CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name
[DISABLE REWRITE]
[COMMENT materialized_view_comment]
[PARTITIONED ON (...
0
votes
0answers
10 views
HIVE SQL - JOIN
I am trying to perform a left join between tables. The syntax looks something like this:
select a.x1, a.x2, a.x3, b.y1 from a left join b on a.x1=b.x1
Ideally, the query should give all records that ...
0
votes
0answers
15 views
Join hive tables which are being populated in real time
I have two tables in hive which are being populated in real time from a set of files. There is a request_time and trx_id columns in both tables where trx_id is the joining key.
I want to join them ...
1
vote
0answers
232 views
Hive query with RANK() in a WHERE clause
I want to do this, to get all the rows for a given a,b combo that have the highest value of c:
SELECT a, b, c
FROM x
WHERE RANK() OVER (PARTITION BY a,b ORDER BY c DESC) = 1
It fails, saying invalid ...
1
vote
1answer
116 views
“Error while processing statement” running a query finding unique values with multiple values in other rows
Is there anything wrong in the syntax of this query finding unique values with multiple values in other rows?
Select Distinct Ss.`cd`, Ss.`cd`
From nit.assrr As Ss
Join (
Select `cd`
...
2
votes
1answer
75 views
joining the where clause to select statement of two different tables [closed]
How can I properly structure the below query to make it work? I would like to have the Ref_CD = MBR_ID_TYPE_ID to be my select statement on the beginning of it.
select MBR_ID_TYP_ID || '-' || (
...
0
votes
1answer
49 views
User specific default database in Hive
I am running a Oracle Big Data Appliance platform that has Cloudera EDH 5.9.x running under the hood. My users are mainly using beeswax, which is the Hive query editor app within Hue.
When a user ...
1
vote
1answer
74 views
Hive metrastore Database in Postgresql External [closed]
We recently migrated hive metastore database from embedded postgresql(coming with cloudera hadoop) to external postgresql(standalone in vm server). After that we notified that there is increase of 5 ...
2
votes
2answers
1k views
How can I group the null results in this FULL OUTER JOIN with non-null responses?
I am looking at the overlap and non-overlap (unique values) of users-ids from two different select statements using a full join. The main differentiation being that one table will have a deal_id = 0 ...
0
votes
1answer
2k views
Hive. Over partition by vs where conditions
I have a table partitioned this way.
# Partition Information
# col_name data_type
year string
month string
day string
hour ...
1
vote
1answer
431 views
how to insert data into extra columns of target avro table when source table is having less no of columns compared to target using hive or impala?
Suppose I am having a source avro table having 10 columns and my target avro table is having 12 columns, while inserting data into target table I need to add null values to extra 2 columns.
But when ...
4
votes
1answer
6k views
Cumulative sum using hiveql
I have a table in Hive which looks like:
col1 col2
b 1
b 2
a 3
b 2
c 4
c 5
How do I, with hiveql, group up col1 elements together, ...
4
votes
1answer
4k views
correlate subquery in hive
SELECT ndo.sku ParentSKU, visitsWhenSKUWasOnline.s
FROM
Temp.NumberOfDaysOnline ndo
JOIN
(
SELECT SUM(gasessiondata.sessions) as s
FROM gasessiondata
WHERE
gasessiondata.date >= ...
