xinyiZzz commented on issue #25514: URL: https://github.com/apache/doris/issues/25514#issuecomment-1766374558
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";><body><div style="-en-clipboard:true;"><br /></div> describe | Read 100w rows from clickbench table, all columns | Read 1000w rows from clickbench table, only string column URL | Read 1000w rows from clickbench table, only int column ClientIP | Read 1000w rows from clickbench table, only bool column CounterClass | Read 100w rows from 96float_table, all columns | Read 2000w rows from 96float_table, only float column | Read 2000w rows from 96float_table, only string column -- | -- | -- | -- | -- | -- | -- | -- SQL | select * from clickbench.hits limit 1000000 | select URL from clickbench.hits where URL!='' limit 10000000 | select ClientIP from clickbench.hits limit 10000000; | select CounterClass from clickbench.hits where CounterClass!=0 limit 10000000; | select * from 96float_table limit 1000000 | select k1 from 96float_table | select k0 from 96float_table; | **pymysql** | **229.72(Unit: s)** | **68.21946** | **70.097648** | **68.84048** | **200.88983** | **132.46575** | **126.32184** | pandas.read_sql | 248.41 | 79.298519 | 80.461473 | 91.333049 | 206.912296 | 152.666138 | 147.955599 | jaydebeapi | >30min | | | | | | | MySQLdb/mysqlclient | | | | | 197.3066 | | | mysql.connector | | | | | Failed, only 49w of data was read, it seems like streaming reading | | | python-jdbc | >30min | | | | | | | **flightsql** | **3.920499** | **3.614652** | **0.154683** | **0.109124** | **1.049839** | **1.974839** | **6.195701** </body></html> -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
