def test322_hive_to_mysql(self): try: legoo.hive_to_mysql(hive_node = self.hive_node, hive_db = self.hive_db, \ hive_table = self.hive_table, \ mapred_job_priority='VERY_HIGH', csv_delimiter='tab', \ mysql_host = self.mysql_host, mysql_db = self.mysql_db, \ mysql_table = self.mysql_table) except: self.fail("hive_to_mysql failed")
def test326_hive_to_mysql(self): try: query = "select * from %s.%s limit 10" % ( self.hive_db, self.hive_table) legoo.hive_to_mysql(hive_node = self.hive_node, hive_db = self.hive_db, \ hive_table = self.hive_table, hive_query = query, \ mapred_job_priority='VERY_HIGH', csv_delimiter='tab', \ mysql_host = self.mysql_host, mysql_db = self.mysql_db, \ mysql_truncate_table = 'Y', mysql_table = self.mysql_table) except: self.fail("hive_to_mysql with option mysql_truncate_table failed")
def test326_hive_to_mysql(self): try: query = "select * from %s.%s limit 10" % (self.hive_db, self.hive_table) legoo.hive_to_mysql(hive_node = self.hive_node, hive_db = self.hive_db, \ hive_table = self.hive_table, hive_query = query, \ mapred_job_priority='VERY_HIGH', csv_delimiter='tab', \ mysql_host = self.mysql_host, mysql_db = self.mysql_db, \ mysql_truncate_table = 'Y', mysql_table = self.mysql_table) except: self.fail("hive_to_mysql with option mysql_truncate_table failed")
def test320_hive_to_mysql(self): try: ddl = "drop table if exists %s.%s" % ( self.mysql_db, self.mysql_table) legoo.execute_mysql_query(mysql_host = self.mysql_host, \ mysql_db = self.mysql_db, \ mysql_query = ddl) legoo.hive_to_mysql(hive_node = self.hive_node, hive_db = self.hive_db, \ hive_table = self.hive_table, \ mapred_job_priority='VERY_HIGH', csv_delimiter='tab', \ mysql_host = self.mysql_host, mysql_db = self.mysql_db, \ mysql_create_table='Y', mysql_table = self.mysql_table) except: self.fail("hive_to_mysql with optiion mysql_create_table failed")
def test322_hive_to_mysql(self): try: legoo.hive_to_mysql( hive_node=self.hive_node, hive_db=self.hive_db, hive_table=self.hive_table, mapred_job_priority="VERY_HIGH", csv_delimiter="tab", mysql_host=self.mysql_host, mysql_db=self.mysql_db, mysql_table=self.mysql_table, ) except: self.fail("hive_to_mysql failed")
def test320_hive_to_mysql(self): try: ddl = "drop table if exists %s.%s" % (self.mysql_db, self.mysql_table) legoo.execute_mysql_query(mysql_host = self.mysql_host, \ mysql_db = self.mysql_db, \ mysql_query = ddl) legoo.hive_to_mysql(hive_node = self.hive_node, hive_db = self.hive_db, \ hive_table = self.hive_table, \ mapred_job_priority='VERY_HIGH', csv_delimiter='tab', \ mysql_host = self.mysql_host, mysql_db = self.mysql_db, \ mysql_create_table='Y', mysql_table = self.mysql_table) except: self.fail("hive_to_mysql with optiion mysql_create_table failed")
def test324_hive_to_mysql(self): try: query = "select * from %s.%s limit 10" % (self.hive_db, self.hive_table) legoo.hive_to_mysql( hive_node=self.hive_node, hive_db=self.hive_db, hive_table=self.hive_table, hive_query=query, mapred_job_priority="VERY_HIGH", csv_delimiter="tab", mysql_host=self.mysql_host, mysql_db=self.mysql_db, mysql_table=self.mysql_table, ) except: self.fail("hive_to_mysql with option mysql_query failed")