am working to get percentage of GSM , DEPOT , IPMSAN ..Etc and I would like to sum the counts within each column that correspond to each WITH q2 AS ( SELECT c2.compteur, c1.police , ( SUM(c1….
Tag: impala
SQL+Fetch rows with latest date+Case when row_number()+Duplicates
I have a table with fields(id, date, product) with below sample data id date Product current_Flag Expected_flag 14834 2019-01-03 00:00:00 A 1 1 14834 2019-01-31 00:00:00 B 0 0 …
Hive Query : To calculate max indicator value based on priority and date
I tried to frame the query but somehow not getting the required result hence posting. I am new to hive. Apologies if it is very simple. Source Data : Ik – priority – ind1 – ind2 – date 1 – A – …
Selecting string after the last \ using regex with Impala SQL
I have a dataset with a column with processes and the path. I am trying to use regex with Impala to strip off the executable. The dataset looks like this: C:\Windows\System32\svchost.exe C:\…
Join two tables on id fields using Impala
I have two tables in in HDFS that I want to join using Impala. One is Employee_Logs the other is HR_Data. Queries: select e.employee_id, e.action from Employee_Logs e where e.employment_status_desc …