the same server.
It should only take one second to join two tables on two different databases
within the same plugin, but it takes 5 minutes in some cases to pull data from
two different plugins (one for each database) and join them together.
David Lee
Vice President | BlackRock
Phone: +1.415.670.2744 | Mobile: +1.415.706.6874
-Original Message-
From: Lee, David
Sent: Thursday, September 22, 2016 1:59 PM
To: user@drill.apache.org
Subject: RE: Drill Support for Sybase Plugin
As I suspected.. It looks like there is some sort of conflict between SQL
String Validator from Calcite vs the SQL Executor over the missing
"owner.objectname" prefix for Sybase tables.
I turned on verbose error messaging..
"a drill is a terrible thing to waste"
0: jdbc:drill:zk=local> SET `exec.errors.verbose` = true . . . . . . . . . . .
> ;
+---+---+
| ok |summary|
+---+---+
| true | exec.errors.verbose updated. |
+---+---+
0: jdbc:drill:zk=local> select * from SYBASE.tempdb.phone_book;
Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the
SQL query.
sql SELECT *
FROM "tempdb"."phone_book"
plugin SYBASE
Fragment 0:0
[Error Id: d8c05f9e-8a4e-48e5-925c-3ca6777da70c on .xx.x.com:31010]
(java.sql.SQLException) "tempdb"."phone_book" not found. Specify
owner.objectname or use sp_help to check whether the object exists (sp_help may
produce lotsof output).
I can reproduce this error messasge in SYBASE's native ISQL running:
select * from tempdb.phone_book
>[Error] Script lines: 29-29
tempdb.phone_book not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Msg: 208, Level: 16, State: 1
Server: SYB1T, Line: 1
The valid syntaxes are:
select * from phone_book
select * from tempdb..phone_book
select * from tempdb.guest.phone_book
This message may contain information that is confidential or privileged. If you
are not the intended recipient, please advise the sender immediately and delete
this message. See
http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for
further information. Please refer to
http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more
information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see
http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.
© 2016 BlackRock, Inc. All rights reserved.