[
https://issues.apache.org/jira/browse/PHOENIX-2046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2046:
----------------------------------
Fix Version/s: 4.8.0
> Metadata for queries returns wrong precision and scale
> ------------------------------------------------------
>
> Key: PHOENIX-2046
> URL: https://issues.apache.org/jira/browse/PHOENIX-2046
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.4.0
> Environment: Phoenix 4.4 and Hbase 1.1
> Reporter: Pasupathy M
> Fix For: 4.8.0
>
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
