I need your help and suggestions like what kind of performance tests can be run on JDBC Driver , So we can make sure it is ready for Production
I am facing the same issue in Customer interaction manager Batch , Both the data source and target from the Teradata.
Added this error code into the Retry machinisam which CIM offers, The job completed without any issue.
[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is empty
To further speed up the data movement between Teradata and Hive, we can fully explore the combination of TPT (fast export & import) and binary file format.
TPT Export is super fast. With a host that is equipped with 10Gbp NIC and 1TB SSD, we can export fetch data up to 400MB/sec for big tables. Then the data file in Fast Export format can be directly read in Hive via https://cwiki.apache.org/confluence/display/Hive/TeradataBinarySerde
For bulk data export and import, this can be an efficient alternative to JDBC(TDCH)/ODBC as well.