Hive MAPJOIN + LATERAL VIEW

test.php

execute("SELECT
            date_int,
            gender,
            part,
            COUNT( DISTINCT member_id ),
            SUM( partcount )
        FROM (
            SELECT
                /*+ MAPJOIN(members_map) */
                date_int,
                visit_stats.member_id,
                members_map.gender as gender,
                parts
            FROM visit_stats
            JOIN members_map ON(members_map.member_id = visit_stats.member_id)
        ) visit_stats
        LATERAL VIEW explode(parts) partsTable AS part, partcount
        GROUP BY date_int, gender, part");