Is it a right choice to replace Apache hive with P...
# getting-startedr
rajkumar
11/23/2022, 2:13 AMIs it a right choice to replace Apache hive with Pinot?.
m
Mayank
11/23/2022, 4:57 AM
Could you elaborate on the use case a bit?
r
rajkumar
11/23/2022, 5:12 AMWe have a Datalake(Cloudera) built on HDFS and Hive (ORC format). Users perform Hive SQL queries for performing data quality KPI with lot of data blending queries across schemas (Ex: Sales, Billing, Finance.. ) , data cleansing and also build dashboards on Tableau. Some of the tables contains 800+ columns with many null values fields and can contain few million records
m
Mayank
11/23/2022, 5:43 AM
You can certainly use Pinot for building dashboards, and more broader analytical use cases. However, it is not the right tool for data blending/cleansing jobs.