[PHOENIX-2046] Metadata for queries returns wrong precision and scale

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.4.0
• Fix Version/s: 4.2.3, 4.9.0

Environment

Phoenix 4.4 and Hbase 1.1

• Assignee: Unassigned
• Reporter: Pasupathy M
• Created: 17/Jun/15 11:00
• Updated: 12/Sep/16 15:41
• Resolved: 12/Sep/16 15:41

Description

We have a query (typical query to a sample foodmart in mondrian)
select "time_by_day"."the_year" as "c0", "product_class"."product_family" as "c1", sum("sales_fact_1997"."store_cost") as "m0" from "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day", "product" as "product", "product_class" as "product_class" where "time_by_day"."the_year" = 1997 and "product_class"."product_family" in ('Drink', 'Food', 'Non-Consumable') and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" group by "time_by_day"."the_year", "product_class"."product_family"

While getting the metadata for this query in phoenix, sum("sales_fact_1997"."store_cost") returns it as decimal with 0 precision and 0 scale. The orignal store_cost column is decimal(10,4)

Issue Links

• is a clone of: CALCITE-1113 Parameter precision and scale are not returned from Avatica REST API