I have my current sql query which I will later convert to a HIVE query. SELECT home_team, COUNT(home_team) from results WHERE results.home_score < results.away_score GROUP BY home_team UNION SELECT away_team, COUNT(away_team) FROM results WHERE results.away_score < results.home_score GROUP BY away_team…
I am trying to count, for each id, the number of distinct app downloaded by the user, grouping the count by category. An example of the separate queries are as such: SELECT id ,COUNT(DISTINCT app) AS gaming_apps FROM apps_table WHERE…
I'm trying to create a new table in Apache Hive, which loads the data from a CSV file. I wrote this script CREATE SCHEMA IF NOT EXISTS practica2; CREATE EXTERNAL TABLE IF NOT EXISTS practica2.station_data (IDPROVINCIA string, SPROVINCIA string, IDESTACION…