def test302_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive failed")
def test304_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, remove_carriage_return='Y', \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive with option remove_carriage_return failed")
def test302_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive failed")
def test304_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, remove_carriage_return='Y', \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail(
"mysql_to_hive with option remove_carriage_return failed")
def test306_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
query = "select * from %s.%s limit 10" % ( self.mysql_db, self.mysql_table)
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, mysql_query = query, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive with option mysql_query failed")
def test306_mysql_to_hive_table(self):
try:
# export mysql table to existing hive table
query = "select * from %s.%s limit 10" % (self.mysql_db,
self.mysql_table)
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, mysql_query = query, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive with option mysql_query failed")
def test300_mysql_to_hive(self):
try:
# drop table if exists
ddl = "drop table if exists %s.%s" % ( self.hive_db, self.hive_table)
legoo.execute_remote_hive_query(hive_node = self.hive_node, \
hive_db = self.hive_db, \
hive_query = ddl)
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, hive_create_table='Y', \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive with option hive_create_table failed")
def test300_mysql_to_hive(self):
try:
# drop table if exists
ddl = "drop table if exists %s.%s" % (self.hive_db,
self.hive_table)
legoo.execute_remote_hive_query(hive_node = self.hive_node, \
hive_db = self.hive_db, \
hive_query = ddl)
legoo.mysql_to_hive(mysql_host = self.mysql_host, mysql_db = self.mysql_db, \
mysql_table = self.mysql_table, \
hive_node = self.hive_node, hive_db = self.hive_db, \
hive_table = self.hive_table, hive_create_table='Y', \
mapred_job_priority='VERY_HIGH', csv_delimiter='tab')
except:
self.fail("mysql_to_hive with option hive_create_table failed")
