acryljonny / dremio-sybase-connector Goto Github PK

I’m not sure if this is a problem with the Community Plug-In or with the ARP.

A normal SQL statement for Sybase would look something like:

select a.key, a.column_a, b.column_b
from mydb.dbo.my_table1 a
join mydb.dbo.my_table2 b on b.key = a.key

Dremio should be converting this internally to:

select mydb.dbo.my_table1.key, mydb.dbo.my_table1.column_a, mydb.dbo.my_table2.column_b
from mydb.dbo.my_table1
join mydb.dbo.my_table2 on mydb.dbo.my_table2.key = mydb.dbo.my_table1.key

However in the logs I'm seeing:

select mydb.my_table1.key, mydb.my_table1.column_a, mydb.my_table2.column_b
from mydb.dbo.my_table1
join mydb.dbo.my_table2 on mydb.my_table2.key = mydb.my_table1.key

"dbo" is missing from the columns and where conditions..

Hi,

I have encounter issue that user defined datatype can't be read. I tried to define the type in ARP but no luck.

Example

user_id_type which is char in sybase

Error

Source XXX returned error 'JZ0P8: The RSMDA Column Type Name you requested is unknown. This is a SAP internal error; please report it to technical support.

I built the plug-in with Dremio 3.3.2 and I ran into several problems. (Modified POM.xml with Dremio 3.3.2)

A. Only system tables show up in Sources. I see all the sys* tables under dbo, but I don't see any other dbo or non-dbo tables.

B. The Source catalog froze when building the list of sources. It managed to catalog 18 databases from A to C, but froze trying to catalog database D to Z. We have a pretty large Sybase ASE installation with over a hundred databases on the server.

I used my own non-DBO login to setup the Sybase ASE connection in Dremio.

Can we force a skip on tempdb when setting up a Sybase connection.

Right now it just spins and never finishes. If I Cancel the setup and Restart the server I can see the Sybase datasource and all database from "a???" to "tempdb", but other databases after tempdb are not showing up and are not accessible even if I manually put the database into the web url.

For example if I had the following databases:

sales_db
tempdb
trade_db

If I force the setup to cancel and restart the server, I just see:
sales_db
tempdb

tempdb is a odd beast and I think the setup is crashing on it..