# troubleshooting
- s
Suraj
04/16/2020, 10:07 PMwhat should i try ? - s
Suraj
04/16/2020, 10:08 PMCopy codecurl -X GET --header 'Accept: application/json' '<http://localhost:8099/debug/routingTable/serviceCallView>' - s
Suraj
04/16/2020, 10:08 PMresponse - x
Xiang Fu
04/16/2020, 10:32 PMhmm - x
Xiang Fu
04/16/2020, 10:33 PMso routing table is there - x
Xiang Fu
04/16/2020, 10:33 PMand you still cannot query? - s
Suraj
04/16/2020, 10:37 PMyea can't query - d
Dan Hill
04/27/2020, 4:58 PMMoving from #CDRCA57FC , it looks like Presto is adding a
automatically to a Pinot query and it's failing.TOP 10000 - k
Kishore G
04/27/2020, 4:59 PMTOP 10000 should still work - k
Kishore G
04/27/2020, 4:59 PMdo you see anything in pinot broker logs? - d
Dan Hill
04/27/2020, 5:07 PMSame error that appears when I run in the query data explorer. - d
Dan Hill
04/27/2020, 5:07 PMCopy codeCaused by: org.apache.calcite.sql.parser.babel.ParseException: Encountered "TOP" at line 1, column 114. Was expecting one of: <EOF> "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH" ... "," ... "." ... "NOT" ... "IN" ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "<>" ... "!=" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "+" ... "-" ... "*" ... "/" ... "%" ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ... "SUBMULTISET" ... "CONTAINS" ... "OVERLAPS" ... "EQUALS" ... "PRECEDES" ... "SUCCEEDS" ... "IMMEDIATELY" ... "MULTISET" ... "[" ... "HAVING" ... "WINDOW" ... "UNION" ... "INTERSECT" ... "EXCEPT" ... "MINUS" ... "(" ... - n
Neha Pawar
04/27/2020, 5:09 PM@Kishore G i dont think TOP works in the sql endpoing - k
Kishore G
04/27/2020, 5:09 PMyes, try LIMIT instead of TOP in pinot query console - x
Xiang Fu
04/27/2020, 5:50 PMI feel the issue might be that presto sends query as
to pinot, which expected 1 column back from pinot results, but pinot gives twoselect count(*) from table group by a - x
Xiang Fu
04/27/2020, 5:50 PMI will check more - k
Kishore G
04/27/2020, 5:51 PMlets create an issue, maybe its time to move presto-pinot connector from PQL to SQL end point - x
Xiang Fu
04/27/2020, 5:58 PMwe need to fix the bug first - x
Xiang Fu
04/27/2020, 5:59 PMeven for moving to sql end point, it will be an option to let users turn it on - d
Dan Hill
04/27/2020, 6:47 PM
is automatically created by Presto.TOP - d
Dan Hill
04/27/2020, 6:49 PMThe same query works if I use
instead.LIMIT - x
Xiang Fu
04/27/2020, 8:16 PMcan you try to run
in prestoselect count(*) from table group by col - d
Dan Hill
04/27/2020, 10:48 PMThat fails. - d
Dan Hill
04/27/2020, 10:48 PMIf I do
, it worksselect col, count(*) from table group by col - d
Dan Hill
04/27/2020, 10:48 PMIt's the same Exception type and parameter. - d
Dan Hill
04/27/2020, 10:49 PMCopy codejava.lang.ArrayIndexOutOfBoundsException: 1 - x
Xiang Fu
04/27/2020, 11:40 PMcool - x
Xiang Fu
04/27/2020, 11:41 PMI’m looking into this👍 1 - d
Damiano
04/28/2020, 10:53 PMhello everybody - k
Kishore G
04/28/2020, 10:54 PMhey