Trafodion odb 安装及使用

1 什么是odb

odb是一款平台无关的，多线程的，基于ODBC的命令行工具。

Trafodion数据库使用odb来做以下事情：

并行数据加载/抽取

查询驱动

SQL解释器

2 安装配置Trafodion ODBC Driver

(1) 下载unixODBC

[centos@cent-1 clients]$ sudo yum install unixODBC -y[centos@cent-1 clients]$ ll /etc/odbc*-rw-r--r--. 1 root root   0 Jul 10  2014 /etc/odbc.ini-rw-r--r--. 1 root root 575 Jul 10  2014 /etc/odbcinst.ini

(2) 下载Trafodion Client，下载地址：http://apache.fayea.com/incubator/trafodion/apache-trafodion-2.0.1-incubating/apache-trafodion_clients-2.0.1-incubating.tar.gz

(3) 解压安装包，然后解压压缩包TRAF_ODBC_Linux_Driver_64.tar.gz

(4) 在PkgTmp执行安装install.sh文件

[centos@cent-1 clients]$ cd PkgTmp/[centos@cent-1 PkgTmp]$ lsconnect_test.cpp  libicudata.so.44  libtrafodbc_l64_drvr.so  license.txt  TRAFDSNinstall.sh        libicuuc.so.44    libtrafodbc_l64.so       MD5SUM[centos@cent-1 PkgTmp]$ sudo ./install.sh

(5) 修改TRAFDSN文件中的Trafodion数据库的IP并测试连接

[centos@cent-1 odbc]$ sudo ./connect_test -d Default_DataSource -u trafodion -p traf123Using Connect String: DSN=Default_DataSource;UID=trafodion;PWD=traf123;Connect Test Passed...

3 安装odb

(1) odb压缩已经包含在Trafodion Client安装包中，解压odb64_linux.tar.gz，在bin目录中找到odb64luo

[centos@cent-1 bin]$ lsodb64luo

(2) 通过如下命令查看odb命令帮助

[centos@cent-1 bin]$ ./odb64luo -hodb version 1.1.0Build: linux, amd64, gcc generic m64, uodbc, mreadline, dynamic gzip, dynamic libhdfs, dynamic libxml2 [Jun 24 2016 17:41:59]   -h: print this help   -version: print odb version and exit   -lsdrv: list available drivers @ Driver Manager level   -lsdsn: list available Data Sources......

(3) 配置odbc.ini和odbcinst.int文件

[centos@cent-1 bin]$ cat /etc/odbc.ini[ODBC]AppUnicodeType=utf16[traf]Description                 = Trafodion DSNDriver                      = TrafodionCatalog                     = TRAFODIONSchema                      = SEABASEDataLang                    = 0FetchBufferSize             = SYSTEM_DEFAULTServer                      = TCP:192.168.0.16:23400SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULTSQL_LOGIN_TIMEOUT           = SYSTEM_DEFAULTSQL_QUERY_TIMEOUT           = NO_TIMEOUTServiceName                 = TRAFODION_DEFAULT_SERVICE[centos@cent-1 odbc]$ cat /etc/odbcinst.ini# Example driver definitions# Driver from the trafodion odbc package# Setup from the unixODBC package[Trafodion]Description     = ODBC for TrafodionDriver64        = /usr/lib64/libtrafodbc_drvr64.soSetup64         = /usr/lib64/libtrafodbc_drvr64.soFileUsage       = 1AppUnicodeType  = utf16Threading       = 1

(4)测试配置是否正确

[centos@cent-1 bin]$ sudo ./odb64luo -lsdrvPostgreSQL - Description=ODBC for PostgreSQLMySQL - Description=ODBC for MySQLTrafodion - Description=ODBC for Trafodion

(5) 测试能否连接到指定数据源

[centos@cent-1 bin]$ sudo ./odb64luo -u trafodion -p traf123 -d traf -iodb [2016-09-26 06:19:14]: starting ODBC connection(s)... 0        [odb version 1.1.0]        Build: linux, amd64, gcc generic m64, uodbc, mreadline, dynamic gzip, dynamic libhdfs, dynamic libxml2 [Jun 24 2016 17:41:59]        DBMS product name (SQL_DBMS_NAME)            : Trafodion        DBMS product version (SQL_DBMS_VER)          : 02.01.0000        Database name (SQL_DATABASE_NAME)            : TRAFODION        Server name (SQL_SERVER_NAME)                : cent-1.novalocal($Z000PDF){TCP:192.168.0.16/23402:ODBC}        Data source name (SQL_DATA_SOURCE_NAME)      : traf        Data source RO (SQL_DATA_SOURCE_READ_ONLY)   : N        ODBC Driver name (SQL_DRIVER_NAME)           : libtrafodbc64.so        ODBC Driver version (SQL_DRIVER_VER)         : 03.00.0000        ODBC Driver level (SQL_DRIVER_ODBC_VER)      : 03.51        ODBC Driver Manager version (SQL_DM_VER)     : 03.52.0002.0002        ODBC Driver Manager level (SQL_ODBC_VER)     : 03.52        Connection Packet Size (SQL_ATTR_PACKET_SIZE): 0odb [2016-09-26 06:19:14]: exiting. Session Elapsed time 0.070 seconds (00:00:00.070)

4 使用odb

(1) 列出某个schema下面的所有表

[centos@cent-1 bin]$ sudo ./odb64luo -u trafodion -p traf123 -d traf -i t:TRAFODION.SEABASEodb [2016-09-26 06:28:29]: starting ODBC connection(s)... 0Connected to TrafodionSEABASE.T1odb [2016-09-26 06:28:30]: exiting. Session Elapsed time 0.310 seconds (00:00:00.310)

(2) 列出某个表的DDL语句

[centos@cent-1 bin]$ sudo ./odb64luo -u trafodion -p traf123 -d traf -x "showddl seabase.t1"odb [2016-09-26 06:40:50]: starting ODBC connection(s)... 0CREATE TABLE TRAFODION.SEABASE.T1  (    ID                               INT DEFAULT NULL SERIALIZED  );[0.0.0]--- command executed in 4.943s (prep 0.822s, exec 4.119s, fetch 0.002s/0.001s)odb [2016-09-26 06:40:59]: exiting. Session Elapsed time 8.614 seconds (00:00:08.614)

(3) 更多odb命令请见后续文章…