python:

# -*- coding: utf-8 -*-

import sys

for line in sys.stdin:
    values = line.split('\t')
    value = [i.strip() for i in values]
    print '\t'.join([value[0],value[1])

 

hql:

add file /data/pyscrip/hive_python.py

select transform(id,name) using "python hive_python.py" as(id,name) from tbtest;