search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
16.05k stars 5.38k forks source link

sortedCandidates is null or empty for ModularHashingNodeProvider #18002

Open Stevenscj opened 2 years ago

Stevenscj commented 2 years ago

Presto version : 0.273.3 Presto JDBC version : 0.273.3 Presto coordinator : 1 , worker : 2 Data Source : Hive / PostgreSQL

When I open a table and get the data with DBeaver, an error just occured below :

SOL Error [65541]: Query failed (#20220708_005111_00014_xbfqr): sortedCandidates is null or empty for ModularHashingNodeProvider

ShaoyiZhang commented 2 years ago

I saw this error with mysql connector, and it was because I have the proper credentials on the coordinator node but forgot to deploy the connector credentials to the worker nodes.

harsh9898 commented 2 years ago

Presto version : 0.268 Presto JDBC version : 0.268 Presto coordinator : 1 , worker : 1 Data Source : Oracle

When I am trying open a table and get the data with DBeaver, it's giving the following error :

SOL Error [65541]: Query failed (#20220901_125736_00006_unsxw): sortedCandidates is null or empty for ModularHashingNodeProvider

If someone figured out to resolve this then Please help with this one.

@Stevenscj Have you resolved this?

@ShaoyiZhang I deployed the credential to the worker node but still gave the error.