Spark 2.0.2 - JdbcRelationProvider does not allow create table as select

[Kanagha Kumar]

Hi,

I'm running spark 2.0.2 version and I'm noticing an issue with
DataFrameWriter.save()

Code:

ds.write().format("jdbc").mode("overwrite").options(ImmutableMap.of(

                "driver", "org.apache.phoenix.jdbc.PhoenixDriver",

                "url", urlWithTenant,

                "dbtable", "tableName")).save();


I found this was reported in prior spark versions but seems to have been
fixed with 2.0.x versions. Please let me know if this issue still exists
with 2.0.2 version.

17/07/06 15:53:12 ERROR ApplicationMaster: User class threw exception:
java.lang.RuntimeException:
org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider does
not allow create table as select.
java.lang.RuntimeException:
org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider does
not allow create table as select.
        at scala.sys.package$.error(package.scala:27)
        at
org.apache.spark.sql.execution.datasources.DataSource.write(DataSource.scala:530)
        at
org.apache.spark.sql.DataFrameWriter.save(DataFrameWriter.scala:211)
        at TenantPhoenix.main(TenantPhoenix.java:64)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at
org.apache.spark.deploy.yarn.ApplicationMaster$$anon$2.run(ApplicationMaster.scala:627)
17/07/06 15:53:12 INFO ApplicationMaster: Final app status: FAILED,
exitCode: 15, (reason: User class threw exception:
java.lang.RuntimeException:
org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider does
not allow create table as select.)
17/07/06 15:53:12 INFO SparkContext: Invoking stop() from shutdown hook
17/07/06 15:53:12 INFO SparkUI: Stopped Spark web UI at
http://10.3.9.95:50461
17/07/06 15:53:12 INFO YarnAllocator: Driver requested a total number of 0
executor(s).
17/07/06 15:53:12 INFO YarnClusterSchedulerBackend: Shutting down all
executors
17/07/06 15:53:12 INFO YarnSchedulerBackend$YarnDriverEndpoint: Asking each
executor to shut down
17/07/06 15:53:12 INFO SchedulerExtensionServices: Stopping
SchedulerExtensionServices

Thanks