在trafodion数据库查询mysql数据库的表和oracle的表

1. 配置说明：

select ... from udf(JDBC(
      <name of JDBC driver jar>,                ----JDBC驱动jar包
      <name of JDBC driver class in the jar>,   ----类名
      <connection string>,                      ----连接串
      <user name>,                              ----数据库用户名
      <password>,                               ----密码
      <statement_type>,                         ----source
      <sql statement 1>                         ----sql语句
      [ , <sql statements 2 ...n> ] )) ...

2. 配置在trafodion中查询mysql数据库的表

select *
from udf(jdbc('mysql-connector-java-5.1.44-bin.jar',
	'com.mysql.jdbc.Driver',
	'jdbc:mysql://192.168.1.6:3636/TEST_ESGYN',
	'root',
	'123456',
	'source',
	'select count(*) from test_table'));

3. 配置trafodion中查询oracle的表

select *
from udf(jdbc('ojdbc6.jar',
              'oracle.jdbc.driver.OracleDriver',
              'jdbc:oracle:thin:@192.168.1.6:1521:esgyn',
              'sys',
              '123456',
              'source',
              'select * from dual'));