从mysql导数据到trafodion

1.安装odbc mysql驱动

yum install mysql-connector-odbc.x86_64

2.先配置/etc/odbc.ini （配置trafodion和mysql）odbc

[ODBC]
traceFlags = ERROR
TraceStart = 0
TraceFile = tracefile.log
MaxTraceFileSize = 1024
AppUnicodeType=utf16

[traf]
Description = traf instance in IDC vm 192.168.10.66
Driver = Trafodion
Catalog = TRAFODION
Schema = YOUE
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:192.168.10.66:23400
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = NO_TIMEOUT
ServiceName = HP_DEFAULT_SERVICE
ClientCharSet = UTF8

[mysql]
Driver      = MySQL
Description = mysql
SERVER      = 210.13.50.98
PORT        = 10039
USER        = root
Password    = youeDATA2016_
Database    = pachong
OPTION      = 3
Threading   = 1
CHARSET = UTF8

3.配置/etc/odbcinst.ini

[Trafodion]
Description = Trafodion ODBC Stand Alone Driver
Driver = /usr/lib64/libtrafodbc_drvr64.so
FileUsage = 1
UsageCount = 1
AppUnicodeType = utf16
Threading = 1

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1
[Trafodion]
Description = Trafodion ODBC Stand Alone Driver
Driver = /usr/lib64/libtrafodbc_drvr64.so
FileUsage = 1
UsageCount = 1
AppUnicodeType = utf16
Threading = 1

4. 在/usr/lib下创建软件链接（如果安装的时候这个目录没有下面库文件）

ln -s /usr/lib64/libodbcmyS.so libodbcmyS.so
ln -s /usr/lib64/libmyodbc5.so libmyodbc5.so

5. 测试链接

./odb64luo -u trafodion -p traf123 -d traf -i
./odb64luo -u root -p youeDATA2016_ -d mysql -x "select count(*) from pachong.clicks"

6.在trafodion创建表

create table test_mysql(
id int,
url varchar(200),
title varchar(400 BYTES) CHARACTER SET UTF8,
read_num int,
like_num int,
ts varchar(20),
month_date varchar(20)
);

7. 用odb导数据

./odb64luo -u root:trafodion -p youeDATA2016_:traf123 -d mysql:traf -cp src=TEST_ESGYN.CHECKS:tgt=trafodion.youe.test_mysql