python读取mysql表，并自动在hive上建表

import  pymysql
import  re
import  sys
import  os

def get_table_info(database,table,host,user,password,db,is_partitioned):
    cols = []
    create_head = '''create table if not exists {0}.{1}('''.format(database,table)
        if is_partitioned == 'Y':
        create_tail = r'''partitioned by(d_date string) stored as parquet;'''.format(table)
    else:
        create_tail = r'''stored as parquet;'''.format(table)
    connection=pymysql.connect(host='{0}'.format(host),
                user='{0}'.format(user),
                password='{0}'.format(password),
                db='{0}'.format(d