prestodb/presto

Support for Apache Pinot BIG_DECIMAL data type

Open

#21.459 aperta il 30 nov 2023

Vedi su GitHub
 (4 commenti) (0 reazioni) (0 assegnatari)Java (5240 fork)batch import
feature requestgood first issue

Metriche repository

Star
 (15.558 star)
Metriche merge PR
 (Merge medio 34g 14h) (120 PR mergiate in 30 g)

Descrizione

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.

Guida contributor