https://medium.com/@mmas/querying-in-hive-4d772e6f2c66

who_mapper.py

#!/usr/bin/env python

import sys

for line in sys.stdin:
    if line.startswith('"'):
        index = line.find('"', 1)
        fields = [line[1:index]]+line[index+2:].split(',')
    else:
        fields = line.split(',')
    print '\t'.join([
        fields[1],  # Id.
        fields[0],  # Name.
        fields[2],  # Continent id.
        str(int(fields[8])*1000) if fields[8] else '',  # Population.
        str(float(fields[10])/100) if fields[10] else '',  # Urban population.
        str(float(fields[14])/100) if fields[14] else '',  # Population > 60.
        str(float(fields[15])/100) if fields[15] else '',  # Population < 15.
        fields[5],  # GNI per capita.
        fields[129]])  # Life expectancy.