@Anchika Agarwal
Assuming that reading and writing data from Teradata is like MySQL or Postgresql.... You will need to include the JDBC driver for Teradata on the spark classpath.
$ SPARK_CLASSPATH=teradata-jdbc.jar bin/spark-shell
Use the following code in Spark shell. Modify and pass all necessary parameters
scala> val jdbcUsername = "USER_NAME"
scala> val jdbcPassword = "PASSWORD"
scala> val jdbcHostname = "HOSTNAME"
scala> val jdbcPort = port_num
scala> val jdbcDatabase ="DATABASE"
scala> val jdbcUrl = s"jdbc:teradata://${jdbcHostname}:${jdbcPort}/${jdbcDatabase}?user=${jdbcUsername}&password=${jdbcPassword}"
scala> val connectionProperties = new java.util.Properties()
scala> Class.forName("com.teradata.jdbc.Driver")
scala> import java.sql.DriverManager
scala> val connection = DriverManager.getConnection(jdbcUrl, jdbcUsername, jdbcPassword) connection.isClosed()
scala> sqlContext.table("jdbcDF").withColumnRenamed("table", "table_number") .write .jdbc(jdbcUrl, "tablename", connectionProperties)
