Hi Another related question to this. Has anyone tried transactions using
Oracle JDBC and spark. How do you do it given that code will be distributed
on workers. Do I combine certain queries to make sure they don't get
distributed?
Regards,
Leena
On Fri, Jul 21, 2017 at 1:50 PM, Cassa L wrote:
>
Hi Xiao,
I am trying JSON sample table provided by Oracle 12C. It is on the website -
https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6371
CREATE TABLE j_purchaseorder
(id RAW (16) NOT NULL,
date_loaded TIMESTAMP WITH TIME ZONE,
po_document CLOB
CONSTRAINT ensure_j
Could you share the schema of your Oracle table and open a JIRA?
Thanks!
Xiao
2017-07-21 9:40 GMT-07:00 Cassa L :
> I am using 2.2.0. I resolved the problem by removing SELECT * and adding
> column names to the SELECT statement. That works. I'm wondering why SELECT
> * will not work.
>
> Regar
I am using 2.2.0. I resolved the problem by removing SELECT * and adding
column names to the SELECT statement. That works. I'm wondering why SELECT
* will not work.
Regards,
Leena
On Fri, Jul 21, 2017 at 8:21 AM, Xiao Li wrote:
> Could you try 2.2? We fixed multiple Oracle related issues in the
Could you try 2.2? We fixed multiple Oracle related issues in the latest
release.
Thanks
Xiao
On Wed, 19 Jul 2017 at 11:10 PM Cassa L wrote:
> Hi,
> I am trying to use Spark to read from Oracle (12.1) table using Spark 2.0.
> My table has JSON data. I am getting below exception in my code. A
I remember facing similar issues while table had few particular data type,
Numerical fields if I remember correctlyif possible, please validate
data types in your select statement, and preferably do not use * or use
some type conversion
On Thu, Jul 20, 2017 at 4:10 PM, Cassa L wrote:
> H
