Timezone error while creating a Table in Hadoop Foreign Server via QueryGrid
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 org.joda.time.DateTimeZone.forTimeZone(DateTimeZone.java:329) com.teradata.fnc.value.DateValue.<init>(DateValue.java:90) com.te...). Elapsed time = 00:00:02.810
STATEMENT 1: Unknown failed.
the following is the statement I'm running for the scope
CREATE SET TABLE TC_RWD_VDM_CPRD.QueryGridTest ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( patid INTEGER, eventdate DATE FORMAT 'YY/MM/DD', sysdate_ DATE FORMAT 'YY/MM/DD', constype INTEGER, consid INTEGER, medcode INTEGER, staffid INTEGER, episode INTEGER, enttype INTEGER, adid INTEGER, load_id INTEGER, SOURCE_FILE_ID INTEGER, ROW_NUMBER_ DECIMAL(18,0), 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...