APAR status
Closed as fixed if next.
Error description
When a Hive table with a string field with length greater than 65535 characters is selected through Big SQL, the returned result is unexpectedly truncated. By default, Big SQL will truncate a string value to 32672 characters; however, the returned result is incorrectly truncated to different lengths. . Sample repro scenario: In Hive, create a table with a string column: create table test(c1 string); Insert or load data into table test where the string column has a length of, for example, 131130 characters. hive> select length(c1) from test; OK 131130 Time taken: 0.785 seconds, Fetched: 1 row(s) . Selecting the same data through Big SQL shows: [bigsql@test ~]$ db2 "select length(c1) from test" 1 ----------- 58 1 record(s) selected. .
Local fix
Problem summary
Please see the problem description.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI92282
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
420
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-01-10
Closed date
2020-09-09
Last modified date
2020-09-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"420"}]
Document Information
Modified date:
10 September 2020