Python hive_to_mysql Examples

Example #1

File: unittest_legoo.py Project: bopopescu/legoo-1

 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")

Example #2

File: unittest_legoo.py Project: vangulo-trulia/legoo

 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") 

Example #3

File: unittest_legoo.py Project: vangulo-trulia/legoo

 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") 

Example #4

File: unittest_legoo.py Project: bopopescu/legoo-1

 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")

Example #5

File: unittest_legoo.py Project: vangulo-trulia/legoo

 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") 

Example #6

File: unittest_legoo.py Project: qfluo/legoo

 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")

Example #7

File: unittest_legoo.py Project: bopopescu/legoo-1

 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")

Example #8

File: unittest_legoo.py Project: qfluo/legoo

 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")