treasure-data / prestogres

PostgreSQL protocol gateway for Presto distributed SQL query engine
Other
292 stars 61 forks source link

Returns random number or rows with every exeuction #59

Open Hiteshbardoli opened 4 years ago

Hiteshbardoli commented 4 years ago

I am using ODBC setup for presto sql 0.334. When I run count (*) against a table or select single column, I get same number of rows and correct result every time. But when I select all the columns, output query returns random number of rows. If the actual result contains 1000 rows, it would return result ranging from 0 to 1000. My JDBC client gives consistent performance. Would you please suggest how can I add debugging to know the root cause of this behavior.