Python - Hive Commands Using Subprocess - Empty Results
I'm using subprocess to run hive commands in python, but am getting empty results. If i run the same commands from hive CLI, am getting results. query = 'set hive.cli.print.head
Solution 1:
myfile=open("query_result.tsv", 'w')
p=subprocess.Popen("your query",
shell=True,
stdout=myfile,stderr=subprocess.PIPE)
stdout,stderr = p.communicate()
if p.returncode != 0:
print stderr
sys.exit(1)
myfile is a tsv file,you can use pandas.read_csv(sep='\t') and set sep='\t' ,you may need to look up pandas api to find more usage about read_csv().
you should look up subprocess api in 17.1.2 about Popen Object.it gives you a warning about stdout=PIPE. https://docs.python.org/2/library/subprocess.html#frequently-used-arguments
Post a Comment for "Python - Hive Commands Using Subprocess - Empty Results"