Re: [External Sender] Writing dataframe to vertica

2018-10-22 Thread Nikhil Goyal
Got the issue fixed. Had to set 'dbschema' param in connection options. By default it is set to public Thanks On Tue, Oct 16, 2018 at 9:49 PM Femi Anthony wrote: > How are you trying to write to Vertica ? Can you provide some snippets of > code ? > > > Femi > > On Tue, Oct 16, 2018 at 7:24 PM

Re: [External Sender] Writing dataframe to vertica

2018-10-16 Thread Femi Anthony
How are you trying to write to Vertica ? Can you provide some snippets of code ? Femi On Tue, Oct 16, 2018 at 7:24 PM Nikhil Goyal wrote: > Hi guys, > > I am trying to write dataframe to vertica using spark. It seems like spark > is creating a temp table under public schema. I don't have

Writing dataframe to vertica

2018-10-16 Thread Nikhil Goyal
Hi guys, I am trying to write dataframe to vertica using spark. It seems like spark is creating a temp table under public schema. I don't have access to public schema hence the job is failing. Is there a way to specify another schema? Error ERROR s2v.S2VUtils: createJobStatusTable: FAILED to

Issue with writing Dataframe to Vertica through JDBC

2015-09-16 Thread Divya Ravichandran
> I get the following stack trace with this issue, anybody has any clue? I am running spark on yarn in cluster mode. > > > > > > 15/09/16 16:30:28 INFO spark.SparkContext: Starting job: jdbc at AssetMetadataToVertica.java:114 > > 15/09/16 16:30:28 INFO scheduler.DAGScheduler: Got job 0 (jdbc at