I have a table with three columns, A, B, and Score, where A and B are some items, and Score
is some kind of affinity between A and B. There are N number of items of each A and B, so
that the total number of rows in the table are N^2.
Is there a way to fetch "top 5 items in B" for each item in A? So, for each distinct item
in A, I want to look up 5 items in B which have the highest value in Score.
Hi Experts,
I'm working with Teradata query conversion to hive environment (Hive
version 0.10.0).The challenge that am facing here is in converting the
below line in query.
In SELECT clause:
ROW_NUMBER() OVER (PARTITION BY CLMST_KEY2
ORDER BY COUNTER) AS CLMST_ORDR_NBR
When searched found like instead of ROW_NUMBER() I can go with
ROW_SEQUENCE using UDF. what to do with OVER clause and
Hi,
Does Hive have any function equivalent to Oracle's dense_rank (
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/functions038.htm)
function? Here's what I'm trying to do:
For each user, I want to sort the page views in ascending order of time, and
then number each page view with it's rank. This will enable me to easily
identify a particular user's first page view, second page view
Hi,
=20
Is there a hive equivalent to Oracle's rownum, row_number() or the abili=
ty to
loop through a resultset?
=20
I have been struggling to create a hive query that will give me max X
records, per something, when sorted by something. For example, I have=
book
data, multiple records for any given isbn, and want the lowest 5 priced=
books
per isbn.
=20
I can accomplish this in oracle with
Hi,
select row_number() over (PARTITION BY
country,state,department,branch_name) from Employee_details;
select count(*) over (PARTITION BY country,state,department,branch_name)
from Employee_details;
These queries throw Error when Employee_details table has zero rows
They work great if the table is not Empty.
Is there any Limitation using this UDF's with Null Input? Please Help me
guys
I’m curious what the status of implementing hive analytics functions in
spark.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics
Many of these seem missing. I’m assuming they’re not implemented yet?
Is there an ETA on them?
or am I the first to bring this up? :-P
Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator
Hi,
Need to create a view in HIVE as per the below query (written in Oracle).
Need help to provide the equivalent query in HIVE to create view.
*EMP_ADDRESS*
Emp_Id
Address1
Address2
Address3
Address4
City
State
Pin
Country
Alternate_Address1
Alternate_Address2
Alternate_Address3
Alternate_Address4
Alternate_City
Alternate_State
Alternate_Pin
Alternate_Country
row_create_date
Hi Experts,
I am looking for some thing which works in hive and want to see if you have
anything equivalent to it in IMPALA.
SET hive.exec.dynamic.partition = true;
SET hive.exec.dynamic.partition.mode = nonstrict;
SET hive.exec.max.dynamic.partitions.pernode`00;
SET hive.exec.max.dynamic.partitions`00;
How you do the same thing in IMPALA?
Thanks
Deepak Gattala
To unsubscribe from
As far as I understand, there is no equivalent of MySQL group_concat() in Hive. This stackoverflow
question is from Sept 2010: http://stackoverflow.com/questions/3703740/combine-multiple-rows-into-one-space-separated-string
Does anyone know any other method to create a delimited list from from table rows? There are
a few methods listed in Anthony Molinaro's SQL Cookbook, but all of them use over(
Hi ,
While Hive doesn't supports multi-value LIKE queries which are supported in
SQL : ex.
SELECT * FROM user_table WHERE first_name LIKE ANY ( 'root~%' , 'user~%' );
We can convert it into equivalent HIVE queries as :
SELECT * FROM user_table WHERE first_name LIKE 'root~%' OR first_name
LIKE 'user~%'
Does anyone know an equivalent solution that Hive does support in case
sub-query
