abhinav wagle
06/24/2022, 9:18 PM{"code":400,"error":"Invalid table config for table transcript_OFFLINE: Failed to find instances with tag: DefaultTenant_OFFLINE for table: transcript_OFFLINE"}`
abhinav wagle
06/24/2022, 9:18 PMbin/pinot-admin.sh AddTable \
-tableConfigFile /tmp/pinot-quick-start/transcript-table-offline.json \
-schemaFile /tmp/pinot-quick-start/transcript-schema.json -exe
abhinav wagle
06/24/2022, 9:18 PMcat /tmp/pinot-quick-start/transcript-table-offline.json
{
"tableName": "transcript",
"segmentsConfig" : {
"timeColumnName": "timestampInEpoch",
"timeType": "MILLISECONDS",
"replication" : "1",
"schemaName" : "transcript"
},
"tableIndexConfig" : {
"invertedIndexColumns" : [],
"loadMode" : "MMAP"
},
"tenants" : {
"broker":"DefaultTenant",
"server":"DefaultTenant"
},
"tableType":"OFFLINE",
"metadata": {}
}
abhinav wagle
06/24/2022, 9:19 PMcat /tmp/pinot-quick-start/transcript-schema.json
{
"schemaName": "transcript",
"dimensionFieldSpecs": [
{
"name": "studentID",
"dataType": "INT"
},
{
"name": "firstName",
"dataType": "STRING"
},
{
"name": "lastName",
"dataType": "STRING"
},
{
"name": "gender",
"dataType": "STRING"
},
{
"name": "subject",
"dataType": "STRING"
}
],
"metricFieldSpecs": [
{
"name": "score",
"dataType": "FLOAT"
}
],
"dateTimeFieldSpecs": [{
"name": "timestampInEpoch",
"dataType": "LONG",
"format" : "1:MILLISECONDS:EPOCH",
"granularity": "1:MILLISECONDS"
}]
}
Xiaobing
06/24/2022, 9:59 PMabhinav wagle
06/25/2022, 1:38 AM