base_table is not a exernal table.How we are loading the data into base_table is not clear during first run is not clear?could you please provide input on this?we are not using any load statement or insert into statement? I think after using below statement.Manually we have to load the data from files present in path:- /user/hive/incremental_table/incremental_table into table base_table sqoop import --connect jdbc:teradata://{host name or ip address}/Database=retail --connection-manager org.apache.sqoop.teradata.TeradataConnManager --username dbc --password dbc --table SOURCE_TBL --target-dir /user/hive/incremental_table -m 1 ... View more

a)what is the source for the tables:-test_csv_serde_using_CSV_Serde_reader,test_csv_serde; which one i need to consider? b)Is it same for both the tables? Option 1 : col1 col2 col3 ---------------------- 121 Hello World 4567 232 Text 5678 343 More Text 6789 Option 2 : 121|Hello World|4567| 232|Text|5678| 343|More Text|6789| Option 3 : 121 'Hello World' 4567 232 Text 5678 343 'More Text' 6789 ... View more

where to get this jar file com.ibm.spss.hive.serde2.xml.XmlSerDe? ... View more