[
https://issues.apache.org/jira/browse/SPARK-20141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Owen resolved SPARK-20141.
-------------------------------
Resolution: Not A Problem
> jdbc query gives ORA-00903
> --------------------------
>
> Key: SPARK-20141
> URL: https://issues.apache.org/jira/browse/SPARK-20141
> Project: Spark
> Issue Type: Bug
> Components: Input/Output
> Affects Versions: 2.0.2
> Environment: Windows7
> Reporter: sergio
> Labels: windows
> Attachments: exception.png
>
>
> Error while querying to external oracle database.
> It works this way and then I can work with jdbcDF:
> val jdbcDF = sqlContext.read.format("jdbc").options(
> Map("url" -> "jdbc:oracle:thin:@//crmdbmr.cgs.comp.ru:1521/crmrmir",
> "user" -> "my_login",
> "password" -> "my_password",
> "dbtable" -> "siebel.table1")).load()
> while when trying to send some query, it fails
> val jdbcDF = sqlContext.read.format("jdbc").options(
> Map("url" -> "jdbc:oracle:thin:@//crmdbmr.cgs.comp.ru:1521/crmrmir",
> "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":
> http://spark.apache.org/docs/latest/sql-programming-guide.html
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
