1

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") ) 
0

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.