Hello, I am trying to use the JDBC plugin with DB2 and have some issues: I am connected to a particular database using the DB in the JDBC url. Thing look good: I can see metadata and I can interrogate tables:
jdbc:drill:zk=local> show schemas; +-----------------------+ | SCHEMA_NAME | +-----------------------+ | INFORMATION_SCHEMA | | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | gs_db.GOSALES | | gs_db.GOSALESDW | | gs_db.GOSALESHR | | gs_db.GOSALESMR | | gs_db.GOSALESRT | | gs_db.MPIERRE | | gs_db.NULLID | | gs_db.SQLJ | | gs_db.SYSCAT | | gs_db.SYSFUN | | gs_db.SYSIBM | | gs_db.SYSIBMADM | | gs_db.SYSIBMINTERNAL | | gs_db.SYSIBMTS | | gs_db.SYSPROC | | gs_db.SYSPUBLIC | | gs_db.SYSSTAT | | gs_db.SYSTOOLS | | gs_db | | sys | +-----------------------+ 25 rows selected (0,226 seconds) 0: jdbc:drill:zk=local> show tables in gs_db.GOSALES; +----------------+-----------------------+ | TABLE_SCHEMA | TABLE_NAME | +----------------+-----------------------+ | gs_db.GOSALES | BRANCH | | gs_db.GOSALES | CONVERSION_RATE | | gs_db.GOSALES | COUNTRY | | gs_db.GOSALES | CURRENCY_LOOKUP | | gs_db.GOSALES | EURO_CONVERSION | | gs_db.GOSALES | INVENTORY_LEVELS | | gs_db.GOSALES | ORDER_DETAILS | | gs_db.GOSALES | ORDER_HEADER | | gs_db.GOSALES | ORDER_METHOD | | gs_db.GOSALES | PRODUCT | | gs_db.GOSALES | PRODUCT_BRAND | | gs_db.GOSALES | PRODUCT_COLOR_LOOKUP | | gs_db.GOSALES | PRODUCT_FORECAST | | gs_db.GOSALES | PRODUCT_LINE | | gs_db.GOSALES | PRODUCT_NAME_LOOKUP | | gs_db.GOSALES | PRODUCT_SIZE_LOOKUP | | gs_db.GOSALES | PRODUCT_TYPE | | gs_db.GOSALES | RETURNED_ITEM | | gs_db.GOSALES | RETURN_REASON | | gs_db.GOSALES | SALES_REGION | | gs_db.GOSALES | SALES_TARGET | | gs_db.GOSALES | TIME_DIMENSION | | gs_db.GOSALES | TIME_QUARTER_LOOKUP | | gs_db.GOSALES | XGOREV | +----------------+-----------------------+ 24 rows selected (0,232 seconds) 0: jdbc:drill:zk=local> describe gs_db.GOSALES.BRANCH; +------------------------+--------------------+--------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +------------------------+--------------------+--------------+ | BRANCH_CODE | INTEGER | NO | | ADDRESS1 | CHARACTER VARYING | NO | | ADDRESS1_MB | CHARACTER VARYING | YES | | ADDRESS2 | CHARACTER VARYING | YES | | ADDRESS2_MB | CHARACTER VARYING | YES | | CITY | CHARACTER VARYING | NO | | CITY_MB | CHARACTER VARYING | NO | | PROV_STATE | CHARACTER VARYING | YES | | PROV_STATE_MB | CHARACTER VARYING | YES | | POSTAL_ZONE | CHARACTER VARYING | NO | | COUNTRY_CODE | INTEGER | NO | | ORGANIZATION_CODE | CHARACTER VARYING | NO | | WAREHOUSE_BRANCH_CODE | INTEGER | NO | +------------------------+--------------------+--------------+ 13 rows selected (0,216 seconds) However, when accessing a table I get: --------------------------------------- 0: jdbc:drill:zk=local> select * from gs_db.GOSALES.BRANCH; Error: DATA_READ ERROR: Failure while attempting to read from database. sql SELECT * FROM "GOSALES"."BRANCH" plugin gs_db Fragment 0:0 [Error Id: bbd65e6c-6a85-460b-8d70-80c1333ed23b on mpie-mbp.lan:31010] (state=,code=0) 0: jdbc:drill:zk=local> select * from gs_db.GOSALES.COUNTRY; Error: DATA_READ ERROR: Failure while attempting to read from database. sql SELECT * FROM "GOSALES"."COUNTRY" plugin gs_db Fragment 0:0 [Error Id: 871474a1-ddf8-474b-b1c5-3231980bda62 on mpie-mbp.lan:31010] (state=,code=0) ——————————————————— Anyone seen this? (I am using an own build so I could try the official drop) Regards, Magnus
