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

dataroaring 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 7164b7cebb0   [case](regression) add read json by line test case 
(#26670)
7164b7cebb0 is described below

commit 7164b7cebb03452ecf27318a237768cc8db564bf
Author: HowardQin <[email protected]>
AuthorDate: Mon Nov 20 17:33:40 2023 +0800

      [case](regression) add read json by line test case (#26670)
    
    
    
    Co-authored-by: qinhao <[email protected]>
---
 .../stream_load/test_stream_load_properties.out    | 144 +++++++++++++++++++++
 .../load_p0/stream_load/test_stream_load.groovy    |   4 +-
 .../stream_load/test_stream_load_properties.groovy |  63 +++++++++
 3 files changed, 209 insertions(+), 2 deletions(-)

diff --git 
a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out 
b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
index b4219a11cd5..d62bb723676 100644
--- a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
+++ b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
@@ -1082,3 +1082,147 @@
 76     [1, 1, 1, 1, 1, 1]      [-63, -63, -63, -63, -63, -63]  [25799, 25799, 
25799, 25799, 25799, 25799]      [-1387912656, -1387912656, -1387912656, 
-1387912656, -1387912656, -1387912656]  [8967926767558546181, 
8967926767558546181, 8967926767558546181, 8967926767558546181, 
8967926767558546181, 8967926767558546181]  [-3537865898119184476, 
-3537865898119184476, -3537865898119184476, -3537865898119184476, 
-3537865898119184476, -3537865898119184476]    [5311.188, 5311.188, 5311.188, 
5311.188, 5311.188]      [17362 [...]
 84     [0, 0, 0, 0, 0, 0]      [-10, -10, -10, -10, -10, -10]  [9493, 9493, 
9493, 9493, 9493, 9493]    [-547874696, -547874696, -547874696, -547874696, 
-547874696, -547874696]        [-115057683458952756, -115057683458952756, 
-115057683458952756, -115057683458952756, -115057683458952756, 
-115057683458952756]  [4473017779279230085, 4473017779279230085, 
4473017779279230085, 4473017779279230085, 4473017779279230085, 
4473017779279230085]  [13718.372, 13718.372, 13718.372, 13718.372, 13718.372] 
[-978213266.02697,  [...]
 
+-- !sql_json_read_by_line --
+8      2023-08-14      true    109     -31573  -1362465190     
3990845741226497177     2732763251146840270     -25698.553      
1.312831962567818E9     \N      \N      2023-03-07T14:13:19     2022-10-18      
2023-07-16T05:03:13     D               
PBn1wa6X8WneZYLMac11zzyhGl7tPXB5XgjmOV8L6uav9ja5oY433ktb2yhyQQIqBveZPkme        
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+20     2023-08-17      false   -5      18158   784479801       
1485484354598941738     -6632681928222776815    9708.431        
-3.30432620706069E8     \N      \N      2022-09-15T21:40:55     2023-02-23      
2023-08-13T21:31:54     O       X       
2pYmX2vAhfEEHZZYPsgAmda1G7otnwx5TmUC879FPhDeIjvWI79ksBZpfFG2gp7jhCSbpZiecKGklB5SvG8tm31i5SUqe1xrWgLt4HSq7lMJWp75tx2kxD7pRIOpn
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+21     2023-08-18      false   63      -27847  -35409596       
8638201997392767650     4919963231735304178     -23382.541      
-1.803403621426313E9    -22009767.0     \N      2023-03-31T10:56:14     
2023-01-20      2023-02-18T13:37:52     N       T       
PSiFwUEx3eVFNtjlnQ70YkgZNvKrGmQ2DN5K9yYHiSdFWeEDB1UpL3Frt8z1kEAIWRDWqXZuyi      
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+31     2023-08-27      false   17      -18849  1728109133      
3266501886640700374     527195452623418935      -24062.328      
-1.514348021262435E9    \N      \N      2022-10-07T03:24:23     2022-09-25      
\N      0       8       
yKMiAntORoRa8svnMfcxlOPwwND1m5s2fdS26Xu6cfs6HK5SAibqIp9h8sZcpjHy4       \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+41     2023-08-27      true    -104    22750   \N      8527773271030840740     
5554497317268279215     -5296.828       -1.71564688801304E9     \N      \N      
2022-12-02T17:56:44     2022-10-12      2023-02-19T07:02:54     V               
E9GzQdTwX1ITUQz27IVznAs6Ca4WwprKk6Odjs6SH75D2F1089QiY3HQ52LXRD1V6xAWjhLE2hWgW3EdHuAOnUDVrb5V
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+49     2023-08-08      false   \N      16275   -2144851675     
-2303421957908954634    -46526938720058765      -13141.143      
-6.866322332302E8       \N      \N      2022-09-01T00:16:01     2023-03-25      
2022-09-07T14:59:03     s               yvuILR2iNxfe8RRml       \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+50     2023-08-06      true    109     -6330   1479023892      
-8630800697573159428    -1645095773540208759    17880.96        
-1.453844792013949E9    \N      \N      2022-09-22T02:03:21     2023-05-14      
2023-03-25T02:18:34     m               
JKnIgXvGVidGiWl9YRSi3mFI7wHKt1sBpWSadKF8VX3LAuElm4sdc9gtxREaUr57oikSYlU8We8h1MWqQlYNiJObl
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+50     2023-08-24      true    15      14403   \N      -6418906115745394180    
9205303779366462513     -4331.549       -6.15112179557648E8     \N      \N      
2022-12-29T02:27:20     2023-06-01      2023-08-12T04:50:04     a               
eCl38sztIvBQvGvGKyYZmyMXy9vIJx197iu3JwP9doJGcrYUl9Uova0rz4iCCgrjlAiZU18Fs9YtCq830nhM
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+57     2023-08-19      true    2       -25462  -74112029       
6458082754318544493     -7910671781690629051    -15205.859      
-3.06870797484914E8     \N      \N      2023-07-10T18:39:10     2023-02-12      
2023-01-27T07:26:06     y               Xi9nDVrLv8m6AwEpUxmtzFAuK48sQ   \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+58     2023-08-22      \N      0       -18231  1832867360      
6997858407575297145     2480714305422728023     -5450.489       
1.475901032138386E9     \N      \N      2023-02-02T05:13:24     2022-09-18      
2023-04-23T10:51:15     k               
LdFXF7Kmfzgmnn2R6zLsXdmi3A2cLBLq4G4WDVNDhxvH7dYH8Kga2WA47uSIxp6NSrwPSdw0ssB1TS8RFJTDJAB0Uba3e05NL2Aiw0ja
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+60     2023-08-27      false   -52     -2338   -757056972      
1047567408607120856     6541476642780646552     6614.0894       
-1.204448798517855E9    \N      \N      2022-12-29T14:47:30     2022-09-24      
2023-08-01T12:41:59     O       F       
RM4F1Ke7lkcnuxF2nK0j9VBW3MDcgyHR4pseBjtFnqS6GUkVFuzF6u3Cp9Nv7ab0O6UYrpP4DhU     
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+62     2023-08-21      false   81      20302   -200761532      
6365479976421007608     \N      -29916.533      1.709141750828478E9     \N      
\N      2023-05-04T01:14:51     2022-09-17      2022-12-04T19:30:09     d       
v       
BKWy9dTNg1aZW7ancEJAmEDOPK5TwFsNSHbI78emu9gymeIlx5NoLmyii0QAqdzRvSQPZKiqKkwInGCTIBnK1yYkK7zD
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+65     2023-08-09      false   94      31514   814994517       
-297697460695940343     734910652450318597      -13061.892      
6.2750847041706E7       -9808654.0      \N      2023-08-14T22:01:27     
2023-05-19      2022-11-13T13:44:28     V               
aGeMsI24O12chGlP5ak0AHghAz7bu5MargJBStHnt0yMnChH0JnfYhsfH1u59XIHkJKMsHYktBqORkGlovu8V47E74KeFpaqxn5yLyXfDbhhzUKf
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+66     2023-08-15      true    -91     28378   609923317       
4872185586197131212     1207709464099378591     \N      -1.863683325985123E9    
\N      \N      2022-09-24T10:39:23     2022-09-24      2022-10-16T18:36:43     
Y       z       
AI1BSPQdKiHJiQH1kguyLSWsDXkC7zwy7PwgWnyGSaa9tBKRex8vHBdxg2QSKZKL2mV2lHz7iI1PnsTd4MXDcIKhqiHyPuQPt2tEtgt0UgF6
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+68     2023-08-23      true    -73     20117   1737338128      
795638676048937749      -5551546237562433901    -30627.04       
6.8589475684545E7       \N      \N      2022-12-28T20:26:51     2022-10-04      
2023-07-30T00:20:06     y               
keZ3JlWWpdnPBejf0cuiCQCVBBTd5gjvO08NVdcAFewqL7nRT4N9lnvSU6pWmletA5VbPQCeQapJdcnQCHfZUDCf4ulCnczyqr7SGrbGRT0XYcd7iktKM
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+80     2023-08-18      false   -18     -8971   679027874       
6535956962935330265     3960889045799757165     -13219.76       
1.187161924505394E9     \N      \N      2023-03-11T07:40        2022-11-29      
2023-01-14T07:24:07     N       D       
3Nhx6xX1qdwaq7lxwLRSKMtJFbC03swWv12mpySSVysH3igGZTiGPuKMsYW7HAkf6CWc7c0nzqDsjuH3FYVMNCWRmfxMrmY8rykQCC4Ve
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+81     2023-08-23      false   106     11492   -667795397      
4480250461471356146     -5346660566234294101    9082.75 3.85167225902608E8      
\N      \N      2023-03-20T03:33:16     2022-11-24      2023-02-16T18:29:41     
G       9       Lk3eNVQNjucbekD1rZmUlGPiXS5JvcWr2LQzRU8GSGIbSag \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+85     2023-08-11      true    -7      24304   -2043877415     
-2024144417867729183    \N      5363.0244       -5.78615669042831E8     \N      
\N      2023-07-15T01:07:41     2023-08-13      2023-01-20T11:57:48     i       
        WQ9dh9ajPu0y    \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+90     2023-08-27      true    22      16456   -1476824962     
-3279894870153540825    8990195191470116763     26651.906       
2.06860148942546E8      \N      \N      2022-10-07T03:11:03     2023-03-18      
2023-04-15T00:38:33     T       L       
QW0GQ3GoMtHgxPQOWGfVaveynahNpsNs09siMFA1OtO6QEDBQTdivmGyq7bFzejAqwbbVQQpREAmeLjcFSXLnQuou2KbwYD
 \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+91     2023-08-27      true    90      2465    702240964       
6373830997821598984     305860046137409400      15991.356       
1.599972327386147E9     \N      \N      2023-04-26T19:31:10     2023-07-21      
\N      2               
B7YKYBYT8w0YC926bZ8Yz1VzyiWw2NWDAiTlEoPVyz9AXGti2Npg1FxWqWk4hEaALw0ZBSuiAIPj41lq36g5QRpPmAjNPK
  \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+
+-- !sql_json_read_by_line --
+8      2023-08-14      true    109     -31573  -1362465190     
3990845741226497177     2732763251146840270     -25698.553      
1.312831962567818E9     \N      \N      2023-03-07T14:13:19     2022-10-18      
2023-07-16T05:03:13     D               
PBn1wa6X8WneZYLMac11zzyhGl7tPXB5XgjmOV8L6uav9ja5oY433ktb2yhyQQIqBveZPkme        
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+20     2023-08-17      false   -5      18158   784479801       
1485484354598941738     -6632681928222776815    9708.431        
-3.30432620706069E8     \N      \N      2022-09-15T21:40:55     2023-02-23      
2023-08-13T21:31:54     O       X       
2pYmX2vAhfEEHZZYPsgAmda1G7otnwx5TmUC879FPhDeIjvWI79ksBZpfFG2gp7jhCSbpZiecKGklB5SvG8tm31i5SUqe1xrWgLt4HSq7lMJWp75tx2kxD7pRIOpn
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+21     2023-08-18      false   63      -27847  -35409596       
8638201997392767650     4919963231735304178     -23382.541      
-1.803403621426313E9    -22009767.0     \N      2023-03-31T10:56:14     
2023-01-20      2023-02-18T13:37:52     N       T       
PSiFwUEx3eVFNtjlnQ70YkgZNvKrGmQ2DN5K9yYHiSdFWeEDB1UpL3Frt8z1kEAIWRDWqXZuyi      
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+31     2023-08-27      false   17      -18849  1728109133      
3266501886640700374     527195452623418935      -24062.328      
-1.514348021262435E9    \N      \N      2022-10-07T03:24:23     2022-09-25      
\N      0       8       
yKMiAntORoRa8svnMfcxlOPwwND1m5s2fdS26Xu6cfs6HK5SAibqIp9h8sZcpjHy4       \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+41     2023-08-27      true    -104    22750   \N      8527773271030840740     
5554497317268279215     -5296.828       -1.71564688801304E9     \N      \N      
2022-12-02T17:56:44     2022-10-12      2023-02-19T07:02:54     V               
E9GzQdTwX1ITUQz27IVznAs6Ca4WwprKk6Odjs6SH75D2F1089QiY3HQ52LXRD1V6xAWjhLE2hWgW3EdHuAOnUDVrb5V
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+49     2023-08-08      false   \N      16275   -2144851675     
-2303421957908954634    -46526938720058765      -13141.143      
-6.866322332302E8       \N      \N      2022-09-01T00:16:01     2023-03-25      
2022-09-07T14:59:03     s               yvuILR2iNxfe8RRml       \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+50     2023-08-06      true    109     -6330   1479023892      
-8630800697573159428    -1645095773540208759    17880.96        
-1.453844792013949E9    \N      \N      2022-09-22T02:03:21     2023-05-14      
2023-03-25T02:18:34     m               
JKnIgXvGVidGiWl9YRSi3mFI7wHKt1sBpWSadKF8VX3LAuElm4sdc9gtxREaUr57oikSYlU8We8h1MWqQlYNiJObl
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+50     2023-08-24      true    15      14403   \N      -6418906115745394180    
9205303779366462513     -4331.549       -6.15112179557648E8     \N      \N      
2022-12-29T02:27:20     2023-06-01      2023-08-12T04:50:04     a               
eCl38sztIvBQvGvGKyYZmyMXy9vIJx197iu3JwP9doJGcrYUl9Uova0rz4iCCgrjlAiZU18Fs9YtCq830nhM
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+57     2023-08-19      true    2       -25462  -74112029       
6458082754318544493     -7910671781690629051    -15205.859      
-3.06870797484914E8     \N      \N      2023-07-10T18:39:10     2023-02-12      
2023-01-27T07:26:06     y               Xi9nDVrLv8m6AwEpUxmtzFAuK48sQ   \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+58     2023-08-22      \N      0       -18231  1832867360      
6997858407575297145     2480714305422728023     -5450.489       
1.475901032138386E9     \N      \N      2023-02-02T05:13:24     2022-09-18      
2023-04-23T10:51:15     k               
LdFXF7Kmfzgmnn2R6zLsXdmi3A2cLBLq4G4WDVNDhxvH7dYH8Kga2WA47uSIxp6NSrwPSdw0ssB1TS8RFJTDJAB0Uba3e05NL2Aiw0ja
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+60     2023-08-27      false   -52     -2338   -757056972      
1047567408607120856     6541476642780646552     6614.0894       
-1.204448798517855E9    \N      \N      2022-12-29T14:47:30     2022-09-24      
2023-08-01T12:41:59     O       F       
RM4F1Ke7lkcnuxF2nK0j9VBW3MDcgyHR4pseBjtFnqS6GUkVFuzF6u3Cp9Nv7ab0O6UYrpP4DhU     
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+62     2023-08-21      false   81      20302   -200761532      
6365479976421007608     \N      -29916.533      1.709141750828478E9     \N      
\N      2023-05-04T01:14:51     2022-09-17      2022-12-04T19:30:09     d       
v       
BKWy9dTNg1aZW7ancEJAmEDOPK5TwFsNSHbI78emu9gymeIlx5NoLmyii0QAqdzRvSQPZKiqKkwInGCTIBnK1yYkK7zD
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+65     2023-08-09      false   94      31514   814994517       
-297697460695940343     734910652450318597      -13061.892      
6.2750847041706E7       -9808654.0      \N      2023-08-14T22:01:27     
2023-05-19      2022-11-13T13:44:28     V               
aGeMsI24O12chGlP5ak0AHghAz7bu5MargJBStHnt0yMnChH0JnfYhsfH1u59XIHkJKMsHYktBqORkGlovu8V47E74KeFpaqxn5yLyXfDbhhzUKf
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+66     2023-08-15      true    -91     28378   609923317       
4872185586197131212     1207709464099378591     \N      -1.863683325985123E9    
\N      \N      2022-09-24T10:39:23     2022-09-24      2022-10-16T18:36:43     
Y       z       
AI1BSPQdKiHJiQH1kguyLSWsDXkC7zwy7PwgWnyGSaa9tBKRex8vHBdxg2QSKZKL2mV2lHz7iI1PnsTd4MXDcIKhqiHyPuQPt2tEtgt0UgF6
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+68     2023-08-23      true    -73     20117   1737338128      
795638676048937749      -5551546237562433901    -30627.04       
6.8589475684545E7       \N      \N      2022-12-28T20:26:51     2022-10-04      
2023-07-30T00:20:06     y               
keZ3JlWWpdnPBejf0cuiCQCVBBTd5gjvO08NVdcAFewqL7nRT4N9lnvSU6pWmletA5VbPQCeQapJdcnQCHfZUDCf4ulCnczyqr7SGrbGRT0XYcd7iktKM
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+80     2023-08-18      false   -18     -8971   679027874       
6535956962935330265     3960889045799757165     -13219.76       
1.187161924505394E9     \N      \N      2023-03-11T07:40        2022-11-29      
2023-01-14T07:24:07     N       D       
3Nhx6xX1qdwaq7lxwLRSKMtJFbC03swWv12mpySSVysH3igGZTiGPuKMsYW7HAkf6CWc7c0nzqDsjuH3FYVMNCWRmfxMrmY8rykQCC4Ve
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+81     2023-08-23      false   106     11492   -667795397      
4480250461471356146     -5346660566234294101    9082.75 3.85167225902608E8      
\N      \N      2023-03-20T03:33:16     2022-11-24      2023-02-16T18:29:41     
G       9       Lk3eNVQNjucbekD1rZmUlGPiXS5JvcWr2LQzRU8GSGIbSag \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+85     2023-08-11      true    -7      24304   -2043877415     
-2024144417867729183    \N      5363.0244       -5.78615669042831E8     \N      
\N      2023-07-15T01:07:41     2023-08-13      2023-01-20T11:57:48     i       
        WQ9dh9ajPu0y    \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+90     2023-08-27      true    22      16456   -1476824962     
-3279894870153540825    8990195191470116763     26651.906       
2.06860148942546E8      \N      \N      2022-10-07T03:11:03     2023-03-18      
2023-04-15T00:38:33     T       L       
QW0GQ3GoMtHgxPQOWGfVaveynahNpsNs09siMFA1OtO6QEDBQTdivmGyq7bFzejAqwbbVQQpREAmeLjcFSXLnQuou2KbwYD
 \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+91     2023-08-27      true    90      2465    702240964       
6373830997821598984     305860046137409400      15991.356       
1.599972327386147E9     \N      \N      2023-04-26T19:31:10     2023-07-21      
\N      2               
B7YKYBYT8w0YC926bZ8Yz1VzyiWw2NWDAiTlEoPVyz9AXGti2Npg1FxWqWk4hEaALw0ZBSuiAIPj41lq36g5QRpPmAjNPK
  \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+
+-- !sql_json_read_by_line --
+8      2023-08-14      true    109     -31573  -1362465190     
3990845741226497177     2732763251146840270     -25698.553      
1.312831962567818E9     \N      \N      2023-03-07T14:13:19     2022-10-18      
2023-07-16T05:03:13     D               
PBn1wa6X8WneZYLMac11zzyhGl7tPXB5XgjmOV8L6uav9ja5oY433ktb2yhyQQIqBveZPkme        
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+20     2023-08-17      false   -5      18158   784479801       
1485484354598941738     -6632681928222776815    9708.431        
-3.30432620706069E8     \N      \N      2022-09-15T21:40:55     2023-02-23      
2023-08-13T21:31:54     O       X       
2pYmX2vAhfEEHZZYPsgAmda1G7otnwx5TmUC879FPhDeIjvWI79ksBZpfFG2gp7jhCSbpZiecKGklB5SvG8tm31i5SUqe1xrWgLt4HSq7lMJWp75tx2kxD7pRIOpn
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+21     2023-08-18      false   63      -27847  -35409596       
8638201997392767650     4919963231735304178     -23382.541      
-1.803403621426313E9    -22009767.0     \N      2023-03-31T10:56:14     
2023-01-20      2023-02-18T13:37:52     N       T       
PSiFwUEx3eVFNtjlnQ70YkgZNvKrGmQ2DN5K9yYHiSdFWeEDB1UpL3Frt8z1kEAIWRDWqXZuyi      
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+31     2023-08-27      false   17      -18849  1728109133      
3266501886640700374     527195452623418935      -24062.328      
-1.514348021262435E9    \N      \N      2022-10-07T03:24:23     2022-09-25      
\N      0       8       
yKMiAntORoRa8svnMfcxlOPwwND1m5s2fdS26Xu6cfs6HK5SAibqIp9h8sZcpjHy4       \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+41     2023-08-27      true    -104    22750   \N      8527773271030840740     
5554497317268279215     -5296.828       -1.71564688801304E9     \N      \N      
2022-12-02T17:56:44     2022-10-12      2023-02-19T07:02:54     V               
E9GzQdTwX1ITUQz27IVznAs6Ca4WwprKk6Odjs6SH75D2F1089QiY3HQ52LXRD1V6xAWjhLE2hWgW3EdHuAOnUDVrb5V
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+49     2023-08-08      false   \N      16275   -2144851675     
-2303421957908954634    -46526938720058765      -13141.143      
-6.866322332302E8       \N      \N      2022-09-01T00:16:01     2023-03-25      
2022-09-07T14:59:03     s               yvuILR2iNxfe8RRml       \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+50     2023-08-06      true    109     -6330   1479023892      
-8630800697573159428    -1645095773540208759    17880.96        
-1.453844792013949E9    \N      \N      2022-09-22T02:03:21     2023-05-14      
2023-03-25T02:18:34     m               
JKnIgXvGVidGiWl9YRSi3mFI7wHKt1sBpWSadKF8VX3LAuElm4sdc9gtxREaUr57oikSYlU8We8h1MWqQlYNiJObl
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+50     2023-08-24      true    15      14403   \N      -6418906115745394180    
9205303779366462513     -4331.549       -6.15112179557648E8     \N      \N      
2022-12-29T02:27:20     2023-06-01      2023-08-12T04:50:04     a               
eCl38sztIvBQvGvGKyYZmyMXy9vIJx197iu3JwP9doJGcrYUl9Uova0rz4iCCgrjlAiZU18Fs9YtCq830nhM
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+57     2023-08-19      true    2       -25462  -74112029       
6458082754318544493     -7910671781690629051    -15205.859      
-3.06870797484914E8     \N      \N      2023-07-10T18:39:10     2023-02-12      
2023-01-27T07:26:06     y               Xi9nDVrLv8m6AwEpUxmtzFAuK48sQ   \N      
true    1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+58     2023-08-22      \N      0       -18231  1832867360      
6997858407575297145     2480714305422728023     -5450.489       
1.475901032138386E9     \N      \N      2023-02-02T05:13:24     2022-09-18      
2023-04-23T10:51:15     k               
LdFXF7Kmfzgmnn2R6zLsXdmi3A2cLBLq4G4WDVNDhxvH7dYH8Kga2WA47uSIxp6NSrwPSdw0ssB1TS8RFJTDJAB0Uba3e05NL2Aiw0ja
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+60     2023-08-27      false   -52     -2338   -757056972      
1047567408607120856     6541476642780646552     6614.0894       
-1.204448798517855E9    \N      \N      2022-12-29T14:47:30     2022-09-24      
2023-08-01T12:41:59     O       F       
RM4F1Ke7lkcnuxF2nK0j9VBW3MDcgyHR4pseBjtFnqS6GUkVFuzF6u3Cp9Nv7ab0O6UYrpP4DhU     
\N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+62     2023-08-21      false   81      20302   -200761532      
6365479976421007608     \N      -29916.533      1.709141750828478E9     \N      
\N      2023-05-04T01:14:51     2022-09-17      2022-12-04T19:30:09     d       
v       
BKWy9dTNg1aZW7ancEJAmEDOPK5TwFsNSHbI78emu9gymeIlx5NoLmyii0QAqdzRvSQPZKiqKkwInGCTIBnK1yYkK7zD
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+65     2023-08-09      false   94      31514   814994517       
-297697460695940343     734910652450318597      -13061.892      
6.2750847041706E7       -9808654.0      \N      2023-08-14T22:01:27     
2023-05-19      2022-11-13T13:44:28     V               
aGeMsI24O12chGlP5ak0AHghAz7bu5MargJBStHnt0yMnChH0JnfYhsfH1u59XIHkJKMsHYktBqORkGlovu8V47E74KeFpaqxn5yLyXfDbhhzUKf
        \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+66     2023-08-15      true    -91     28378   609923317       
4872185586197131212     1207709464099378591     \N      -1.863683325985123E9    
\N      \N      2022-09-24T10:39:23     2022-09-24      2022-10-16T18:36:43     
Y       z       
AI1BSPQdKiHJiQH1kguyLSWsDXkC7zwy7PwgWnyGSaa9tBKRex8vHBdxg2QSKZKL2mV2lHz7iI1PnsTd4MXDcIKhqiHyPuQPt2tEtgt0UgF6
    \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+68     2023-08-23      true    -73     20117   1737338128      
795638676048937749      -5551546237562433901    -30627.04       
6.8589475684545E7       \N      \N      2022-12-28T20:26:51     2022-10-04      
2023-07-30T00:20:06     y               
keZ3JlWWpdnPBejf0cuiCQCVBBTd5gjvO08NVdcAFewqL7nRT4N9lnvSU6pWmletA5VbPQCeQapJdcnQCHfZUDCf4ulCnczyqr7SGrbGRT0XYcd7iktKM
   \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+80     2023-08-18      false   -18     -8971   679027874       
6535956962935330265     3960889045799757165     -13219.76       
1.187161924505394E9     \N      \N      2023-03-11T07:40        2022-11-29      
2023-01-14T07:24:07     N       D       
3Nhx6xX1qdwaq7lxwLRSKMtJFbC03swWv12mpySSVysH3igGZTiGPuKMsYW7HAkf6CWc7c0nzqDsjuH3FYVMNCWRmfxMrmY8rykQCC4Ve
       \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+81     2023-08-23      false   106     11492   -667795397      
4480250461471356146     -5346660566234294101    9082.75 3.85167225902608E8      
\N      \N      2023-03-20T03:33:16     2022-11-24      2023-02-16T18:29:41     
G       9       Lk3eNVQNjucbekD1rZmUlGPiXS5JvcWr2LQzRU8GSGIbSag \N      true    
1       2       3       4       5       6.0     7.0     888888888       
999999999       2023-08-24      2023-08-24T12:00        2023-08-24      
2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+85     2023-08-11      true    -7      24304   -2043877415     
-2024144417867729183    \N      5363.0244       -5.78615669042831E8     \N      
\N      2023-07-15T01:07:41     2023-08-13      2023-01-20T11:57:48     i       
        WQ9dh9ajPu0y    \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N
+90     2023-08-27      true    22      16456   -1476824962     
-3279894870153540825    8990195191470116763     26651.906       
2.06860148942546E8      \N      \N      2022-10-07T03:11:03     2023-03-18      
2023-04-15T00:38:33     T       L       
QW0GQ3GoMtHgxPQOWGfVaveynahNpsNs09siMFA1OtO6QEDBQTdivmGyq7bFzejAqwbbVQQpREAmeLjcFSXLnQuou2KbwYD
 \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+91     2023-08-27      true    90      2465    702240964       
6373830997821598984     305860046137409400      15991.356       
1.599972327386147E9     \N      \N      2023-04-26T19:31:10     2023-07-21      
\N      2               
B7YKYBYT8w0YC926bZ8Yz1VzyiWw2NWDAiTlEoPVyz9AXGti2Npg1FxWqWk4hEaALw0ZBSuiAIPj41lq36g5QRpPmAjNPK
  \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N
+
+-- !sql_json_read_by_line --
+8      2023-08-14      true    109     -31573  -1362465190     
3990845741226497177     2732763251146840270     -25698.553      
1.312831962567818E9     \N      \N      2023-03-07T14:13:19     2022-10-18      
2023-07-16T05:03:13     D               
PBn1wa6X8WneZYLMac11zzyhGl7tPXB5XgjmOV8L6uav9ja5oY433ktb2yhyQQIqBveZPkme        
\N      \N      \N      \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+20     2023-08-17      false   -5      18158   784479801       
1485484354598941738     -6632681928222776815    9708.431        
-3.30432620706069E8     \N      \N      2022-09-15T21:40:55     2023-02-23      
2023-08-13T21:31:54     O       X       
2pYmX2vAhfEEHZZYPsgAmda1G7otnwx5TmUC879FPhDeIjvWI79ksBZpfFG2gp7jhCSbpZiecKGklB5SvG8tm31i5SUqe1xrWgLt4HSq7lMJWp75tx2kxD7pRIOpn
   \N      \N      \N      \N      true    1       2       3       4       5    
   6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+21     2023-08-18      false   63      -27847  -35409596       
8638201997392767650     4919963231735304178     -23382.541      
-1.803403621426313E9    -22009767.0     \N      2023-03-31T10:56:14     
2023-01-20      2023-02-18T13:37:52     N       T       
PSiFwUEx3eVFNtjlnQ70YkgZNvKrGmQ2DN5K9yYHiSdFWeEDB1UpL3Frt8z1kEAIWRDWqXZuyi      
\N      \N      \N      \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+31     2023-08-27      false   17      -18849  1728109133      
3266501886640700374     527195452623418935      -24062.328      
-1.514348021262435E9    \N      \N      2022-10-07T03:24:23     2022-09-25      
\N      0       8       
yKMiAntORoRa8svnMfcxlOPwwND1m5s2fdS26Xu6cfs6HK5SAibqIp9h8sZcpjHy4       \N      
\N      \N      \N      true    1       2       3       4       5       6.0     
7.0     888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N      \N      \N      \N
+41     2023-08-27      true    -104    22750   \N      8527773271030840740     
5554497317268279215     -5296.828       -1.71564688801304E9     \N      \N      
2022-12-02T17:56:44     2022-10-12      2023-02-19T07:02:54     V               
E9GzQdTwX1ITUQz27IVznAs6Ca4WwprKk6Odjs6SH75D2F1089QiY3HQ52LXRD1V6xAWjhLE2hWgW3EdHuAOnUDVrb5V
    \N      \N      \N      \N      true    1       2       3       4       5   
    6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+49     2023-08-08      false   \N      16275   -2144851675     
-2303421957908954634    -46526938720058765      -13141.143      
-6.866322332302E8       \N      \N      2022-09-01T00:16:01     2023-03-25      
2022-09-07T14:59:03     s               yvuILR2iNxfe8RRml       \N      \N      
\N      \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N      \N      \N      \N
+50     2023-08-06      true    109     -6330   1479023892      
-8630800697573159428    -1645095773540208759    17880.96        
-1.453844792013949E9    \N      \N      2022-09-22T02:03:21     2023-05-14      
2023-03-25T02:18:34     m               
JKnIgXvGVidGiWl9YRSi3mFI7wHKt1sBpWSadKF8VX3LAuElm4sdc9gtxREaUr57oikSYlU8We8h1MWqQlYNiJObl
       \N      \N      \N      \N      true    1       2       3       4       
5       6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+50     2023-08-24      true    15      14403   \N      -6418906115745394180    
9205303779366462513     -4331.549       -6.15112179557648E8     \N      \N      
2022-12-29T02:27:20     2023-06-01      2023-08-12T04:50:04     a               
eCl38sztIvBQvGvGKyYZmyMXy9vIJx197iu3JwP9doJGcrYUl9Uova0rz4iCCgrjlAiZU18Fs9YtCq830nhM
    \N      \N      \N      \N      true    1       2       3       4       5   
    6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+57     2023-08-19      true    2       -25462  -74112029       
6458082754318544493     -7910671781690629051    -15205.859      
-3.06870797484914E8     \N      \N      2023-07-10T18:39:10     2023-02-12      
2023-01-27T07:26:06     y               Xi9nDVrLv8m6AwEpUxmtzFAuK48sQ   \N      
\N      \N      \N      true    1       2       3       4       5       6.0     
7.0     888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N      \N      \N      \N
+58     2023-08-22      \N      0       -18231  1832867360      
6997858407575297145     2480714305422728023     -5450.489       
1.475901032138386E9     \N      \N      2023-02-02T05:13:24     2022-09-18      
2023-04-23T10:51:15     k               
LdFXF7Kmfzgmnn2R6zLsXdmi3A2cLBLq4G4WDVNDhxvH7dYH8Kga2WA47uSIxp6NSrwPSdw0ssB1TS8RFJTDJAB0Uba3e05NL2Aiw0ja
        \N      \N      \N      \N      true    1       2       3       4       
5       6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+60     2023-08-27      false   -52     -2338   -757056972      
1047567408607120856     6541476642780646552     6614.0894       
-1.204448798517855E9    \N      \N      2022-12-29T14:47:30     2022-09-24      
2023-08-01T12:41:59     O       F       
RM4F1Ke7lkcnuxF2nK0j9VBW3MDcgyHR4pseBjtFnqS6GUkVFuzF6u3Cp9Nv7ab0O6UYrpP4DhU     
\N      \N      \N      \N      true    1       2       3       4       5       
6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+62     2023-08-21      false   81      20302   -200761532      
6365479976421007608     \N      -29916.533      1.709141750828478E9     \N      
\N      2023-05-04T01:14:51     2022-09-17      2022-12-04T19:30:09     d       
v       
BKWy9dTNg1aZW7ancEJAmEDOPK5TwFsNSHbI78emu9gymeIlx5NoLmyii0QAqdzRvSQPZKiqKkwInGCTIBnK1yYkK7zD
    \N      \N      \N      \N      true    1       2       3       4       5   
    6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+65     2023-08-09      false   94      31514   814994517       
-297697460695940343     734910652450318597      -13061.892      
6.2750847041706E7       -9808654.0      \N      2023-08-14T22:01:27     
2023-05-19      2022-11-13T13:44:28     V               
aGeMsI24O12chGlP5ak0AHghAz7bu5MargJBStHnt0yMnChH0JnfYhsfH1u59XIHkJKMsHYktBqORkGlovu8V47E74KeFpaqxn5yLyXfDbhhzUKf
        \N      \N      \N      \N      true    1       2       3       4       
5       6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+66     2023-08-15      true    -91     28378   609923317       
4872185586197131212     1207709464099378591     \N      -1.863683325985123E9    
\N      \N      2022-09-24T10:39:23     2022-09-24      2022-10-16T18:36:43     
Y       z       
AI1BSPQdKiHJiQH1kguyLSWsDXkC7zwy7PwgWnyGSaa9tBKRex8vHBdxg2QSKZKL2mV2lHz7iI1PnsTd4MXDcIKhqiHyPuQPt2tEtgt0UgF6
    \N      \N      \N      \N      true    1       2       3       4       5   
    6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+68     2023-08-23      true    -73     20117   1737338128      
795638676048937749      -5551546237562433901    -30627.04       
6.8589475684545E7       \N      \N      2022-12-28T20:26:51     2022-10-04      
2023-07-30T00:20:06     y               
keZ3JlWWpdnPBejf0cuiCQCVBBTd5gjvO08NVdcAFewqL7nRT4N9lnvSU6pWmletA5VbPQCeQapJdcnQCHfZUDCf4ulCnczyqr7SGrbGRT0XYcd7iktKM
   \N      \N      \N      \N      true    1       2       3       4       5    
   6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+80     2023-08-18      false   -18     -8971   679027874       
6535956962935330265     3960889045799757165     -13219.76       
1.187161924505394E9     \N      \N      2023-03-11T07:40        2022-11-29      
2023-01-14T07:24:07     N       D       
3Nhx6xX1qdwaq7lxwLRSKMtJFbC03swWv12mpySSVysH3igGZTiGPuKMsYW7HAkf6CWc7c0nzqDsjuH3FYVMNCWRmfxMrmY8rykQCC4Ve
       \N      \N      \N      \N      true    1       2       3       4       
5       6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+81     2023-08-23      false   106     11492   -667795397      
4480250461471356146     -5346660566234294101    9082.75 3.85167225902608E8      
\N      \N      2023-03-20T03:33:16     2022-11-24      2023-02-16T18:29:41     
G       9       Lk3eNVQNjucbekD1rZmUlGPiXS5JvcWr2LQzRU8GSGIbSag \N      \N      
\N      \N      true    1       2       3       4       5       6.0     7.0     
888888888       999999999       2023-08-24      2023-08-24T12:00        
2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     \N      \N      \N      \N
+85     2023-08-11      true    -7      24304   -2043877415     
-2024144417867729183    \N      5363.0244       -5.78615669042831E8     \N      
\N      2023-07-15T01:07:41     2023-08-13      2023-01-20T11:57:48     i       
        WQ9dh9ajPu0y    \N      \N      \N      \N      true    1       2       
3       4       5       6.0     7.0     888888888       999999999       
2023-08-24      2023-08-24T12:00        2023-08-24      2023-08-24T12:00        
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+90     2023-08-27      true    22      16456   -1476824962     
-3279894870153540825    8990195191470116763     26651.906       
2.06860148942546E8      \N      \N      2022-10-07T03:11:03     2023-03-18      
2023-04-15T00:38:33     T       L       
QW0GQ3GoMtHgxPQOWGfVaveynahNpsNs09siMFA1OtO6QEDBQTdivmGyq7bFzejAqwbbVQQpREAmeLjcFSXLnQuou2KbwYD
 \N      \N      \N      \N      true    1       2       3       4       5      
 6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+91     2023-08-27      true    90      2465    702240964       
6373830997821598984     305860046137409400      15991.356       
1.599972327386147E9     \N      \N      2023-04-26T19:31:10     2023-07-21      
\N      2               
B7YKYBYT8w0YC926bZ8Yz1VzyiWw2NWDAiTlEoPVyz9AXGti2Npg1FxWqWk4hEaALw0ZBSuiAIPj41lq36g5QRpPmAjNPK
  \N      \N      \N      \N      true    1       2       3       4       5     
  6.0     7.0     888888888       999999999       2023-08-24      
2023-08-24T12:00        2023-08-24      2023-08-24T12:00        我能吞下玻璃而不伤身体     
我能吞下玻璃而不伤身体     我能吞下玻璃而不伤身体     \N      \N      \N      \N
+
+-- !sql_json_read_json_by_line --
+2      [0, 0, 0, 0, 0, 0]      [117, 117, 117, 117, 117, 117]  [-4744, -4744, 
-4744, -4744, -4744, -4744]      [-1593211961, -1593211961, -1593211961, 
-1593211961, -1593211961, -1593211961]  [-3869640069299678780, 
-3869640069299678780, -3869640069299678780, -3869640069299678780, 
-3869640069299678780, -3869640069299678780]    [8491817458398170567, 
8491817458398170567, 8491817458398170567, 8491817458398170567, 
8491817458398170567, 8491817458398170567]  [-30948.857, -30948.857, -30948.857, 
-30948.857, -30948.85 [...]
+3      [0, 0, 0, 0, 0, 0]      [65, 65, 65, 65, 65, 65]        [-4963, -4963, 
-4963, -4963, -4963, -4963]      [-1415431954, -1415431954, -1415431954, 
-1415431954, -1415431954, -1415431954]  [-3804309860450207000, 
-3804309860450207000, -3804309860450207000, -3804309860450207000, 
-3804309860450207000, -3804309860450207000]    [8209240008557215376, 
8209240008557215376, 8209240008557215376, 8209240008557215376, 
8209240008557215376, 8209240008557215376]  [-5058.13, -5058.13, -5058.13, 
-5058.13, -5058.13]      [1034763010.6 [...]
+4      [0, 0, 0, 0, 0, 0]      [-67, -67, -67, -67, -67, -67]  [-30372, 
-30372, -30372, -30372, -30372, -30372]        [181502941, 181502941, 
181502941, 181502941, 181502941, 181502941]      [-2062236823576972800, 
-2062236823576972800, -2062236823576972800, -2062236823576972800, 
-2062236823576972800, -2062236823576972800]    [6357002962400127842, 
6357002962400127842, 6357002962400127842, 6357002962400127842, 
6357002962400127842, 6357002962400127842]  [21235.783, 21235.783, 21235.783, 
21235.783, 21235.783] [-110169 [...]
+4      [0, 0, 0, 0, 0, 0]      [63, 63, 63, 63, 63, 63]        [11399, 11399, 
11399, 11399, 11399, 11399]      [-583523026, -583523026, -583523026, 
-583523026, -583523026, -583523026]        [8801164674137231293, 
8801164674137231293, 8801164674137231293, 8801164674137231293, 
8801164674137231293, 8801164674137231293]  [-8287675635310193906, 
-8287675635310193906, -8287675635310193906, -8287675635310193906, 
-8287675635310193906, -8287675635310193906]    [23243.16, 23243.16, 23243.16, 
23243.16, 23243.16]      [716719993.249115,  [...]
+8      [1, 1, 1, 1, 1, 1]      [-11, -11, -11, -11, -11, -11]  [-9648, -9648, 
-9648, -9648, -9648, -9648]      [-505356927, -505356927, -505356927, 
-505356927, -505356927, -505356927]        [7604760670442035037, 
7604760670442035037, 7604760670442035037, 7604760670442035037, 
7604760670442035037, 7604760670442035037]  [1634770507625165798, 
1634770507625165798, 1634770507625165798, 1634770507625165798, 
1634770507625165798, 1634770507625165798]  [10822.962, 10822.962, 10822.962, 
10822.962, 10822.962] [1987551048.86 [...]
+16     [0, 0, 0, 0, 0, 0]      [-43, -43, -43, -43, -43, -43]  [13560, 13560, 
13560, 13560, 13560, 13560]      [-1743686513, -1743686513, -1743686513, 
-1743686513, -1743686513, -1743686513]  [7234719406392208769, 
7234719406392208769, 7234719406392208769, 7234719406392208769, 
7234719406392208769, 7234719406392208769]  [-3871745630024229413, 
-3871745630024229413, -3871745630024229413, -3871745630024229413, 
-3871745630024229413, -3871745630024229413]    [12225.427, 12225.427, 
12225.427, 12225.427, 12225.427] [ [...]
+16     [1, 1, 1, 1, 1, 1]      [-7, -7, -7, -7, -7, -7]        [18655, 18655, 
18655, 18655, 18655, 18655]      [6240356, 6240356, 6240356, 6240356, 6240356, 
6240356]  [4552179257266841393, 4552179257266841393, 4552179257266841393, 
4552179257266841393, 4552179257266841393, 4552179257266841393]  
[323868824766329978, 323868824766329978, 323868824766329978, 
323868824766329978, 323868824766329978, 323868824766329978]        [2972.2478, 
2972.2478, 2972.2478, 2972.2478, 2972.2478] [-1177167334.995008, 
-1177167334.995008, -1 [...]
+17     [1, 1, 1, 1, 1, 1]      [126, 126, 126, 126, 126, 126]  [28165, 28165, 
28165, 28165, 28165, 28165]      [2032059721, 2032059721, 2032059721, 
2032059721, 2032059721, 2032059721]        [-2686776977990574879, 
-2686776977990574879, -2686776977990574879, -2686776977990574879, 
-2686776977990574879, -2686776977990574879]    [-8498149444423102876, 
-8498149444423102876, -8498149444423102876, -8498149444423102876, 
-8498149444423102876, -8498149444423102876]    [-21681.223, -21681.223, 
-21681.223, -21681.223, -21681.2 [...]
+27     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [18307, 18307, 
18307, 18307, 18307, 18307]      [76399879, 76399879, 76399879, 76399879, 
76399879, 76399879]    [8050764818738996699, 8050764818738996699, 
8050764818738996699, 8050764818738996699, 8050764818738996699, 
8050764818738996699]  [2402219865213589999, 2402219865213589999, 
2402219865213589999, 2402219865213589999, 2402219865213589999, 
2402219865213589999]  [-16678.924, -16678.924, -16678.924, -16678.924, 
-16678.924]    [-2053879544.8447261, -205 [...]
+41     [0, 0, 0, 0, 0, 0]      [-25, -25, -25, -25, -25, -25]  [28704, 28704, 
28704, 28704, 28704, 28704]      [-437867812, -437867812, -437867812, 
-437867812, -437867812, -437867812]        [5508042206505207079, 
5508042206505207079, 5508042206505207079, 5508042206505207079, 
5508042206505207079, 5508042206505207079]  [462527544684407597, 
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597, 
462527544684407597]        [13629.614, 13629.614, 13629.614, 13629.614, 
13629.614] [213722401.337962,  [...]
+44     [0, 0, 0, 0, 0, 0]      [61, 61, 61, 61, 61, 61]        [-23419, 
-23419, -23419, -23419, -23419, -23419]        [378600280, 378600280, 
378600280, 378600280, 378600280, 378600280]      [6788166268039991679, 
6788166268039991679, 6788166268039991679, 6788166268039991679, 
6788166268039991679, 6788166268039991679]  [-2814786606977504852, 
-2814786606977504852, -2814786606977504852, -2814786606977504852, 
-2814786606977504852, -2814786606977504852]    [-20151.432, -20151.432, 
-20151.432, -20151.432, -20151.432]    [-124822 [...]
+48     [0, 0, 0, 0, 0, 0]      [88, 88, 88, 88, 88, 88]        [-18899, 
-18899, -18899, -18899, -18899, -18899]        [1953750640, 1953750640, 
1953750640, 1953750640, 1953750640, 1953750640]        [-6083034186246180312, 
-6083034186246180312, -6083034186246180312, -6083034186246180312, 
-6083034186246180312, -6083034186246180312]    [7861718260607212662, 
7861718260607212662, 7861718260607212662, 7861718260607212662, 
7861718260607212662, 7861718260607212662]  [20562.791, 20562.791, 20562.791, 
20562.791, 20562.791] [-15979 [...]
+49     [0, 0, 0, 0, 0, 0]      [126, 126, 126, 126, 126, 126]  [31661, 31661, 
31661, 31661, 31661, 31661]      [359703581, 359703581, 359703581, 359703581, 
359703581, 359703581]      [-2399575246807057939, -2399575246807057939, 
-2399575246807057939, -2399575246807057939, -2399575246807057939, 
-2399575246807057939]    [7684667782059034391, 7684667782059034391, 
7684667782059034391, 7684667782059034391, 7684667782059034391, 
7684667782059034391]  [-504.68152, -504.68152, -504.68152, -504.68152, 
-504.68152]    [2121528 [...]
+52     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [-6985, -6985, 
-6985, -6985, -6985, -6985]      [826683531, 826683531, 826683531, 826683531, 
826683531, 826683531]      [-8966681855246736361, -8966681855246736361, 
-8966681855246736361, -8966681855246736361, -8966681855246736361, 
-8966681855246736361]    [4814686163176635446, 4814686163176635446, 
4814686163176635446, 4814686163176635446, 4814686163176635446, 
4814686163176635446]  [-6490.2471, -6490.2471, -6490.2471, -6490.2471, 
-6490.2471]    [1076976372.03 [...]
+55     [1, 1, 1, 1, 1, 1]      [65, 65, 65, 65, 65, 65]        [18805, 18805, 
18805, 18805, 18805, 18805]      [229725878, 229725878, 229725878, 229725878, 
229725878, 229725878]      [2742856458318615325, 2742856458318615325, 
2742856458318615325, 2742856458318615325, 2742856458318615325, 
2742856458318615325]  [5907702768956232371, 5907702768956232371, 
5907702768956232371, 5907702768956232371, 5907702768956232371, 
5907702768956232371]  [12354.624, 12354.624, 12354.624, 12354.624, 12354.624] 
[1697579881.9474771, 1697 [...]
+61     [1, 1, 1, 1, 1, 1]      [121, 121, 121, 121, 121, 121]  [31806, 31806, 
31806, 31806, 31806, 31806]      [-1410915562, -1410915562, -1410915562, 
-1410915562, -1410915562, -1410915562]  [-250403393155768717, 
-250403393155768717, -250403393155768717, -250403393155768717, 
-250403393155768717, -250403393155768717]  [4301573778529723431, 
4301573778529723431, 4301573778529723431, 4301573778529723431, 
4301573778529723431, 4301573778529723431]  [10719.892, 10719.892, 10719.892, 
10719.892, 10719.892] [107378 [...]
+76     [1, 1, 1, 1, 1, 1]      [-63, -63, -63, -63, -63, -63]  [25799, 25799, 
25799, 25799, 25799, 25799]      [-1387912656, -1387912656, -1387912656, 
-1387912656, -1387912656, -1387912656]  [8967926767558546181, 
8967926767558546181, 8967926767558546181, 8967926767558546181, 
8967926767558546181, 8967926767558546181]  [-3537865898119184476, 
-3537865898119184476, -3537865898119184476, -3537865898119184476, 
-3537865898119184476, -3537865898119184476]    [5311.188, 5311.188, 5311.188, 
5311.188, 5311.188]      [17362 [...]
+84     [0, 0, 0, 0, 0, 0]      [-10, -10, -10, -10, -10, -10]  [9493, 9493, 
9493, 9493, 9493, 9493]    [-547874696, -547874696, -547874696, -547874696, 
-547874696, -547874696]        [-115057683458952756, -115057683458952756, 
-115057683458952756, -115057683458952756, -115057683458952756, 
-115057683458952756]  [4473017779279230085, 4473017779279230085, 
4473017779279230085, 4473017779279230085, 4473017779279230085, 
4473017779279230085]  [13718.372, 13718.372, 13718.372, 13718.372, 13718.372] 
[-978213266.02697,  [...]
+
+-- !sql_json_read_json_by_line --
+2      [0, 0, 0, 0, 0, 0]      [117, 117, 117, 117, 117, 117]  [-4744, -4744, 
-4744, -4744, -4744, -4744]      [-1593211961, -1593211961, -1593211961, 
-1593211961, -1593211961, -1593211961]  [-3869640069299678780, 
-3869640069299678780, -3869640069299678780, -3869640069299678780, 
-3869640069299678780, -3869640069299678780]    [8491817458398170567, 
8491817458398170567, 8491817458398170567, 8491817458398170567, 
8491817458398170567, 8491817458398170567]  [-30948.857, -30948.857, -30948.857, 
-30948.857, -30948.85 [...]
+3      [0, 0, 0, 0, 0, 0]      [65, 65, 65, 65, 65, 65]        [-4963, -4963, 
-4963, -4963, -4963, -4963]      [-1415431954, -1415431954, -1415431954, 
-1415431954, -1415431954, -1415431954]  [-3804309860450207000, 
-3804309860450207000, -3804309860450207000, -3804309860450207000, 
-3804309860450207000, -3804309860450207000]    [8209240008557215376, 
8209240008557215376, 8209240008557215376, 8209240008557215376, 
8209240008557215376, 8209240008557215376]  [-5058.13, -5058.13, -5058.13, 
-5058.13, -5058.13]      [1034763010.6 [...]
+4      [0, 0, 0, 0, 0, 0]      [-67, -67, -67, -67, -67, -67]  [-30372, 
-30372, -30372, -30372, -30372, -30372]        [181502941, 181502941, 
181502941, 181502941, 181502941, 181502941]      [-2062236823576972800, 
-2062236823576972800, -2062236823576972800, -2062236823576972800, 
-2062236823576972800, -2062236823576972800]    [6357002962400127842, 
6357002962400127842, 6357002962400127842, 6357002962400127842, 
6357002962400127842, 6357002962400127842]  [21235.783, 21235.783, 21235.783, 
21235.783, 21235.783] [-110169 [...]
+8      [1, 1, 1, 1, 1, 1]      [-11, -11, -11, -11, -11, -11]  [-9648, -9648, 
-9648, -9648, -9648, -9648]      [-505356927, -505356927, -505356927, 
-505356927, -505356927, -505356927]        [7604760670442035037, 
7604760670442035037, 7604760670442035037, 7604760670442035037, 
7604760670442035037, 7604760670442035037]  [1634770507625165798, 
1634770507625165798, 1634770507625165798, 1634770507625165798, 
1634770507625165798, 1634770507625165798]  [10822.962, 10822.962, 10822.962, 
10822.962, 10822.962] [1987551048.86 [...]
+16     [0, 0, 0, 0, 0, 0]      [-43, -43, -43, -43, -43, -43]  [13560, 13560, 
13560, 13560, 13560, 13560]      [-1743686513, -1743686513, -1743686513, 
-1743686513, -1743686513, -1743686513]  [7234719406392208769, 
7234719406392208769, 7234719406392208769, 7234719406392208769, 
7234719406392208769, 7234719406392208769]  [-3871745630024229413, 
-3871745630024229413, -3871745630024229413, -3871745630024229413, 
-3871745630024229413, -3871745630024229413]    [12225.427, 12225.427, 
12225.427, 12225.427, 12225.427] [ [...]
+17     [1, 1, 1, 1, 1, 1]      [126, 126, 126, 126, 126, 126]  [28165, 28165, 
28165, 28165, 28165, 28165]      [2032059721, 2032059721, 2032059721, 
2032059721, 2032059721, 2032059721]        [-2686776977990574879, 
-2686776977990574879, -2686776977990574879, -2686776977990574879, 
-2686776977990574879, -2686776977990574879]    [-8498149444423102876, 
-8498149444423102876, -8498149444423102876, -8498149444423102876, 
-8498149444423102876, -8498149444423102876]    [-21681.223, -21681.223, 
-21681.223, -21681.223, -21681.2 [...]
+27     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [18307, 18307, 
18307, 18307, 18307, 18307]      [76399879, 76399879, 76399879, 76399879, 
76399879, 76399879]    [8050764818738996699, 8050764818738996699, 
8050764818738996699, 8050764818738996699, 8050764818738996699, 
8050764818738996699]  [2402219865213589999, 2402219865213589999, 
2402219865213589999, 2402219865213589999, 2402219865213589999, 
2402219865213589999]  [-16678.924, -16678.924, -16678.924, -16678.924, 
-16678.924]    [-2053879544.8447261, -205 [...]
+41     [0, 0, 0, 0, 0, 0]      [-25, -25, -25, -25, -25, -25]  [28704, 28704, 
28704, 28704, 28704, 28704]      [-437867812, -437867812, -437867812, 
-437867812, -437867812, -437867812]        [5508042206505207079, 
5508042206505207079, 5508042206505207079, 5508042206505207079, 
5508042206505207079, 5508042206505207079]  [462527544684407597, 
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597, 
462527544684407597]        [13629.614, 13629.614, 13629.614, 13629.614, 
13629.614] [213722401.337962,  [...]
+44     [0, 0, 0, 0, 0, 0]      [61, 61, 61, 61, 61, 61]        [-23419, 
-23419, -23419, -23419, -23419, -23419]        [378600280, 378600280, 
378600280, 378600280, 378600280, 378600280]      [6788166268039991679, 
6788166268039991679, 6788166268039991679, 6788166268039991679, 
6788166268039991679, 6788166268039991679]  [-2814786606977504852, 
-2814786606977504852, -2814786606977504852, -2814786606977504852, 
-2814786606977504852, -2814786606977504852]    [-20151.432, -20151.432, 
-20151.432, -20151.432, -20151.432]    [-124822 [...]
+48     [0, 0, 0, 0, 0, 0]      [88, 88, 88, 88, 88, 88]        [-18899, 
-18899, -18899, -18899, -18899, -18899]        [1953750640, 1953750640, 
1953750640, 1953750640, 1953750640, 1953750640]        [-6083034186246180312, 
-6083034186246180312, -6083034186246180312, -6083034186246180312, 
-6083034186246180312, -6083034186246180312]    [7861718260607212662, 
7861718260607212662, 7861718260607212662, 7861718260607212662, 
7861718260607212662, 7861718260607212662]  [20562.791, 20562.791, 20562.791, 
20562.791, 20562.791] [-15979 [...]
+49     [0, 0, 0, 0, 0, 0]      [126, 126, 126, 126, 126, 126]  [31661, 31661, 
31661, 31661, 31661, 31661]      [359703581, 359703581, 359703581, 359703581, 
359703581, 359703581]      [-2399575246807057939, -2399575246807057939, 
-2399575246807057939, -2399575246807057939, -2399575246807057939, 
-2399575246807057939]    [7684667782059034391, 7684667782059034391, 
7684667782059034391, 7684667782059034391, 7684667782059034391, 
7684667782059034391]  [-504.68152, -504.68152, -504.68152, -504.68152, 
-504.68152]    [2121528 [...]
+52     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [-6985, -6985, 
-6985, -6985, -6985, -6985]      [826683531, 826683531, 826683531, 826683531, 
826683531, 826683531]      [-8966681855246736361, -8966681855246736361, 
-8966681855246736361, -8966681855246736361, -8966681855246736361, 
-8966681855246736361]    [4814686163176635446, 4814686163176635446, 
4814686163176635446, 4814686163176635446, 4814686163176635446, 
4814686163176635446]  [-6490.2471, -6490.2471, -6490.2471, -6490.2471, 
-6490.2471]    [1076976372.03 [...]
+55     [1, 1, 1, 1, 1, 1]      [65, 65, 65, 65, 65, 65]        [18805, 18805, 
18805, 18805, 18805, 18805]      [229725878, 229725878, 229725878, 229725878, 
229725878, 229725878]      [2742856458318615325, 2742856458318615325, 
2742856458318615325, 2742856458318615325, 2742856458318615325, 
2742856458318615325]  [5907702768956232371, 5907702768956232371, 
5907702768956232371, 5907702768956232371, 5907702768956232371, 
5907702768956232371]  [12354.624, 12354.624, 12354.624, 12354.624, 12354.624] 
[1697579881.9474771, 1697 [...]
+61     [1, 1, 1, 1, 1, 1]      [121, 121, 121, 121, 121, 121]  [31806, 31806, 
31806, 31806, 31806, 31806]      [-1410915562, -1410915562, -1410915562, 
-1410915562, -1410915562, -1410915562]  [-250403393155768717, 
-250403393155768717, -250403393155768717, -250403393155768717, 
-250403393155768717, -250403393155768717]  [4301573778529723431, 
4301573778529723431, 4301573778529723431, 4301573778529723431, 
4301573778529723431, 4301573778529723431]  [10719.892, 10719.892, 10719.892, 
10719.892, 10719.892] [107378 [...]
+76     [1, 1, 1, 1, 1, 1]      [-63, -63, -63, -63, -63, -63]  [25799, 25799, 
25799, 25799, 25799, 25799]      [-1387912656, -1387912656, -1387912656, 
-1387912656, -1387912656, -1387912656]  [8967926767558546181, 
8967926767558546181, 8967926767558546181, 8967926767558546181, 
8967926767558546181, 8967926767558546181]  [-3537865898119184476, 
-3537865898119184476, -3537865898119184476, -3537865898119184476, 
-3537865898119184476, -3537865898119184476]    [5311.188, 5311.188, 5311.188, 
5311.188, 5311.188]      [17362 [...]
+84     [0, 0, 0, 0, 0, 0]      [-10, -10, -10, -10, -10, -10]  [9493, 9493, 
9493, 9493, 9493, 9493]    [-547874696, -547874696, -547874696, -547874696, 
-547874696, -547874696]        [-115057683458952756, -115057683458952756, 
-115057683458952756, -115057683458952756, -115057683458952756, 
-115057683458952756]  [4473017779279230085, 4473017779279230085, 
4473017779279230085, 4473017779279230085, 4473017779279230085, 
4473017779279230085]  [13718.372, 13718.372, 13718.372, 13718.372, 13718.372] 
[-978213266.02697,  [...]
+
+-- !sql_json_read_json_by_line --
+2      [0, 0, 0, 0, 0, 0]      [117, 117, 117, 117, 117, 117]  [-4744, -4744, 
-4744, -4744, -4744, -4744]      [-1593211961, -1593211961, -1593211961, 
-1593211961, -1593211961, -1593211961]  [-3869640069299678780, 
-3869640069299678780, -3869640069299678780, -3869640069299678780, 
-3869640069299678780, -3869640069299678780]    [8491817458398170567, 
8491817458398170567, 8491817458398170567, 8491817458398170567, 
8491817458398170567, 8491817458398170567]  [-30948.857, -30948.857, -30948.857, 
-30948.857, -30948.85 [...]
+3      [0, 0, 0, 0, 0, 0]      [65, 65, 65, 65, 65, 65]        [-4963, -4963, 
-4963, -4963, -4963, -4963]      [-1415431954, -1415431954, -1415431954, 
-1415431954, -1415431954, -1415431954]  [-3804309860450207000, 
-3804309860450207000, -3804309860450207000, -3804309860450207000, 
-3804309860450207000, -3804309860450207000]    [8209240008557215376, 
8209240008557215376, 8209240008557215376, 8209240008557215376, 
8209240008557215376, 8209240008557215376]  [-5058.13, -5058.13, -5058.13, 
-5058.13, -5058.13]      [1034763010.6 [...]
+4      [0, 0, 0, 0, 0, 0]      [-67, -67, -67, -67, -67, -67]  [-30372, 
-30372, -30372, -30372, -30372, -30372]        [181502941, 181502941, 
181502941, 181502941, 181502941, 181502941]      [-2062236823576972800, 
-2062236823576972800, -2062236823576972800, -2062236823576972800, 
-2062236823576972800, -2062236823576972800]    [6357002962400127842, 
6357002962400127842, 6357002962400127842, 6357002962400127842, 
6357002962400127842, 6357002962400127842]  [21235.783, 21235.783, 21235.783, 
21235.783, 21235.783] [-110169 [...]
+8      [1, 1, 1, 1, 1, 1]      [-11, -11, -11, -11, -11, -11]  [-9648, -9648, 
-9648, -9648, -9648, -9648]      [-505356927, -505356927, -505356927, 
-505356927, -505356927, -505356927]        [7604760670442035037, 
7604760670442035037, 7604760670442035037, 7604760670442035037, 
7604760670442035037, 7604760670442035037]  [1634770507625165798, 
1634770507625165798, 1634770507625165798, 1634770507625165798, 
1634770507625165798, 1634770507625165798]  [10822.962, 10822.962, 10822.962, 
10822.962, 10822.962] [1987551048.86 [...]
+16     [0, 0, 0, 0, 0, 0]      [-43, -43, -43, -43, -43, -43]  [13560, 13560, 
13560, 13560, 13560, 13560]      [-1743686513, -1743686513, -1743686513, 
-1743686513, -1743686513, -1743686513]  [7234719406392208769, 
7234719406392208769, 7234719406392208769, 7234719406392208769, 
7234719406392208769, 7234719406392208769]  [-3871745630024229413, 
-3871745630024229413, -3871745630024229413, -3871745630024229413, 
-3871745630024229413, -3871745630024229413]    [12225.427, 12225.427, 
12225.427, 12225.427, 12225.427] [ [...]
+17     [1, 1, 1, 1, 1, 1]      [126, 126, 126, 126, 126, 126]  [28165, 28165, 
28165, 28165, 28165, 28165]      [2032059721, 2032059721, 2032059721, 
2032059721, 2032059721, 2032059721]        [-2686776977990574879, 
-2686776977990574879, -2686776977990574879, -2686776977990574879, 
-2686776977990574879, -2686776977990574879]    [-8498149444423102876, 
-8498149444423102876, -8498149444423102876, -8498149444423102876, 
-8498149444423102876, -8498149444423102876]    [-21681.223, -21681.223, 
-21681.223, -21681.223, -21681.2 [...]
+27     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [18307, 18307, 
18307, 18307, 18307, 18307]      [76399879, 76399879, 76399879, 76399879, 
76399879, 76399879]    [8050764818738996699, 8050764818738996699, 
8050764818738996699, 8050764818738996699, 8050764818738996699, 
8050764818738996699]  [2402219865213589999, 2402219865213589999, 
2402219865213589999, 2402219865213589999, 2402219865213589999, 
2402219865213589999]  [-16678.924, -16678.924, -16678.924, -16678.924, 
-16678.924]    [-2053879544.8447261, -205 [...]
+41     [0, 0, 0, 0, 0, 0]      [-25, -25, -25, -25, -25, -25]  [28704, 28704, 
28704, 28704, 28704, 28704]      [-437867812, -437867812, -437867812, 
-437867812, -437867812, -437867812]        [5508042206505207079, 
5508042206505207079, 5508042206505207079, 5508042206505207079, 
5508042206505207079, 5508042206505207079]  [462527544684407597, 
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597, 
462527544684407597]        [13629.614, 13629.614, 13629.614, 13629.614, 
13629.614] [213722401.337962,  [...]
+44     [0, 0, 0, 0, 0, 0]      [61, 61, 61, 61, 61, 61]        [-23419, 
-23419, -23419, -23419, -23419, -23419]        [378600280, 378600280, 
378600280, 378600280, 378600280, 378600280]      [6788166268039991679, 
6788166268039991679, 6788166268039991679, 6788166268039991679, 
6788166268039991679, 6788166268039991679]  [-2814786606977504852, 
-2814786606977504852, -2814786606977504852, -2814786606977504852, 
-2814786606977504852, -2814786606977504852]    [-20151.432, -20151.432, 
-20151.432, -20151.432, -20151.432]    [-124822 [...]
+48     [0, 0, 0, 0, 0, 0]      [88, 88, 88, 88, 88, 88]        [-18899, 
-18899, -18899, -18899, -18899, -18899]        [1953750640, 1953750640, 
1953750640, 1953750640, 1953750640, 1953750640]        [-6083034186246180312, 
-6083034186246180312, -6083034186246180312, -6083034186246180312, 
-6083034186246180312, -6083034186246180312]    [7861718260607212662, 
7861718260607212662, 7861718260607212662, 7861718260607212662, 
7861718260607212662, 7861718260607212662]  [20562.791, 20562.791, 20562.791, 
20562.791, 20562.791] [-15979 [...]
+49     [0, 0, 0, 0, 0, 0]      [126, 126, 126, 126, 126, 126]  [31661, 31661, 
31661, 31661, 31661, 31661]      [359703581, 359703581, 359703581, 359703581, 
359703581, 359703581]      [-2399575246807057939, -2399575246807057939, 
-2399575246807057939, -2399575246807057939, -2399575246807057939, 
-2399575246807057939]    [7684667782059034391, 7684667782059034391, 
7684667782059034391, 7684667782059034391, 7684667782059034391, 
7684667782059034391]  [-504.68152, -504.68152, -504.68152, -504.68152, 
-504.68152]    [2121528 [...]
+52     [0, 0, 0, 0, 0, 0]      [-7, -7, -7, -7, -7, -7]        [-6985, -6985, 
-6985, -6985, -6985, -6985]      [826683531, 826683531, 826683531, 826683531, 
826683531, 826683531]      [-8966681855246736361, -8966681855246736361, 
-8966681855246736361, -8966681855246736361, -8966681855246736361, 
-8966681855246736361]    [4814686163176635446, 4814686163176635446, 
4814686163176635446, 4814686163176635446, 4814686163176635446, 
4814686163176635446]  [-6490.2471, -6490.2471, -6490.2471, -6490.2471, 
-6490.2471]    [1076976372.03 [...]
+55     [1, 1, 1, 1, 1, 1]      [65, 65, 65, 65, 65, 65]        [18805, 18805, 
18805, 18805, 18805, 18805]      [229725878, 229725878, 229725878, 229725878, 
229725878, 229725878]      [2742856458318615325, 2742856458318615325, 
2742856458318615325, 2742856458318615325, 2742856458318615325, 
2742856458318615325]  [5907702768956232371, 5907702768956232371, 
5907702768956232371, 5907702768956232371, 5907702768956232371, 
5907702768956232371]  [12354.624, 12354.624, 12354.624, 12354.624, 12354.624] 
[1697579881.9474771, 1697 [...]
+61     [1, 1, 1, 1, 1, 1]      [121, 121, 121, 121, 121, 121]  [31806, 31806, 
31806, 31806, 31806, 31806]      [-1410915562, -1410915562, -1410915562, 
-1410915562, -1410915562, -1410915562]  [-250403393155768717, 
-250403393155768717, -250403393155768717, -250403393155768717, 
-250403393155768717, -250403393155768717]  [4301573778529723431, 
4301573778529723431, 4301573778529723431, 4301573778529723431, 
4301573778529723431, 4301573778529723431]  [10719.892, 10719.892, 10719.892, 
10719.892, 10719.892] [107378 [...]
+76     [1, 1, 1, 1, 1, 1]      [-63, -63, -63, -63, -63, -63]  [25799, 25799, 
25799, 25799, 25799, 25799]      [-1387912656, -1387912656, -1387912656, 
-1387912656, -1387912656, -1387912656]  [8967926767558546181, 
8967926767558546181, 8967926767558546181, 8967926767558546181, 
8967926767558546181, 8967926767558546181]  [-3537865898119184476, 
-3537865898119184476, -3537865898119184476, -3537865898119184476, 
-3537865898119184476, -3537865898119184476]    [5311.188, 5311.188, 5311.188, 
5311.188, 5311.188]      [17362 [...]
+84     [0, 0, 0, 0, 0, 0]      [-10, -10, -10, -10, -10, -10]  [9493, 9493, 
9493, 9493, 9493, 9493]    [-547874696, -547874696, -547874696, -547874696, 
-547874696, -547874696]        [-115057683458952756, -115057683458952756, 
-115057683458952756, -115057683458952756, -115057683458952756, 
-115057683458952756]  [4473017779279230085, 4473017779279230085, 
4473017779279230085, 4473017779279230085, 4473017779279230085, 
4473017779279230085]  [13718.372, 13718.372, 13718.372, 13718.372, 13718.372] 
[-978213266.02697,  [...]
+
diff --git a/regression-test/suites/load_p0/stream_load/test_stream_load.groovy 
b/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
index 90264e6aa74..c69449b4dac 100644
--- a/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
+++ b/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
@@ -1124,8 +1124,8 @@ suite("test_stream_load", "p0") {
 
     sql "sync"
     def res = sql "select * from ${tableName14}"
-    def time = res[0][5].toString().split("T")[0].split("-")
-    def year = time[0].toString()
+    def ts = res[0][5].toString().split("T")[0].split("-")
+    def year = ts[0].toString()
     SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd")
     def now = sdf.format(new Date()).toString().split("-")
 
diff --git 
a/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy 
b/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
index 13cd50064de..385b6a151d9 100644
--- 
a/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
+++ 
b/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
@@ -977,4 +977,67 @@ suite("test_stream_load_properties", "p0") {
             sql new 
File("""${context.file.parent}/ddl/${tableName}_drop.sql""").text
         }
     }
+    
+    // test read_json_by_line with enable_simdjson_read=false (default)
+    def backendId_to_backendIP = [:]
+    def backendId_to_backendHttpPort = [:]
+    getBackendIpHttpPort(backendId_to_backendIP, backendId_to_backendHttpPort);
+    def set_be_param = { paramName, paramValue ->
+        // for eache be node, set paramName=paramValue
+        for (String id in backendId_to_backendIP.keySet()) {
+            def beIp = backendId_to_backendIP.get(id)
+            def bePort = backendId_to_backendHttpPort.get(id)
+            def (code, out, err) = curl("POST", 
String.format("http://%s:%s/api/update_config?%s=%s";, beIp, bePort, paramName, 
paramValue))
+            assertTrue(out.contains("OK"))
+        }
+    }
+
+    i = 0
+    try {
+        set_be_param.call("enable_simdjson_reader", "false")
+
+        for (String tableName in tables) {
+            sql new 
File("""${context.file.parent}/ddl/${tableName}_drop.sql""").text
+            sql new 
File("""${context.file.parent}/ddl/${tableName}_create.sql""").text
+
+            streamLoad {
+                table "stream_load_" + tableName
+                set 'format', 'json'
+                set 'columns', columns[i]
+                set 'read_json_by_line', 'true'
+                if (i <= 3) {
+                    file json_by_line_files[0]
+                } else {
+                    file json_by_line_files[1]
+                }
+                time 10000 // limit inflight 10s
+
+                check { result, exception, startTime, endTime ->
+                    if (exception != null) {
+                        throw exception
+                    }
+                    log.info("Stream load result: ${result}".toString())
+                    def json = parseJson(result)
+                    assertEquals("success", json.Status.toLowerCase())
+                    assertEquals(jsonLoadedRows[i], json.NumberTotalRows)
+                    assertEquals(jsonLoadedRows[i], json.NumberLoadedRows)
+                    assertEquals(0, json.NumberFilteredRows)
+                    assertEquals(0, json.NumberUnselectedRows)
+                }
+            }
+            def tableName1 =  "stream_load_" + tableName
+            if (i <= 3) {
+                qt_sql_json_read_by_line "select * from ${tableName1} order by 
k00,k01"
+            } else {
+                qt_sql_json_read_json_by_line "select * from ${tableName1} 
order by k00"
+            }
+            i++
+        }
+    } finally {
+        set_be_param.call("enable_simdjson_reader", "true")
+
+        for (String tableName in tables) {
+            sql new 
File("""${context.file.parent}/ddl/${tableName}_drop.sql""").text
+        }
+    }
 }


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to