spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sergio (JIRA)" <>
Subject [jira] [Created] (SPARK-20141) jdbc query gives ORA-00903
Date Wed, 29 Mar 2017 13:06:41 GMT
sergio created SPARK-20141:

             Summary: jdbc query gives ORA-00903
                 Key: SPARK-20141
             Project: Spark
          Issue Type: Bug
          Components: Input/Output
    Affects Versions: 2.0.2
         Environment: Windows7
            Reporter: sergio

Error while querying to external oracle database. 
It works this way and then I can work with jdbcDF:

val jdbcDF ="jdbc").options(
  Map("url" -> "jdbc:oracle:thin:@//",
  "user" -> "my_login",
  "password" -> "my_password",
  "dbtable" -> "siebel.table1")).load() 

while when trying to send some query, it fails 

val jdbcDF ="jdbc").options(
  Map("url" -> "jdbc:oracle:thin:@//",
  "user" -> "my_login",
  "password" -> "my_password",
  "dbtable" -> "select * from siebel.table1 where call_id= '1-1TMC4D4U'")).load() 

This query works fine in SQLDeveloper, or when i registerTempTable, but when I put direct
query instead of schema.table, it gives this error:
java.sql.SQLSyntaxErrorException: ORA-00903:

It looks like spark sends wrong query.
I tried everything in "JDBC To Other Databases":

This message was sent by Atlassian JIRA

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message