Hope I can find some valuable suggestion here.
A customer has installed and configured (not without pain) QueryGrid T2H 15.10.
There is a Foreign Server configured and I'm supposed to offload some test data and execute performance test to compare query performance in Hadoop with the standard ones.
While I'm trying to create a table based on the Test data I've got from the customer, I receive the following error
Executed as Single statement. Failed [7827 : 39001] [Teradata Database] [TeraJDBC 15.10.00.09] [Error 7827] [SQLState 39001] Java SQL Exception SQLSTATE 39001: Invalid SQL state (null: The datetime zone id 'Europe/Busingen' is not recognised
Elapsed time = 00:00:02.810
STATEMENT 1: Unknown failed.
the following is the statement I'm running for the scope
CALL SYSLIB.HCTAS('TC_RWD_VDM_CPRD.QueryGridTest','patid, eventdate, sysdate_, constype, consid, medcode, staffid, episode, enttype, adid, load_id, source_file_id, row_number_, textid', 'LOCATION "/user/hive/
QueryGridTest/clinical"', 'cdh123_15_01_krb', 'rwd_vdm_cprd' );
and the follwing the DDL of the original table
CREATE SET TABLE TC_RWD_VDM_CPRD.QueryGridTest ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
eventdate DATE FORMAT 'YY/MM/DD',
sysdate_ DATE FORMAT 'YY/MM/DD',
textid VARCHAR(50) CHARACTER SET UNICODE NOT CASESPECIFIC)
PRIMARY INDEX ( patid );
The error as such makes me thinking about some mising setting in the session, or in the Foreign Server definition, or even in Hadoop itself...