hi guys i am facing data ingestion issue after adding authentication to the pinot.
does it have anything to do with the table config?
i am getting error:
Upload response: 500
Error: {"code":500,"error":"Caught exception when ingesting file into table: test_tenant_OFFLINE. Caught exception while uploading segments. Push mode: TAR, segment tars: [[file:/opt/pinot/tmp/ingestion_dir/working_dir_test_tenant_OFFLINE_1742312090194_FRKYyJJrdp/segment_tar_dir/test_tenant_1742312090217.tar.gz]]"}
table_config = {
"tableName": f"{tenant_name}",
"tableType": "OFFLINE",
"segmentsConfig": {
"minimizeDataMovement": False,
"deletedSegmentsRetentionPeriod": "7d",
"retentionTimeUnit": "DAYS",
"retentionTimeValue": "30",
"segmentPushType": "REFRESH",
"replication": "1"
},
"tenants": {
"broker": "DefaultTenant",
"server": "DefaultTenant"
},
"tableIndexConfig": {
"invertedIndexColumns": [
"Time_of_Resolution",
"Category",
"Description",
"Escalate",
"Ticket_Status",
"Customer_Gender",
"Ticket_Subject",
"product_purchased",
"Source",
"Relevance",
"Customer_Email",
"Customer_Name",
"Tags",
"Agent",
"Number_of_conversations",
"Intent",
"Ticket_Priority",
"Sentiment",
"Type",
"Created_date",
"First_Response_Time",
"Customer_Satisfaction_Rating",
"Date_of_Purchase",
"Resolution",
"Created_date_month",
"Created_date_year"
],
"autoGeneratedInvertedIndex": False,
"varLengthDictionaryColumns": [
"Time_of_Resolution",
"Category",
"Description",
"Escalate",
"Ticket_Status",
"Customer_Gender",
"Ticket_Subject",
"product_purchased",
"Source",
"Relevance",
"Customer_Email",
"Customer_Name",
"Tags",
"Agent",
"Intent",
"Ticket_Priority",
"Sentiment",
"Type",
"Created_date",
"First_Response_Time",
"Date_of_Purchase",
"Resolution"
],
"enableDefaultStarTree": False,
"nullHandlingEnabled": True,
"createInvertedIndexDuringSegmentGeneration": True,
"rangeIndexVersion": 2,
"aggregateMetrics": False,
"optimizeDictionary": False,
"loadMode": "MMAP",
"enableDynamicStarTreeCreation": False,
"columnMajorSegmentBuilderEnabled": False,
"optimizeDictionaryForMetrics": False,
"noDictionarySizeRatioThreshold": 0
},
"metadata": {},
"ingestionConfig": {
"batchIngestionConfig": {
"segmentIngestionType": "APPEND",
"consistentDataPush": False
},
"segmentTimeValueCheck": False,
"transformConfigs": [
{
"columnName": "First_Response_Time_epoch_millis",
"transformFunction": "CASEWHEN(strcmp(Number_of_conversations,'null')=0,null,DATETIMECONVERT(First_Response_Time, 'SIMPLE_DATE_FORMAT|dd-MM-yyyy HH:mm', '1MILLISECONDSEPOCH', 'MINUTES|1'))"
},
{
"columnName": "Time_of_Resolution_epoch_millis",
"transformFunction": "CASEWHEN(strcmp(Ticket_Status,'Closed')=0,DATETIMECONVERT(Time_of_Resolution, 'SIMPLE_DATE_FORMAT|dd-MM-yyyy HH:mm', '1MILLISECONDSEPOCH', 'MINUTES|1'),null)"
},
{
"columnName": "Created_date_timestamp",
"transformFunction": "DATETIMECONVERT(Created_date, 'SIMPLE_DATE_FORMAT|dd-MM-yyyy HH:mm', 'SIMPLE_DATE_FORMAT|yyyy-MM-dd HH:mm', 'MINUTES|1')"
},
{
"columnName": "Created_date_epoch_millis",
"transformFunction": "DATETIMECONVERT(Created_date, 'SIMPLE_DATE_FORMAT|dd-MM-yyyy HH:mm', '1MILLISECONDSEPOCH', 'MINUTES|1')"
},
{
"columnName": "Created_date_month",
"transformFunction": "Month(Created_date_epoch_millis, 'UTC')"
},
{
"columnName": "Created_date_year",
"transformFunction": "YEAR(Created_date_epoch_millis)"
},
{
"columnName": "Sentiment_score",
"transformFunction": "CASEWHEN(strcmp(Sentiment,'Positive')=0,2,CASEWHEN(strcmp(Sentiment,'Neutral')=0,1,0))"
},
{
"columnName": "Sentiment_Positive",
"transformFunction": "CASEWHEN(strcmp(Sentiment,'Positive')=0,2,0)"
},
{
"columnName": "Sentiment_Neutral",
"transformFunction": "CASEWHEN(strcmp(Sentiment,'Neutral')=0,1,0)"
},
{
"columnName": "Sentiment_Negative",
"transformFunction": "CASEWHEN(strcmp(Sentiment,'Negative')=0,0,0)"
},
{
"columnName": "Customer_Satisfaction_Rating",
"transformFunction": "\"Customer Satisfaction Rating\""
},
{
"columnName": "Number_of_conversations",
"transformFunction": "\"Number of conversations\""
},
{
"columnName": "Ticket_Subject",
"transformFunction": "\"Ticket Subject\""
},
{
"columnName": "Customer_Name",
"transformFunction": "\"Customer Name\""
},
{
"columnName": "Time_of_Resolution",
"transformFunction": "\"Time to Resolution\""
},
{
"columnName": "Customer_Age",
"transformFunction": "\"Customer Age\""
},
{
"columnName": "First_Response_Time",
"transformFunction": "\"First Response Time\""
},
{
"columnName": "Customer_Email",
"transformFunction": "\"Customer Email\""
},
{
"columnName": "Ticket_Status",
"transformFunction": "\"Ticket Status\""
},
{
"columnName": "Created_date",
"transformFunction": "\"Created date\""
},
{
"columnName": "Date_of_Purchase",
"transformFunction": "\"Date of Purchase\""
},
{
"columnName": "Agent_overall_performance",
"transformFunction": "\"Agent overall performance\""
},
{
"columnName": "Agent_politeness",
"transformFunction": "\"Agent politeness\""
},
{
"columnName": "Customer_Gender",
"transformFunction": "\"Customer Gender\""
},
{
"columnName": "Agent_communication",
"transformFunction": "\"Agent communication\""
},
{
"columnName": "Agent_Patience",
"transformFunction": "\"Agent Patience\""
},
{
"columnName": "Ticket_ID",
"transformFunction": "\"Ticket ID\""
},
{
"columnName": "Ticket_Priority",
"transformFunction": "\"Ticket Priority\""
}
],
"continueOnError": True,
"rowTimeValueCheck": True
},
"isDimTable": False
}