[jira] [Updated] (SPARK-7601) Support Insert into JDBC Datasource
[
https://issues.apache.org/jira/browse/SPARK-7601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Owen updated SPARK-7601:
-
Assignee: Venkata Ramana G
Support Insert into JDBC Datasource
---
Key: SPARK-7601
URL: https://issues.apache.org/jira/browse/SPARK-7601
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.3.1
Reporter: Venkata Ramana G
Assignee: Venkata Ramana G
Fix For: 1.4.0
Support Insert into JDBCDataSource. Following are usage examples
{code}
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-7601) Support Insert into JDBC Datasource
[
https://issues.apache.org/jira/browse/SPARK-7601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venkata Ramana G updated SPARK-7601:
Description:
Support Insert into JDBCDataSource. Following are usage examples
{code}
df.saveAsTable(
testcreate2,
org.apache.spark.sql.jdbc,
org.apache.spark.sql.SaveMode.Overwrite,
Map(url-s$url, dbtable-testcreate2, user-xx, password-xx,
driver-com.h2.Driver)
)
or
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
was:
Support Insert into JDBCDataSource. Following are usage examples
{code}
df.saveAsTable(testcreate2,org.apache.spark.sql.jdbc,
org.apache.spark.sql.SaveMode.Overwrite, Map(url-s$url,
dbtable-testcreate2, user-xx, password-xx,
driver-com.h2.Driver))
or
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
Support Insert into JDBC Datasource
---
Key: SPARK-7601
URL: https://issues.apache.org/jira/browse/SPARK-7601
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.3.1
Reporter: Venkata Ramana G
Support Insert into JDBCDataSource. Following are usage examples
{code}
df.saveAsTable(
testcreate2,
org.apache.spark.sql.jdbc,
org.apache.spark.sql.SaveMode.Overwrite,
Map(url-s$url, dbtable-testcreate2, user-xx,
password-xx, driver-com.h2.Driver)
)
or
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-7601) Support Insert into JDBC Datasource
[
https://issues.apache.org/jira/browse/SPARK-7601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venkata Ramana G updated SPARK-7601:
Description:
Support Insert into JDBCDataSource. Following are usage examples
{code}
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
was:
Support Insert into JDBCDataSource. Following are usage examples
{code}
df.saveAsTable(
testcreate2,
org.apache.spark.sql.jdbc,
org.apache.spark.sql.SaveMode.Overwrite,
Map(url-s$url, dbtable-testcreate2, user-xx, password-xx,
driver-com.h2.Driver)
)
or
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
Support Insert into JDBC Datasource
---
Key: SPARK-7601
URL: https://issues.apache.org/jira/browse/SPARK-7601
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.3.1
Reporter: Venkata Ramana G
Support Insert into JDBCDataSource. Following are usage examples
{code}
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-7601) Support Insert into JDBC Datasource
[
https://issues.apache.org/jira/browse/SPARK-7601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Patrick Wendell updated SPARK-7601:
---
Fix Version/s: 1.4.0
Support Insert into JDBC Datasource
---
Key: SPARK-7601
URL: https://issues.apache.org/jira/browse/SPARK-7601
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.3.1
Reporter: Venkata Ramana G
Fix For: 1.4.0
Support Insert into JDBCDataSource. Following are usage examples
{code}
sqlContext.sql(
s
|CREATE TEMPORARY TABLE testram1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url', dbtable 'testram1', user 'xx', password 'xx',
driver 'com.h2.Driver')
.stripMargin.replaceAll(\n, ))
sqlContext.sql(insert into table testram1 select * from testsrc).show
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
