Learn about the change in certain functionality of Hive that has resulted in a change in
behavior from the previously released version to this version of Cloudera Runtime.
- Summary:
- Change in behavior of precision and scale in arithmetic
operations.
- Previous behavior:
- In CDP Private Cloud Base 7.1.6 and lower versions, the default
maximum precision and scale for arithmetic operations was calculated differently.
- For example, the following expression returns a result of
15237461344547437170.339101086652 with decimal(34,
12):select cast( '12346789101112123.12345678' as decimal(25,8)) * cast('1234.1234' as decimal(25,8))
- New behavior:
- In CDP Private Cloud Base 7.1.7 and higher versions, the default
maximum precision and scale for arithmetic operations follow the specifications defined in
Microsoft SQL Server documentation.
- As a result, the above expression returns a result of
15237461344547437170.339101 with decimal(38, 6).
- Summary:
- Improved Handling of External Table Inserts in HDFS
- Previous behavior:
- When creating an EXTERNAL table and executing
INSERT OVERWRITE, an empty file gets created in the HDFS storage
location.
- New behavior:
- Starting with CDP Private Cloud Base 7.1.1, no empty files are created
in the HDFS location when executing INSERT OVERWRITE on an external table
because of a fix included in HIVE-22941.
- This improvement, enhances Hive's performance, benefits other systems, and avoids the
generation of small files in HDFS.
