I am trying to export saprkSQL query output to Teradata. I am able to connect teradata from spark using JDBC driver and run some queries on already existing tables in Teradata, but I am unable to figure out how can I insert data that I received from my spark sql(Hive query output) to a teradata Table
This what I used to connect
val jdbcDF = sqlContext.load("jdbc", Map( "url" -> "jdbc:teradata://******/database=****, TMODE=TERA, user=****, password=*****", "dbtable" -> "(select count(*) as t from table) as ST", "driver" -> "com.teradata.jdbc.TeraDriver") )