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
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
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
> 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