[
https://issues.apache.org/jira/browse/DRILL-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated DRILL-5626:
------------------------------
Description:
Plugin defined to access ORACLE 12C2 via JDBC
Following query sent to Drill
select TJOIN1.RNUM, TJOIN1.C1, TJOIN1.C2, TJOIN2.C2 as C2J2 from
certora.DBCERT.TJOIN1 inner join certora.DBCERT.TJOIN2 on ( TJOIN1.C1 =
TJOIN2.C1 and TJOIN2.C1 between 15 and 25 )
Fails with DATA_READ ERROR: The JDBC storage plugin failed while trying setup
the SQL query.
SELECT "C1", "C2", "C1" >= 15 "$f3", "C1" <= 25 "$f4"
FROM "DBCERT"."TJOIN2"
ORACLE DDL
CREATE TABLE "DBCERT"."TJOIN1"
( "RNUM" NUMBER(*,0),
"C1" NUMBER(*,0),
"C2" NUMBER(*,0)
) ;
GRANT SELECT ON "DBCERT"."TJOIN1" TO PUBLIC;
--------------------------------------------------------
-- DDL for Table TJOIN2
--------------------------------------------------------
CREATE TABLE "DBCERT"."TJOIN2"
( "RNUM" NUMBER(*,0),
"C1" NUMBER(*,0),
"C2" CHAR(2 BYTE)
) ;
GRANT SELECT ON "DBCERT"."TJOIN2" TO PUBLIC;
Other examples
select TJOIN1.RNUM, TJOIN1.C1, TJOIN1.C2, TJOIN2.C2 as C2J2 from
certora.DBCERT.TJOIN1 inner join certora.DBCERT.TJOIN2 on ( TJOIN1.C1 =
TJOIN2.C1 and TJOIN2.C2 like 'A%' )
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL
query.
sql SELECT "C1", "C2", "C2" LIKE 'A%' "$f3"
FROM "DBCERT"."TJOIN2"
was:
Plugin defined to access ORACLE 12C2 via JDBC
Following query sent to Drill
select TJOIN1.RNUM, TJOIN1.C1, TJOIN1.C2, TJOIN2.C2 as C2J2 from
certora.DBCERT.TJOIN1 inner join certora.DBCERT.TJOIN2 on ( TJOIN1.C1 =
TJOIN2.C1 and TJOIN2.C1 between 15 and 25 )
Fails with DATA_READ ERROR: The JDBC storage plugin failed while trying setup
the SQL query.
SELECT "C1", "C2", "C1" >= 15 "$f3", "C1" <= 25 "$f4"
FROM "DBCERT"."TJOIN2"
ORACLE DDL
CREATE TABLE "DBCERT"."TJOIN1"
( "RNUM" NUMBER(*,0),
"C1" NUMBER(*,0),
"C2" NUMBER(*,0)
) ;
GRANT SELECT ON "DBCERT"."TJOIN1" TO PUBLIC;
--------------------------------------------------------
-- DDL for Table TJOIN2
--------------------------------------------------------
CREATE TABLE "DBCERT"."TJOIN2"
( "RNUM" NUMBER(*,0),
"C1" NUMBER(*,0),
"C2" CHAR(2 BYTE)
) ;
GRANT SELECT ON "DBCERT"."TJOIN2" TO PUBLIC;
> Drill pushing invalid SQL to ORACLE when joined table with equi and theta
> join term used
> ----------------------------------------------------------------------------------------
>
> Key: DRILL-5626
> URL: https://issues.apache.org/jira/browse/DRILL-5626
> Project: Apache Drill
> Issue Type: Bug
> Components: Server
> Affects Versions: 1.10.0
> Environment: Drill 1.10
> ORACLE 12C2 via JDBC
> Reporter: N Campbell
>
> Plugin defined to access ORACLE 12C2 via JDBC
> Following query sent to Drill
> select TJOIN1.RNUM, TJOIN1.C1, TJOIN1.C2, TJOIN2.C2 as C2J2 from
> certora.DBCERT.TJOIN1 inner join certora.DBCERT.TJOIN2 on ( TJOIN1.C1 =
> TJOIN2.C1 and TJOIN2.C1 between 15 and 25 )
> Fails with DATA_READ ERROR: The JDBC storage plugin failed while trying setup
> the SQL query.
> SELECT "C1", "C2", "C1" >= 15 "$f3", "C1" <= 25 "$f4"
> FROM "DBCERT"."TJOIN2"
> ORACLE DDL
> CREATE TABLE "DBCERT"."TJOIN1"
> ( "RNUM" NUMBER(*,0),
> "C1" NUMBER(*,0),
> "C2" NUMBER(*,0)
> ) ;
> GRANT SELECT ON "DBCERT"."TJOIN1" TO PUBLIC;
> --------------------------------------------------------
> -- DDL for Table TJOIN2
> --------------------------------------------------------
> CREATE TABLE "DBCERT"."TJOIN2"
> ( "RNUM" NUMBER(*,0),
> "C1" NUMBER(*,0),
> "C2" CHAR(2 BYTE)
> ) ;
> GRANT SELECT ON "DBCERT"."TJOIN2" TO PUBLIC;
> Other examples
> select TJOIN1.RNUM, TJOIN1.C1, TJOIN1.C2, TJOIN2.C2 as C2J2 from
> certora.DBCERT.TJOIN1 inner join certora.DBCERT.TJOIN2 on ( TJOIN1.C1 =
> TJOIN2.C1 and TJOIN2.C2 like 'A%' )
> DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL
> query.
> sql SELECT "C1", "C2", "C2" LIKE 'A%' "$f3"
> FROM "DBCERT"."TJOIN2"
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
