[GitHub] [pinot] jatin5251 commented on issue #9575: Add Support for DATE datatype in Pinot

[GitBox <gi...@apache.org>]

jatin5251 commented on issue #9575:
URL: https://github.com/apache/pinot/issues/9575#issuecomment-1275844555

   We are using tableau for visualization and due to its licensing cost we are in process to deprecate it with superset
   But tableau has extract feature in which we save output of sql query in tableau server as in-memory.
   To add this functionality in superset we build one service that will take sql query from superset, run it on trino then trino-pinot connector will insert data into pinot(insert support added by @elonazoulay in trino )
   
   In our service we first take the query from user, get its schema from trino and convert the schema in a way that will be compatible to pinot like bigint to long
   
   As hive tables  has support for date datatype but not in pinot then we need to ask users to cast date type to varchar in query.
   
   As we have all primitive data type support in pinot except Date. We want to add this support in pinot so that users will have good experience.
   please let me know if you need more information
   Thanks


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org