prestodb/presto

Support for Apache Pinot BIG_DECIMAL data type

Open

#21,459 opened on 2023年11月30日

GitHub で見る
 (4 comments) (0 reactions) (0 assignees)Java (5,240 forks)batch import
feature requestgood first issue

Repository metrics

Stars
 (15,558 stars)
PR merge metrics
 (平均マージ 34d 14h) (30d で 120 merged PRs)

説明

Presto does not support Pinot data type BIG_DECIMAL. When a column is found with this data type, Presto fails with this message:

com.facebook.presto.pinot.PinotException: Cannot fetch from cache <table name>
  com.fasterxml.jackson.databind.JsonMappingException: Unsupported dimension/time data type: BIG_DECIMAL

Expected Behavior or Use Case

I would expect this fields to be mapped as Java BigDecimal

Presto Component, Service, or Connector

This behavior affects to the Pinot Connector

Possible Implementation

I guess, it can be mapped as a Java BigDecimal

Example Screenshots (if appropriate):

Context

BigDecimal data types are needed for monetary amounts where you want a decimal representation of the decimal places not a binary representation that may be different. Those monetary amounts also need decimal operations in base 10.

コントリビューターガイド