[HIVE-21641] Llap external client returns decimal columns in different precision/scale as compared to beeline

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.1
• Fix Version/s: 4.0.0-alpha-1
• Component/s: llap
• Labels: Branch3Candidate pull-request-available
• Assignee: Shubham Chaurasia
• Reporter: Shubham Chaurasia
• Created: 22/Apr/19 12:20
• Updated: 27/Feb/24 22:23
• Resolved: 22/Nov/19 09:25

Description

Llap external client gives different precision/scale as compared to when the query is executed beeline. Consider the following results:

Query:

 
select avg(ss_ext_sales_price) my_avg from store_sales;

 

Result from Beeline

 
+----------------------------+
|           my_avg           |
+----------------------------+
| 37.8923531030581611189434  |
+----------------------------+

 

Result from Llap external client

+---------+
|   my_avg|
+---------+
|37.892353|
+---------+

 
This is due to Driver(beeline path) calls analyzeInternal() for getting result set schema which initializes resultSchema after some more transformations as compared to llap-ext-client which calls genLogicalPlan()

Replacing genLogicalPlan() by analyze() resolves this.

Issue Links

• links to: GitHub Pull Request #601