Matt
11/21/2020, 10:34 PMselect length(mydata) from mytable where length(mydata) > 500 LIMIT 10
. Other queries are working fine. Wondering whether this a query issue or cluster setup / index issue?
ERROR SplitRunner-0-38 com.facebook.presto.execution.executor.TaskExecutor Error processing Split 20201121_222456_00039_rmrgi.1.0.0-4 PinotSplit{connectorId=pinot, splitType=SEGMENT, columnHandle=[PinotColumnHandle{columnName=mydata, dataType=varchar, type=REGULAR}], segmentPinotQuery=Optional[SELECT mydata FROM mytable_REALTIME LIMIT 2147483647], brokerPinotQuery=Optional.empty, segments=[mytable__0__7__20201121T2220Z], segmentHost=Optional[Server_test-pinot-server-1.test-pinot-server-headless_8098]} (start = 2824864.565796, wall = 3 ms, cpu = 0 ms, wait = 0 ms, calls = 1): PINOT_UNCLASSIFIED_ERROR: Error when hitting host Server_test-pinot-server-1.sb-pinot-server-headless_8098 with pinot query "SELECT mydata FROM mytable_REALTIME LIMIT 2147483647"
Kishore G
Matt
11/21/2020, 10:43 PMKishore G
Matt
11/21/2020, 10:46 PMKishore G
SELECT mydata FROM mytable_REALTIME LIMIT 2147483647
Matt
11/21/2020, 10:50 PMKishore G
Matt
11/21/2020, 10:56 PMselect length(mydata) from mytable limit 500
Kishore G
Matt
11/21/2020, 11:14 PMKishore G
Xiang Fu
Matt
11/22/2020, 12:45 AMXiang Fu
Matt
11/22/2020, 12:47 AMXiang Fu
Matt
11/22/2020, 12:49 AMXiang Fu
Matt
11/22/2020, 12:51 AMXiang Fu
Matt
11/22/2020, 12:54 AMXiang Fu
Matt
11/22/2020, 1:01 AM