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 xxxx.xx.xxxxx.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.
|