Timezone error while creating a Table in Hadoop Foreign Server via QueryGrid

UDA
Teradata Employee

Timezone error while creating a Table in Hadoop Foreign Server via QueryGrid

Hi all

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

 

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,
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...

Any suggestions?