Hi Folks， I am using prestodb, but fond an issue w...
# generalc
Charles
10/12/2021, 9:13 AMHi Folks， I am using prestodb, but fond an issue when using order by , Could anyone help check?
d
Dan DC
10/12/2021, 11:22 AMCan you add some logs? That may help to find the issue. See if adding --debug to your presto CLI the query prints a stack trace
x
Xiang Fu
10/12/2021, 2:56 PM
Can you explain this query in presto and use right arrow to see the generated Pinot query?
k
Kenny Bastani
10/12/2021, 6:12 PM@User please try removing the semi-colon at the end of the query. I've found this to be an issue with
ORDER-BYc
Charles
10/13/2021, 1:14 AMHi @User
presto:default> explain select * from matsmeeting order by jobprocesstime desc;Charles
10/13/2021, 1:15 AMHi @User here is debug info
presto:default> select * from matsmeeting order by jobprocesstime desc;Charles
10/13/2021, 1:17 AM@User I found if i remove semi-colon, i can’t run commend in cli
Charles
10/13/2021, 1:17 AMmessage has been deleted
k
Kenny Bastani
10/13/2021, 1:30 AMAh okay. There is a bug in 0.9.0 where a semi-colon at the end of a query in the browser does result in an error. But this looks very much related to Presto.
c
Charles
10/13/2021, 1:31 AMHi @User It’s strange that only failed when query contain order-by?
k
Kenny Bastani
10/13/2021, 1:35 AMThe exception doesn’t seem to be happening in the Pinot runtime. This looks like a bug in Presto. I’m not very familiar with Presto’s code so I think someone else might be better able to help you here. I would, however, try running your query in the Pinot query console and see if it returns any results.
c
Charles
10/13/2021, 1:36 AMThx @User Do we have presto coder in this room? 😀
k
Kenny Bastani
10/13/2021, 2:00 AMYes, I think @User might be able to help if he has bandwidth. If not, we will find someone to help.
c
Charles
10/13/2021, 2:19 AMHi @User Could you please help look at this issue, thx 😀
d
Dan DC
10/13/2021, 2:24 PMI've just got this error as well but my query doesn't have a group/order by, is just a simple
select sum(1) from tablex
Xiang Fu
10/13/2021, 6:27 PM
semi colon is required from presto side to end a query
Xiang Fu
10/13/2021, 6:28 PM
for your query explain, can you use right arrow -> to look at more plans from right side?
Xiang Fu
10/13/2021, 6:28 PM
one screen width is not enough to show the full plan
Xiang Fu
10/13/2021, 6:29 PM
there should be something more after
TableScan[TableHandle {connectorId='pinot', connectorHandle='PinotTableHandle{connectorId=pinot, schemaName=default, tableName=matsmeeting, isQueryShort=OptionalXiang Fu
10/13/2021, 6:29 PM
my feeling is that this query is not a short query, so presto is asking all data from pinot then sort by itself
Xiang Fu
10/13/2021, 6:30 PM
so the order by is not pushed down to pinot
Xiang Fu
10/13/2021, 6:30 PM
which should be something that can be added into Presto-Pinot connector
c
Charles
10/18/2021, 6:09 AMYes @User Seems presto issue and jdbc is fine for us
Charles
10/18/2021, 6:15 AMSorry I don’t know how to use -> this,
presto:default> explain select * from matsmeeting order by jobprocesstime desc ->;x
Xiang Fu
10/18/2021, 3:51 PM
Oh, it’s just the right arrow(one of the 4 directions ) on your keyboard to see more content