dh20 commented on issue #1762:
URL: https://github.com/apache/auron/issues/1762#issuecomment-3664628196

   sql:select id,appl_no from db.test where id=2016121800021202
   
   This is the correct return:
   <img width="450" height="126" alt="Image" 
src="https://github.com/user-attachments/assets/0d35589e-8633-4ba3-bff4-2742c48533a4";
 />
   
   This is the return of opening auron:
   
   <img width="399" height="111" alt="Image" 
src="https://github.com/user-attachments/assets/62fb30b9-6895-4c3f-ae20-a58990034748";
 />
   
   Aggregate and query this id,Discovered that the ID data was duplicated and 
disordered during reading
   sql: select count(1) as nmb ,id from  db.testgroup by id order by nmb desc 
limit 10;
   error:
   <img width="262" height="305" alt="Image" 
src="https://github.com/user-attachments/assets/f31c981e-e80b-468e-aad0-de119dab749a";
 />
   normal:
   
   <img width="349" height="364" alt="Image" 
src="https://github.com/user-attachments/assets/6e7da96c-92e5-4c19-afe8-f8686538323e";
 />
   
   When I tried to use the Parquet file to retrieve this data, I did not 
encounter this issue
   
   my env :
   spark3.3.2 orc1.7.8 auron0.6
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to