PI92282: DATA RETURNED BY A BIG SQL SELECT OF A COLUMN WITH A DATA VALUE LONGER THAN 65535 BYTES IS TRUNCATED

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels