2.07 - Resolved Issues - Teradata QueryGrid

Teradata® QueryGrid™ Release Definition

Product
Teradata QueryGrid
Release Number
2.07
Release Date
February 2019
Content Type
Release Notes
Publication ID
B035-5992-118C
Language
English (United States)

Resolved issues are corrections to Teradata QueryGrid, including related documentation.

Teradata QueryGrid 02.07.00.02 consists of the following resolved issues:
Key Summary
QUERYGRID-9776 T2P: Initial import EXPLAIN query fails after Presto is restarted
QUERYGRID-9827 Existing nodes or Viewpoint not able to connect to new member of QGM cluster added with join token method
QUERYGRID-9872 T2X: RTO query with delayed fetch causes Segmentation Violation
QUERYGRID-9879 JDBC jars are loaded for each user which can result in memory leak
QUERYGRID-9910 T2H: SQL with COALESCE (col1, '') on VARCHAR data type fails
QUERYGRID-9968 P2T: Import result mismatch with date before 1900 and less than operator
QUERYGRID-9990 QGM: tdqgm stop command fails to shut down QGM
Teradata QueryGrid 02.07.00.01 consists of the following resolved issues:
Key Summary
QUERYGRID-9678 Presto: Password printed in cleartext in log
QUERYGRID-9679 T2O: insert query sometimes inserts 0 rows
QUERYGRID-9712 QGM fails to honor join token if it contains a "+" sign in a token while peer QGM attempts to join in QGM cluster
QUERYGRID-9742 Support bundle logs.txt has an array with empty string as items
Teradata QueryGrid 02.07 consists of the following resolved issues:
Key Summary
QUERYGRID-7762 Successful queries reported as Unknown in Viewpoint
QUERYGRID-7982 X2S: RTO DelayedFetch does not work with Spark 2.2
QUERYGRID-8867 Fabric: QGCExportTask crash on target node when running import queries
QUERYGRID-8878 T2P/T2H/T2S/T2O: Integer data is missing after export with 512MB CLOB data
QUERYGRID-8907 Fabric: QueryMetric incorrectly shows a finished query metric with 0 bytes data transferred
QUERYGRID-8971 Bridge: bandwidth test in bridge link leaves sockets in CLOSE_WAIT on sending nodes
QUERYGRID-8980 T2H: UDT Array type: Export clause query fails when local table includes array data type
QUERYGRID-9086 T2S: export clause with geometry, json, and xml types reported as not support by remote connector
QUERYGRID-9099 Teradata: memory depletion on Teradata actmain process running high volume of queries
QUERYGRID-9155 Fabric: Single bridge with compression on initiator and no compression on target cause "9124 Segmentation Violation in AMP"
QUERYGRID-9168 QGM: fails to replace existing logback.xml file with new changes upon package install
QUERYGRID-9180 SDK is missing driver jars
QUERYGRID-9198 QGM: Issues and Connector properties are not translated into Chinese
QUERYGRID-9221 H2T: import query fails if date/timestamp keyword is used in where clause
QUERYGRID-9285 Oracle: Response Timeout property is not honored
QUERYGRID-9324 QGM: Connector Diagnostic Check: No original value found for redacted field "authPassword"
QUERYGRID-9348 Fabric: Connection Open Timeout property is not honored correctly when transfer concurrency is greater than 1
QUERYGRID-9349 Fabric: QGLExportTask thread consumes high cpu while waiting for final commit
QUERYGRID-9360 T2O: ORA-31603 error while exporting Array of VARCHAR
QUERYGRID-9394 T2P: insert empty array value inserts array with empty string
QUERYGRID-9441 T2{P,H,S}: insert array with empty string throws exception
QUERYGRID-9445 Fabric: WatchDog double pushes driver log files when activating pending/previous version of fabric
QUERYGRID-9448 Fabric and Driver processes forked by WatchDog hold stale log file handles
QUERYGRID-9450 X2H: Temporary Database Name property is not honored
QUERYGRID-9455 Hive/Spark: Temporary tables not dropped if query fails during metadata phase - ExplainSelectWithUniqueInsert
QUERYGRID-9477 Fabric: Segmentation Fault when query failed after an internal exception
QUERYGRID-9498 Bridge: bandwidth test over bridge link fails: socket write failed with state 0 when trying to send 16 bytes
QUERYGRID-9504 S2T: Write timeout on target is not honored
QUERYGRID-9580 Support archive tool reports "files failed to read"
QUERYGRID-9584 T2O: SELECT from VARRAY of NVARCHAR2 data type returns no rows
QUERYGRID-9610 T2O: SELECT from VARRAY of NULLs throws NullPointerException
QUERYGRID-9629 Hive target connector may give incorrect application IDs in concurrent environment
QUERYGRID-9645 T2P: HELP queries fail when default string size is an odd number
QUERYGRID-9646 T2O: operation did not roll back when an export query fails or is aborted