This is an automated email from the ASF dual-hosted git repository.

lijibing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 6f7e917f66a Fix hive p2 case (#31149)
6f7e917f66a is described below

commit 6f7e917f66ac4cccd267e4e85c740ef5907d20a8
Author: Jibing-Li <64681310+jibing...@users.noreply.github.com>
AuthorDate: Tue Feb 20 18:54:37 2024 +0800

    Fix hive p2 case (#31149)
---
 .../hive/test_hive_analyze_db.groovy               | 226 ++++++++++-----------
 1 file changed, 113 insertions(+), 113 deletions(-)

diff --git 
a/regression-test/suites/external_table_p2/hive/test_hive_analyze_db.groovy 
b/regression-test/suites/external_table_p2/hive/test_hive_analyze_db.groovy
index b0fffdef241..7d6373ffdc5 100644
--- a/regression-test/suites/external_table_p2/hive/test_hive_analyze_db.groovy
+++ b/regression-test/suites/external_table_p2/hive/test_hive_analyze_db.groovy
@@ -39,157 +39,157 @@ suite("test_hive_analyze_db", 
"p2,external,hive,external_remote,external_remote_
         assertEquals(result.size(), 17)
 
         assertEquals(result[0][0], "lo_orderpriority")
-        assertEquals(result[0][1], "100.0")
-        assertEquals(result[0][2], "5.0")
-        assertEquals(result[0][3], "0.0")
-        assertEquals(result[0][4], "880.0")
-        assertEquals(result[0][5], "8.8")
-        assertEquals(result[0][6], "'1-URGENT'")
-        assertEquals(result[0][7], "'5-LOW'")
+        assertEquals(result[0][2], "100.0")
+        assertEquals(result[0][3], "5.0")
+        assertEquals(result[0][4], "0.0")
+        assertEquals(result[0][5], "880.0")
+        assertEquals(result[0][6], "8.8")
+        assertEquals(result[0][7], "'1-URGENT'")
+        assertEquals(result[0][8], "'5-LOW'")
         
         assertEquals(result[1][0], "lo_custkey")
-        assertEquals(result[1][1], "100.0")
-        assertEquals(result[1][2], "26.0")
-        assertEquals(result[1][3], "0.0")
-        assertEquals(result[1][4], "400.0")
-        assertEquals(result[1][5], "4.0")
-        assertEquals(result[1][6], "67423")
-        assertEquals(result[1][7], "2735521")
+        assertEquals(result[1][2], "100.0")
+        assertEquals(result[1][3], "26.0")
+        assertEquals(result[1][4], "0.0")
+        assertEquals(result[1][5], "400.0")
+        assertEquals(result[1][6], "4.0")
+        assertEquals(result[1][7], "67423")
+        assertEquals(result[1][8], "2735521")
 
         assertEquals(result[2][0], "lo_partkey")
-        assertEquals(result[2][1], "100.0")
         assertEquals(result[2][2], "100.0")
-        assertEquals(result[2][3], "0.0")
-        assertEquals(result[2][4], "400.0")
-        assertEquals(result[2][5], "4.0")
-        assertEquals(result[2][6], "2250")
-        assertEquals(result[2][7], "989601")
+        assertEquals(result[2][3], "100.0")
+        assertEquals(result[2][4], "0.0")
+        assertEquals(result[2][5], "400.0")
+        assertEquals(result[2][6], "4.0")
+        assertEquals(result[2][7], "2250")
+        assertEquals(result[2][8], "989601")
 
         assertEquals(result[3][0], "lo_revenue")
-        assertEquals(result[3][1], "100.0")
         assertEquals(result[3][2], "100.0")
-        assertEquals(result[3][3], "0.0")
-        assertEquals(result[3][4], "400.0")
-        assertEquals(result[3][5], "4.0")
-        assertEquals(result[3][6], "101171")
-        assertEquals(result[3][7], "8703450")
+        assertEquals(result[3][3], "100.0")
+        assertEquals(result[3][4], "0.0")
+        assertEquals(result[3][5], "400.0")
+        assertEquals(result[3][6], "4.0")
+        assertEquals(result[3][7], "101171")
+        assertEquals(result[3][8], "8703450")
 
         assertEquals(result[4][0], "lo_commitdate")
-        assertEquals(result[4][1], "100.0")
-        assertEquals(result[4][2], "95.0")
-        assertEquals(result[4][3], "0.0")
-        assertEquals(result[4][4], "400.0")
-        assertEquals(result[4][5], "4.0")
-        assertEquals(result[4][6], "19920515")
-        assertEquals(result[4][7], "19981016")
+        assertEquals(result[4][2], "100.0")
+        assertEquals(result[4][3], "95.0")
+        assertEquals(result[4][4], "0.0")
+        assertEquals(result[4][5], "400.0")
+        assertEquals(result[4][6], "4.0")
+        assertEquals(result[4][7], "19920515")
+        assertEquals(result[4][8], "19981016")
         
         assertEquals(result[5][0], "lo_quantity")
-        assertEquals(result[5][1], "100.0")
-        assertEquals(result[5][2], "46.0")
-        assertEquals(result[5][3], "0.0")
-        assertEquals(result[5][4], "400.0")
-        assertEquals(result[5][5], "4.0")
-        assertEquals(result[5][6], "1")
-        assertEquals(result[5][7], "50")
+        assertEquals(result[5][2], "100.0")
+        assertEquals(result[5][3], "46.0")
+        assertEquals(result[5][4], "0.0")
+        assertEquals(result[5][5], "400.0")
+        assertEquals(result[5][6], "4.0")
+        assertEquals(result[5][7], "1")
+        assertEquals(result[5][8], "50")
 
         assertEquals(result[6][0], "lo_orderkey")
-        assertEquals(result[6][1], "100.0")
-        assertEquals(result[6][2], "26.0")
-        assertEquals(result[6][3], "0.0")
-        assertEquals(result[6][4], "400.0")
-        assertEquals(result[6][5], "4.0")
-        assertEquals(result[6][6], "1")
-        assertEquals(result[6][7], "98")
+        assertEquals(result[6][2], "100.0")
+        assertEquals(result[6][3], "26.0")
+        assertEquals(result[6][4], "0.0")
+        assertEquals(result[6][5], "400.0")
+        assertEquals(result[6][6], "4.0")
+        assertEquals(result[6][7], "1")
+        assertEquals(result[6][8], "98")
 
         assertEquals(result[7][0], "lo_suppkey")
-        assertEquals(result[7][1], "100.0")
         assertEquals(result[7][2], "100.0")
-        assertEquals(result[7][3], "0.0")
-        assertEquals(result[7][4], "400.0")
-        assertEquals(result[7][5], "4.0")
-        assertEquals(result[7][6], "4167")
-        assertEquals(result[7][7], "195845")
+        assertEquals(result[7][3], "100.0")
+        assertEquals(result[7][4], "0.0")
+        assertEquals(result[7][5], "400.0")
+        assertEquals(result[7][6], "4.0")
+        assertEquals(result[7][7], "4167")
+        assertEquals(result[7][8], "195845")
 
         assertEquals(result[8][0], "lo_supplycost")
-        assertEquals(result[8][1], "100.0")
         assertEquals(result[8][2], "100.0")
-        assertEquals(result[8][3], "0.0")
-        assertEquals(result[8][4], "400.0")
-        assertEquals(result[8][5], "4.0")
-        assertEquals(result[8][6], "58023")
-        assertEquals(result[8][7], "121374")
+        assertEquals(result[8][3], "100.0")
+        assertEquals(result[8][4], "0.0")
+        assertEquals(result[8][5], "400.0")
+        assertEquals(result[8][6], "4.0")
+        assertEquals(result[8][7], "58023")
+        assertEquals(result[8][8], "121374")
 
         assertEquals(result[9][0], "lo_shipmode")
-        assertEquals(result[9][1], "100.0")
-        assertEquals(result[9][2], "7.0")
-        assertEquals(result[9][3], "0.0")
-        assertEquals(result[9][4], "421.0")
-        assertEquals(result[9][5], "4.21")
-        assertEquals(result[9][6], "'AIR'")
-        assertEquals(result[9][7], "'TRUCK'")
+        assertEquals(result[9][2], "100.0")
+        assertEquals(result[9][3], "7.0")
+        assertEquals(result[9][4], "0.0")
+        assertEquals(result[9][5], "421.0")
+        assertEquals(result[9][6], "4.21")
+        assertEquals(result[9][7], "'AIR'")
+        assertEquals(result[9][8], "'TRUCK'")
 
         assertEquals(result[10][0], "lo_orderdate")
-        assertEquals(result[10][1], "100.0")
-        assertEquals(result[10][2], "26.0")
-        assertEquals(result[10][3], "0.0")
-        assertEquals(result[10][4], "400.0")
-        assertEquals(result[10][5], "4.0")
-        assertEquals(result[10][6], "19920221")
-        assertEquals(result[10][7], "19980721")
+        assertEquals(result[10][2], "100.0")
+        assertEquals(result[10][3], "26.0")
+        assertEquals(result[10][4], "0.0")
+        assertEquals(result[10][5], "400.0")
+        assertEquals(result[10][6], "4.0")
+        assertEquals(result[10][7], "19920221")
+        assertEquals(result[10][8], "19980721")
 
         assertEquals(result[11][0], "lo_linenumber")
-        assertEquals(result[11][1], "100.0")
-        assertEquals(result[11][2], "7.0")
-        assertEquals(result[11][3], "0.0")
-        assertEquals(result[11][4], "400.0")
-        assertEquals(result[11][5], "4.0")
-        assertEquals(result[11][6], "1")
-        assertEquals(result[11][7], "7")
+        assertEquals(result[11][2], "100.0")
+        assertEquals(result[11][3], "7.0")
+        assertEquals(result[11][4], "0.0")
+        assertEquals(result[11][5], "400.0")
+        assertEquals(result[11][6], "4.0")
+        assertEquals(result[11][7], "1")
+        assertEquals(result[11][8], "7")
 
         assertEquals(result[12][0], "lo_shippriority")
-        assertEquals(result[12][1], "100.0")
-        assertEquals(result[12][2], "1.0")
-        assertEquals(result[12][3], "0.0")
-        assertEquals(result[12][4], "400.0")
-        assertEquals(result[12][5], "4.0")
-        assertEquals(result[12][6], "0")
+        assertEquals(result[12][2], "100.0")
+        assertEquals(result[12][3], "1.0")
+        assertEquals(result[12][4], "0.0")
+        assertEquals(result[12][5], "400.0")
+        assertEquals(result[12][6], "4.0")
         assertEquals(result[12][7], "0")
+        assertEquals(result[12][8], "0")
 
         assertEquals(result[13][0], "lo_ordtotalprice")
-        assertEquals(result[13][1], "100.0")
-        assertEquals(result[13][2], "26.0")
-        assertEquals(result[13][3], "0.0")
-        assertEquals(result[13][4], "400.0")
-        assertEquals(result[13][5], "4.0")
-        assertEquals(result[13][6], "3428256")
-        assertEquals(result[13][7], "36771805")
+        assertEquals(result[13][2], "100.0")
+        assertEquals(result[13][3], "26.0")
+        assertEquals(result[13][4], "0.0")
+        assertEquals(result[13][5], "400.0")
+        assertEquals(result[13][6], "4.0")
+        assertEquals(result[13][7], "3428256")
+        assertEquals(result[13][8], "36771805")
 
         assertEquals(result[14][0], "lo_extendedprice")
-        assertEquals(result[14][1], "100.0")
         assertEquals(result[14][2], "100.0")
-        assertEquals(result[14][3], "0.0")
-        assertEquals(result[14][4], "400.0")
-        assertEquals(result[14][5], "4.0")
-        assertEquals(result[14][6], "104300")
-        assertEquals(result[14][7], "9066094")
+        assertEquals(result[14][3], "100.0")
+        assertEquals(result[14][4], "0.0")
+        assertEquals(result[14][5], "400.0")
+        assertEquals(result[14][6], "4.0")
+        assertEquals(result[14][7], "104300")
+        assertEquals(result[14][8], "9066094")
 
         assertEquals(result[15][0], "lo_tax")
-        assertEquals(result[15][1], "100.0")
-        assertEquals(result[15][2], "9.0")
-        assertEquals(result[15][3], "0.0")
-        assertEquals(result[15][4], "400.0")
-        assertEquals(result[15][5], "4.0")
-        assertEquals(result[15][6], "0")
-        assertEquals(result[15][7], "8")
+        assertEquals(result[15][2], "100.0")
+        assertEquals(result[15][3], "9.0")
+        assertEquals(result[15][4], "0.0")
+        assertEquals(result[15][5], "400.0")
+        assertEquals(result[15][6], "4.0")
+        assertEquals(result[15][7], "0")
+        assertEquals(result[15][8], "8")
 
         assertEquals(result[16][0], "lo_discount")
-        assertEquals(result[16][1], "100.0")
-        assertEquals(result[16][2], "11.0")
-        assertEquals(result[16][3], "0.0")
-        assertEquals(result[16][4], "400.0")
-        assertEquals(result[16][5], "4.0")
-        assertEquals(result[16][6], "0")
-        assertEquals(result[16][7], "10")
+        assertEquals(result[16][2], "100.0")
+        assertEquals(result[16][3], "11.0")
+        assertEquals(result[16][4], "0.0")
+        assertEquals(result[16][5], "400.0")
+        assertEquals(result[16][6], "4.0")
+        assertEquals(result[16][7], "0")
+        assertEquals(result[16][8], "10")
     }
 }
 


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to