flarco
commented
7 months ago Thanks, can you run in Debug mode and share the log? with -d.
Closed alberttwong closed 7 months ago
flarco
commented
7 months ago Thanks, can you run in Debug mode and share the log? with -d.
alberttwong
commented
7 months ago atwong@Albert-CelerData test_db % sling run --src-conn MYSQLLOCAL --src-stream employees.employees --tgt-conn STARROCKSLOCAL --tgt-object albert.employees --primary-key emp_no -d
2024-02-07 17:06:47 DBG Sling version: 1.1.2 (darwin arm64)
2024-02-07 17:06:47 DBG type is db-db
2024-02-07 17:06:47 DBG using source options: {"empty_as_null":true,"null_if":"NULL","datetime_format":"AUTO","max_decimals":-1,"transforms":["parse_bit"]}
2024-02-07 17:06:47 DBG using target options: {"datetime_format":"auto","max_decimals":-1,"use_bulk":true,"add_new_columns":true,"column_casing":"source"}
2024-02-07 17:06:47 INF connecting to source database (mysql)
2024-02-07 17:06:47 INF connecting to target database (starrocks)
2024-02-07 17:06:47 INF reading from source database
2024-02-07 17:06:47 DBG select * from `employees`.`employees`
2024-02-07 17:06:47 INF writing to target database [mode: full-refresh]
2024-02-07 17:06:47 DBG drop table if exists `albert`.`employees_tmp`
2024-02-07 17:06:47 DBG table `albert`.`employees_tmp` dropped
2024-02-07 17:06:47 DBG create table if not exists `albert`.`employees_tmp` (`emp_no` integer,
`birth_date` datetime,
`first_name` string,
`last_name` string,
`gender` varchar(255),
`hire_date` datetime) duplicate key(`emp_no`) distributed by hash(`emp_no`)
2024-02-07 17:06:47 INF streaming data
2024-02-07 17:06:47 DBG WARN: Using INSERT mode which is meant for small datasets. Please set the `fe_url` for loading large datasets via Stream Load mode. See https://docs.slingdata.io/connections/database-connections/starrocks
3m17s 299,367 1524 r/s | 0 B/s | 63% MEM | 28% CPU
2024-02-07 17:10:05 DBG select count(*) cnt from `albert`.`employees_tmp`
2024-02-07 17:10:05 DBG connection was closed, reconnecting
2024-02-07 17:10:05 DBG drop table if exists `albert`.`employees_tmp`
2024-02-07 17:10:05 DBG table `albert`.`employees_tmp` dropped
2024-02-07 17:10:05 INF execution failed
FYI there is a new sling version released (1.1.3). Please run `brew upgrade slingdata-io/sling/sling`.
fatal:
--- task_run.go:87 func1 ---
~ execution failed
--- task_run.go:501 runDbToDb ---
~ Could not WriteToDb
--- task_run_write.go:269 WriteToDb ---
inserted in temp table but table count (324) != stream count (300024). Records missing. Abortingahh... I think it takes time for the data to be ingested since StarRocks is a columnar database.
flarco
commented
7 months ago Ah OK, so after a while, the table count is 300024?
alberttwong
commented
7 months ago I think so... but it dropped the tmp table so I can't verify.
alberttwong
commented
7 months ago So what is the plan? Not verify or somehow wait? Ideally, I'd love it that it wouldn't drop the tmp table so I can validate that count is correct.
Another potential problem. Depending on the sql, duplicates are removed. https://docs.starrocks.io/docs/sql-reference/sql-functions/aggregate-functions/count/
flarco
commented
7 months ago Yea, I need to reproduce this behavior on my machine and I will investigate more. If it is eventual consistency, then yea, some looping + delay + time-out to check the COUNTs could work.
flarco
commented
7 months ago @alberttwong Actually...if you want, you could just comment out this block of code: https://github.com/slingdata-io/sling-cli/blob/main/core/sling/task_run_write.go#L179-L185
And build the binary, and test. It won't drop the temp table.
alberttwong
commented
7 months ago it seems like it's inserting the same number of records but overwriting the contents of the table
StarRocks > select * from employees_tmp;
+--------+---------------------+---------------+----------------+--------+---------------------+
| emp_no | birth_date | first_name | last_name | gender | hire_date |
+--------+---------------------+---------------+----------------+--------+---------------------+
| 400778 | 1956-07-02 00:00:00 | Mototsugu | Verhaegen | M | 1987-05-03 00:00:00 |
| 400779 | 1953-11-05 00:00:00 | Danae | Biran | M | 1986-02-21 00:00:00 |
| 400780 | 1965-01-09 00:00:00 | Poornachandra | Asser | M | 1985-07-08 00:00:00 |
| 400783 | 1957-03-02 00:00:00 | Satoru | Senzako | M | 1993-11-15 00:00:00 |
| 400784 | 1961-05-14 00:00:00 | Aloke | Schmezko | M | 1989-04-04 00:00:00 |
| 400786 | 1956-09-02 00:00:00 | Demos | Babu | M | 1993-12-03 00:00:00 |
| 400789 | 1955-09-12 00:00:00 | Henk | Griswold | F | 1986-12-15 00:00:00 |
| 400791 | 1961-04-03 00:00:00 | Leon | Francisci | F | 1993-01-14 00:00:00 |
| 400792 | 1956-09-22 00:00:00 | Toshimitsu | DuCasse | F | 1991-05-25 00:00:00 |
| 400794 | 1956-01-22 00:00:00 | Greger | Bugrara | M | 1990-05-22 00:00:00 |
| 400796 | 1965-01-10 00:00:00 | Bodo | Halevi | F | 1993-11-20 00:00:00 |
| 400797 | 1961-02-07 00:00:00 | Kristine | Bauknecht | M | 1997-10-09 00:00:00 |
| 400798 | 1956-08-06 00:00:00 | Qunsheng | Bierbaum | M | 1985-09-23 00:00:00 |
| 400799 | 1957-09-20 00:00:00 | Valter | Levergood | M | 1989-03-01 00:00:00 |
| 400802 | 1959-11-09 00:00:00 | Stein | Erbe | F | 1988-10-26 00:00:00 |
| 400803 | 1960-05-26 00:00:00 | Breannda | Bratten | F | 1986-04-25 00:00:00 |
| 400804 | 1960-01-14 00:00:00 | Pohua | Senzako | M | 1988-11-11 00:00:00 |
| 400808 | 1953-09-10 00:00:00 | Nathalie | Schiper | F | 1986-11-25 00:00:00 |
| 400809 | 1952-12-14 00:00:00 | Hisao | Fujisawa | M | 1985-02-23 00:00:00 |
| 400813 | 1959-06-19 00:00:00 | Sanjiv | Yoshimura | F | 1987-11-28 00:00:00 |
| 400815 | 1959-06-20 00:00:00 | Remzi | Huxford | F | 1988-11-06 00:00:00 |
| 400816 | 1962-08-05 00:00:00 | Zijian | Pargas | M | 1995-09-14 00:00:00 |
| 400817 | 1962-12-08 00:00:00 | Hatsukazu | Fiutem | F | 1991-12-03 00:00:00 |
| 400818 | 1960-05-14 00:00:00 | JoAnna | Homond | M | 1992-11-13 00:00:00 |
| 400819 | 1958-12-29 00:00:00 | Wojceich | Plesums | M | 1992-04-14 00:00:00 |
| 400823 | 1953-05-16 00:00:00 | Hideyuki | Imataki | F | 1991-06-26 00:00:00 |
| 400825 | 1953-07-22 00:00:00 | Tadahiko | Beilner | F | 1989-03-07 00:00:00 |
| 400827 | 1956-08-09 00:00:00 | Dhritiman | Ullian | M | 1990-08-06 00:00:00 |
| 400829 | 1954-12-13 00:00:00 | Sachem | Chorvat | F | 1989-01-04 00:00:00 |
| 400830 | 1954-05-09 00:00:00 | Sumant | Suomi | F | 1986-06-24 00:00:00 |
| 400834 | 1963-07-21 00:00:00 | Stepehn | Shimshoni | M | 1985-06-14 00:00:00 |
| 400835 | 1957-02-17 00:00:00 | Fabrizio | Plumb | F | 1987-02-17 00:00:00 |
| 400836 | 1961-09-04 00:00:00 | Sadok | Godskesen | F | 1988-10-03 00:00:00 |
| 400837 | 1964-08-16 00:00:00 | Cedric | DuCasse | M | 1990-03-09 00:00:00 |
| 400839 | 1952-06-27 00:00:00 | Mahendra | Trumbly | M | 1993-05-27 00:00:00 |
| 400840 | 1963-12-12 00:00:00 | Jamaludin | Foote | M | 1985-08-29 00:00:00 |
| 400843 | 1961-09-26 00:00:00 | Frederique | Schade | M | 1988-03-12 00:00:00 |
| 400849 | 1961-06-23 00:00:00 | Torsten | Aingworth | F | 1987-08-19 00:00:00 |
| 400850 | 1961-07-27 00:00:00 | Shaleah | Dolinsky | F | 1990-10-27 00:00:00 |
| 400851 | 1964-05-28 00:00:00 | Yongdong | Passino | F | 1988-11-19 00:00:00 |
| 400852 | 1957-01-31 00:00:00 | Takushi | Dehkordi | M | 1985-05-10 00:00:00 |
| 400856 | 1962-06-05 00:00:00 | Taegyun | Cooke | M | 1995-06-13 00:00:00 |
| 400857 | 1959-04-14 00:00:00 | Sudharsan | Scallan | M | 1990-01-07 00:00:00 |
| 400862 | 1963-12-02 00:00:00 | Adas | Kopetz | M | 1993-11-07 00:00:00 |
| 400865 | 1962-10-16 00:00:00 | Hitomi | Sifakis | F | 1988-12-25 00:00:00 |
| 400867 | 1956-03-16 00:00:00 | Abdulah | Swick | F | 1990-08-18 00:00:00 |
| 400868 | 1953-07-21 00:00:00 | Eishiro | Trumbly | M | 1989-01-16 00:00:00 |
| 400869 | 1961-09-22 00:00:00 | Kwangsub | Huxford | M | 1989-12-18 00:00:00 |
| 400871 | 1961-07-24 00:00:00 | Uma | Beidas | F | 1994-04-06 00:00:00 |
| 400872 | 1954-08-14 00:00:00 | Oguz | Lueh | M | 1987-04-06 00:00:00 |
| 400881 | 1953-01-16 00:00:00 | Suebskul | Baby | M | 1987-03-04 00:00:00 |
| 400886 | 1957-10-30 00:00:00 | Leszek | Rodham | F | 1992-08-28 00:00:00 |
| 400888 | 1959-05-31 00:00:00 | Gurbir | Rabehasaina | M | 1989-10-26 00:00:00 |
| 400890 | 1961-06-03 00:00:00 | Xuejia | Feldhoffer | F | 1991-05-10 00:00:00 |
| 400891 | 1955-12-04 00:00:00 | Gil | Vitiello | M | 1990-08-11 00:00:00 |
| 400892 | 1962-09-01 00:00:00 | Lech | Mawatari | M | 1985-08-10 00:00:00 |
| 400894 | 1964-03-03 00:00:00 | Sreenivas | Junet | F | 1988-06-02 00:00:00 |
| 400896 | 1962-10-07 00:00:00 | Kellie | Garrabrants | F | 1992-12-04 00:00:00 |
| 400897 | 1959-04-26 00:00:00 | George | Khalil | M | 1985-09-14 00:00:00 |
| 400898 | 1956-05-01 00:00:00 | Naftali | Vigier | M | 1985-09-17 00:00:00 |
| 400899 | 1959-01-23 00:00:00 | Jayson | Shinomoto | F | 1990-12-29 00:00:00 |
| 400904 | 1957-06-08 00:00:00 | Rosalyn | Dolinsky | M | 1998-11-02 00:00:00 |
| 400905 | 1953-12-24 00:00:00 | Kwee | Pulkowski | M | 1994-01-21 00:00:00 |
| 400906 | 1961-02-20 00:00:00 | Kasturi | Waterhouse | M | 1985-02-16 00:00:00 |
| 400907 | 1960-05-14 00:00:00 | Satyanarayana | Lamparter | F | 1988-01-12 00:00:00 |
| 400908 | 1952-05-28 00:00:00 | Eckart | Koprowski | M | 1986-08-13 00:00:00 |
| 400909 | 1958-07-27 00:00:00 | Berthier | Haraldson | F | 1986-03-02 00:00:00 |
| 400910 | 1957-10-29 00:00:00 | Jianhui | Majewski | M | 1990-11-23 00:00:00 |
| 400912 | 1962-03-06 00:00:00 | Chriss | Sidou | M | 1986-04-19 00:00:00 |
| 400916 | 1956-02-09 00:00:00 | Elzbieta | Chvatal | M | 1985-08-24 00:00:00 |
| 400918 | 1964-04-03 00:00:00 | Adhemar | Leivant | F | 1985-12-04 00:00:00 |
| 400920 | 1955-05-29 00:00:00 | Mary | Braunschweig | M | 1994-10-27 00:00:00 |
| 400923 | 1961-09-11 00:00:00 | Jiang | Ellozy | M | 1994-01-04 00:00:00 |
| 400925 | 1955-08-01 00:00:00 | Doowon | Comyn | M | 1991-07-29 00:00:00 |
| 400926 | 1956-03-15 00:00:00 | Arco | Denis | M | 1988-01-09 00:00:00 |
| 400929 | 1957-04-06 00:00:00 | LiMin | Cyre | F | 1993-01-24 00:00:00 |
| 400930 | 1955-07-24 00:00:00 | Gaetan | Ramalingam | F | 1991-09-30 00:00:00 |
| 400931 | 1963-03-28 00:00:00 | Martins | Pramanik | M | 1989-07-26 00:00:00 |
| 400933 | 1955-10-13 00:00:00 | Nikolaos | Vesna | F | 1987-06-29 00:00:00 |
| 400935 | 1956-12-24 00:00:00 | Weidon | Chepyzhov | F | 1992-10-31 00:00:00 |
| 400936 | 1964-05-27 00:00:00 | Brewster | Matzov | F | 1985-08-02 00:00:00 |
| 400937 | 1962-08-01 00:00:00 | Rutger | Sidje | M | 1987-08-03 00:00:00 |
| 400940 | 1955-01-27 00:00:00 | Kwangjo | Katzenelson | M | 1994-12-20 00:00:00 |
| 400942 | 1959-10-09 00:00:00 | Venkatesan | Ashish | M | 1990-08-05 00:00:00 |
| 400944 | 1960-06-12 00:00:00 | Dzung | Dechter | M | 1989-01-10 00:00:00 |
| 400946 | 1963-12-01 00:00:00 | Danco | Emden | M | 1988-03-01 00:00:00 |
| 400948 | 1963-10-25 00:00:00 | Tuval | Zultner | F | 1988-11-27 00:00:00 |
| 400949 | 1961-09-27 00:00:00 | Remko | Narwekar | M | 1987-04-11 00:00:00 |
| 400950 | 1952-11-08 00:00:00 | Otmar | Erie | F | 1988-09-17 00:00:00 |
| 400954 | 1956-03-17 00:00:00 | Kolar | Kilgore | F | 1988-09-25 00:00:00 |
| 400955 | 1961-05-06 00:00:00 | Masoud | Kitsuregawa | M | 1987-09-02 00:00:00 |
| 400956 | 1959-02-19 00:00:00 | Kinh | Streit | M | 1985-05-25 00:00:00 |
| 400957 | 1955-09-29 00:00:00 | Yakkov | Worfolk | M | 1986-09-21 00:00:00 |
| 400958 | 1953-06-30 00:00:00 | Leandro | Coullard | M | 1990-09-11 00:00:00 |
| 400959 | 1962-06-26 00:00:00 | Caolyn | Etalle | M | 1997-09-01 00:00:00 |
| 400962 | 1955-04-06 00:00:00 | Menkae | Schlenzig | M | 1985-10-10 00:00:00 |
| 400964 | 1956-07-25 00:00:00 | Shaowen | Kulisch | M | 1997-01-05 00:00:00 |
| 400966 | 1954-12-10 00:00:00 | Izaskun | Percebois | M | 1986-03-03 00:00:00 |
| 400967 | 1952-07-02 00:00:00 | Ziva | Driscoll | M | 1986-02-05 00:00:00 |
| 400968 | 1959-08-24 00:00:00 | Kwangho | Heemskerk | M | 1988-02-26 00:00:00 |
| 400969 | 1957-06-14 00:00:00 | Aleksandar | Rusterholz | M | 1987-12-23 00:00:00 |
| 400970 | 1961-10-19 00:00:00 | Zijian | Khamsi | M | 1995-06-28 00:00:00 |
| 400971 | 1956-10-28 00:00:00 | Make | Isaac | F | 1988-09-26 00:00:00 |
| 400973 | 1960-05-01 00:00:00 | Remmert | Speer | M | 1989-03-19 00:00:00 |
| 400977 | 1958-11-18 00:00:00 | Hitomi | Cromarty | F | 1985-08-04 00:00:00 |
| 400980 | 1961-09-10 00:00:00 | Rafael | Schreiter | F | 1991-07-01 00:00:00 |
| 400982 | 1953-09-14 00:00:00 | Jessie | Rindone | M | 1988-04-08 00:00:00 |
| 400983 | 1953-12-03 00:00:00 | Itzchak | Rabehasaina | M | 1988-04-14 00:00:00 |
| 400987 | 1957-01-24 00:00:00 | Wanqing | Conry | F | 1989-03-09 00:00:00 |
| 400989 | 1958-10-27 00:00:00 | Chenxi | Madeira | M | 1993-06-17 00:00:00 |
| 400994 | 1963-05-15 00:00:00 | Hauke | Guerreiro | F | 1986-08-23 00:00:00 |
| 400997 | 1961-09-11 00:00:00 | Sastry | Rikino | F | 1987-07-12 00:00:00 |
| 400998 | 1952-07-31 00:00:00 | Bernardo | Sudkamp | F | 1990-07-31 00:00:00 |
| 400999 | 1964-05-05 00:00:00 | Roselyn | Seghrouchni | M | 1993-11-07 00:00:00 |
| 401002 | 1954-04-26 00:00:00 | Rosella | Munch | M | 1986-11-20 00:00:00 |
| 401003 | 1962-05-21 00:00:00 | Honesty | Sommen | M | 1996-04-30 00:00:00 |
| 401004 | 1960-09-13 00:00:00 | Deniz | Hitomi | M | 1991-11-07 00:00:00 |
| 401005 | 1964-12-31 00:00:00 | Renny | Fritzsche | M | 1988-01-20 00:00:00 |
| 401006 | 1955-02-16 00:00:00 | Naftali | Conde | F | 1988-06-05 00:00:00 |
| 401008 | 1954-07-16 00:00:00 | Adit | Penz | M | 1987-08-07 00:00:00 |
| 401011 | 1959-11-09 00:00:00 | Hideo | Cooman | F | 1989-10-29 00:00:00 |
| 401012 | 1952-08-29 00:00:00 | Tianruo | Garnick | M | 1992-11-05 00:00:00 |
| 401013 | 1957-10-08 00:00:00 | Lijia | Scallan | F | 1996-08-09 00:00:00 |
| 401015 | 1955-08-31 00:00:00 | Lijia | Lichtman | M | 1988-01-08 00:00:00 |
| 401022 | 1952-08-14 00:00:00 | Zejun | Stanger | M | 1986-06-20 00:00:00 |
| 401024 | 1958-03-06 00:00:00 | Bedir | Rotem | F | 1990-06-15 00:00:00 |
| 401026 | 1959-09-02 00:00:00 | Bernice | Ducloy | M | 1985-08-25 00:00:00 |
| 401027 | 1959-10-16 00:00:00 | Chiradeep | Veeraraghavan | F | 1987-07-06 00:00:00 |
| 401028 | 1963-02-11 00:00:00 | Shigeaki | Anido | M | 1994-06-05 00:00:00 |
| 401034 | 1958-07-15 00:00:00 | Chikako | Famili | F | 1987-01-01 00:00:00 |
| 401035 | 1956-08-11 00:00:00 | Arie | Waschkowski | M | 1993-08-25 00:00:00 |
| 401039 | 1956-12-29 00:00:00 | Jiang | Demos | M | 1993-08-15 00:00:00 |
| 401041 | 1955-10-04 00:00:00 | Hugh | Rajaraman | F | 1993-11-16 00:00:00 |
| 401042 | 1958-06-12 00:00:00 | Danco | Skogmar | F | 1991-03-27 00:00:00 |
| 401043 | 1962-11-29 00:00:00 | Nahid | Dymetman | M | 1986-11-07 00:00:00 |
| 401047 | 1957-01-26 00:00:00 | Satoru | Iisaku | F | 1987-08-14 00:00:00 |
| 401050 | 1958-08-06 00:00:00 | Tadahiko | Garnier | F | 1995-03-10 00:00:00 |
| 401053 | 1955-03-07 00:00:00 | Kousuke | Baaz | M | 1995-11-29 00:00:00 |
| 401055 | 1959-12-25 00:00:00 | Shuzo | Rehfuss | M | 1990-05-16 00:00:00 |
| 401057 | 1952-05-01 00:00:00 | Mohammad | Takkinen | F | 1987-11-13 00:00:00 |
| 401059 | 1952-05-13 00:00:00 | Wuxu | DasSarma | M | 1987-07-17 00:00:00 |
| 401060 | 1960-12-05 00:00:00 | Moon | Demke | M | 1985-12-14 00:00:00 |
| 401061 | 1957-03-14 00:00:00 | Thanasis | Picaronny | M | 1985-05-21 00:00:00 |
| 401062 | 1960-08-07 00:00:00 | Syozo | Kalsbeek | F | 1988-02-02 00:00:00 |
| 401064 | 1954-05-23 00:00:00 | Vishu | Siepmann | M | 1989-09-13 00:00:00 |
| 401070 | 1957-06-04 00:00:00 | Susanne | Schiettecatte | M | 1987-08-09 00:00:00 |
| 401071 | 1962-09-30 00:00:00 | Deniz | Shinomoto | F | 1992-02-23 00:00:00 |
| 401072 | 1963-12-25 00:00:00 | Gonzalo | Domenig | M | 1989-10-16 00:00:00 |
| 401073 | 1959-02-03 00:00:00 | Marko | Candan | M | 1985-04-04 00:00:00 |
| 401077 | 1954-09-14 00:00:00 | Yuriy | Butner | M | 1994-10-19 00:00:00 |
| 401079 | 1959-08-17 00:00:00 | Martial | Nergos | M | 1992-11-10 00:00:00 |
| 401080 | 1963-06-21 00:00:00 | Krisda | Deyuan | M | 1995-12-03 00:00:00 |
| 401081 | 1954-05-15 00:00:00 | Chenye | Beidas | F | 1996-08-24 00:00:00 |
| 401082 | 1958-10-26 00:00:00 | Ingemar | Karnin | M | 1992-03-31 00:00:00 |
| 401083 | 1964-03-19 00:00:00 | Manohar | Miyakawa | M | 1985-08-20 00:00:00 |
| 401084 | 1959-02-27 00:00:00 | Moon | Deville | M | 1988-10-21 00:00:00 |
| 401085 | 1953-10-07 00:00:00 | Weiye | Brobst | M | 1987-05-18 00:00:00 |
| 401089 | 1953-10-22 00:00:00 | Unal | Murtha | M | 1989-10-08 00:00:00 |
| 401090 | 1960-08-27 00:00:00 | Rosine | Landherr | F | 1992-02-02 00:00:00 |
| 401091 | 1954-09-22 00:00:00 | Kwangho | Gecsei | F | 1987-03-22 00:00:00 |
| 401092 | 1962-03-09 00:00:00 | Katsuo | Auria | M | 1991-04-26 00:00:00 |
| 401093 | 1961-12-06 00:00:00 | Vitaly | Steenbeek | M | 1995-02-17 00:00:00 |
| 401095 | 1962-11-23 00:00:00 | Faiza | Krohn | M | 1991-03-07 00:00:00 |
| 401097 | 1964-03-16 00:00:00 | Yinghua | Androutsos | M | 1993-09-07 00:00:00 |
| 401098 | 1954-08-02 00:00:00 | Badri | Verhaegen | F | 1985-12-25 00:00:00 |
| 401099 | 1964-11-16 00:00:00 | Kerryn | Eickenmeyer | M | 1985-04-05 00:00:00 |
| 401100 | 1963-02-18 00:00:00 | Pintsang | Azevdeo | F | 1990-07-26 00:00:00 |
| 401104 | 1959-12-31 00:00:00 | Kazuhisa | Levergood | F | 1988-05-09 00:00:00 |
| 401107 | 1952-05-13 00:00:00 | Seongbin | Cronin | F | 1995-01-19 00:00:00 |
| 400775 | 1960-10-30 00:00:00 | Oldrich | Ghalwash | F | 1996-03-03 00:00:00 |
| 400776 | 1953-11-11 00:00:00 | Hauke | Sullins | F | 1988-03-30 00:00:00 |
| 400777 | 1964-09-05 00:00:00 | Rasikan | Murthy | M | 1991-06-17 00:00:00 |
| 400781 | 1963-02-17 00:00:00 | Zhenhua | Penttonen | F | 1988-09-03 00:00:00 |
| 400782 | 1956-02-18 00:00:00 | Yuichiro | Kroha | M | 1988-06-30 00:00:00 |
| 400785 | 1958-11-24 00:00:00 | Gregory | Feldhoffer | M | 1985-03-25 00:00:00 |
| 400787 | 1961-12-05 00:00:00 | Alain | Gimarc | F | 1987-06-16 00:00:00 |
| 400788 | 1958-12-18 00:00:00 | Jaroslava | Gulla | M | 1985-05-17 00:00:00 |
| 400790 | 1963-10-03 00:00:00 | Kerhong | Shinomoto | M | 1992-08-25 00:00:00 |
| 400793 | 1952-05-16 00:00:00 | Moheb | Hopewell | M | 1988-12-30 00:00:00 |
| 400795 | 1958-02-11 00:00:00 | Mark | Socorro | M | 1989-06-15 00:00:00 |
| 400800 | 1964-08-31 00:00:00 | Gor | DeMori | F | 1994-04-20 00:00:00 |
| 400801 | 1960-02-08 00:00:00 | Goetz | Serra | F | 1995-05-18 00:00:00 |
| 400805 | 1964-03-31 00:00:00 | Yonghoan | Puppo | M | 1989-04-01 00:00:00 |
| 400806 | 1964-02-07 00:00:00 | Pranay | Gajiwala | F | 1985-06-17 00:00:00 |
| 400807 | 1963-03-29 00:00:00 | Dayanand | Rosch | F | 1987-04-24 00:00:00 |
| 400810 | 1957-02-11 00:00:00 | Renny | Chimia | F | 1986-07-25 00:00:00 |
| 400811 | 1959-08-03 00:00:00 | Yinlin | Cooley | M | 1994-01-22 00:00:00 |
| 400812 | 1961-05-08 00:00:00 | Jackson | Hardjono | M | 1986-11-13 00:00:00 |
| 400814 | 1963-06-19 00:00:00 | Nagui | Nilsson | M | 1989-07-07 00:00:00 |
| 400820 | 1957-04-24 00:00:00 | Xinglin | Chiola | M | 1989-07-21 00:00:00 |
| 400821 | 1961-01-15 00:00:00 | Alejandro | Narahara | M | 1989-10-27 00:00:00 |
| 400822 | 1959-01-18 00:00:00 | Nevio | Picht | F | 1996-01-25 00:00:00 |
| 400824 | 1953-02-09 00:00:00 | Zsolt | Koshiba | F | 1986-08-06 00:00:00 |
| 400826 | 1957-03-28 00:00:00 | Pranjal | Pollock | M | 1994-11-18 00:00:00 |
| 400828 | 1953-08-02 00:00:00 | Fusako | Kroll | F | 1992-10-25 00:00:00 |
| 400831 | 1964-10-22 00:00:00 | Miquel | Miyakawa | M | 1990-03-01 00:00:00 |
| 400832 | 1954-07-09 00:00:00 | Guenter | Muhling | M | 1989-05-03 00:00:00 |
| 400833 | 1964-05-30 00:00:00 | Nathalie | Rabehasaina | F | 1992-06-30 00:00:00 |
| 400838 | 1955-08-27 00:00:00 | Gadiel | Ghelli | F | 1985-09-10 00:00:00 |
| 400841 | 1963-06-05 00:00:00 | Zijian | Baalen | M | 1992-11-10 00:00:00 |
| 400842 | 1954-08-04 00:00:00 | Tetsushi | Guenter | M | 1994-01-12 00:00:00 |
| 400844 | 1954-02-09 00:00:00 | Krassimir | England | F | 1997-08-12 00:00:00 |
| 400845 | 1964-11-15 00:00:00 | Danny | Ghalwash | M | 1985-02-13 00:00:00 |
| 400846 | 1954-08-29 00:00:00 | Sanjiv | Bauknecht | M | 1998-04-20 00:00:00 |
| 400847 | 1952-09-19 00:00:00 | Shigeo | Laventhal | F | 1985-07-21 00:00:00 |
| 400848 | 1953-08-11 00:00:00 | Dung | Flowers | F | 1986-03-03 00:00:00 |
| 400853 | 1953-03-04 00:00:00 | Moti | Dredge | M | 1992-08-30 00:00:00 |
| 400854 | 1957-10-19 00:00:00 | Jingling | Marchegay | M | 1994-02-09 00:00:00 |
| 400855 | 1954-06-30 00:00:00 | Szabolcs | Wilharm | M | 1985-02-14 00:00:00 |
| 400858 | 1960-05-30 00:00:00 | Francoise | Cesareni | M | 1995-04-09 00:00:00 |
| 400859 | 1961-04-03 00:00:00 | Roddy | Lanphier | M | 1990-02-16 00:00:00 |
| 400860 | 1960-08-21 00:00:00 | Josyula | Welham | M | 1989-10-23 00:00:00 |
| 400861 | 1957-12-19 00:00:00 | Amabile | Eastman | F | 1986-10-05 00:00:00 |
| 400863 | 1960-11-05 00:00:00 | Dines | Codenie | F | 1990-07-10 00:00:00 |
| 400864 | 1953-07-03 00:00:00 | Kiyotoshi | Olano | M | 1987-11-28 00:00:00 |
| 400866 | 1963-05-29 00:00:00 | Heather | Ratzlaff | M | 1986-02-08 00:00:00 |
| 400870 | 1964-07-11 00:00:00 | Yefim | Birta | M | 1989-04-06 00:00:00 |
| 400873 | 1955-06-10 00:00:00 | Mark | Butner | M | 1988-02-14 00:00:00 |
| 400874 | 1960-05-24 00:00:00 | Gretta | Shihab | F | 1991-04-20 00:00:00 |
| 400875 | 1962-10-31 00:00:00 | Huan | Dratva | M | 1988-10-22 00:00:00 |
| 400876 | 1964-07-31 00:00:00 | Dietrich | Thibadeau | F | 1988-01-13 00:00:00 |
| 400877 | 1953-11-12 00:00:00 | Dmitry | Azuma | M | 1985-12-24 00:00:00 |
| 400878 | 1952-12-07 00:00:00 | Tru | Demir | M | 1985-07-09 00:00:00 |
| 400879 | 1961-08-24 00:00:00 | Baocai | Ebeling | F | 1991-08-17 00:00:00 |
| 400880 | 1961-08-20 00:00:00 | Tadahiro | Pietracaprina | M | 1988-12-16 00:00:00 |
| 400882 | 1957-06-22 00:00:00 | Zsolt | Katalagarianos | M | 1987-05-04 00:00:00 |
| 400883 | 1953-05-02 00:00:00 | Georg | DeMori | M | 1996-12-09 00:00:00 |
| 400884 | 1955-09-23 00:00:00 | Lalit | Picci | M | 1990-02-13 00:00:00 |
| 400885 | 1954-10-21 00:00:00 | Gaurav | Peck | M | 1985-09-08 00:00:00 |
| 400887 | 1953-02-18 00:00:00 | Mohan | Lamparter | F | 1989-04-05 00:00:00 |
| 400889 | 1958-03-11 00:00:00 | Owen | Cummings | F | 1991-05-16 00:00:00 |
| 400893 | 1959-09-27 00:00:00 | Hercules | Pietracaprina | M | 1985-04-26 00:00:00 |
| 400895 | 1955-02-22 00:00:00 | Shih | Narwekar | F | 1991-10-24 00:00:00 |
| 400900 | 1957-06-27 00:00:00 | Mari | Rothenberg | M | 1988-03-10 00:00:00 |
| 400901 | 1961-12-05 00:00:00 | Waiman | Pusterhofer | M | 1992-03-12 00:00:00 |
| 400902 | 1964-06-21 00:00:00 | Ayonca | Gimbel | F | 1996-12-02 00:00:00 |
| 400903 | 1964-04-11 00:00:00 | Yonghong | Beutelspacher | M | 1988-08-31 00:00:00 |
| 400911 | 1959-09-29 00:00:00 | Fen | Yurek | M | 1989-07-07 00:00:00 |
| 400913 | 1952-11-29 00:00:00 | Irene | Rettelbach | M | 1991-02-02 00:00:00 |
| 400914 | 1961-01-11 00:00:00 | Bojan | Frolund | M | 1985-05-15 00:00:00 |
| 400915 | 1955-02-17 00:00:00 | Sigeru | Gien | F | 1997-11-03 00:00:00 |
| 400917 | 1962-07-16 00:00:00 | Hauke | Garrabrants | F | 1986-04-15 00:00:00 |
| 400919 | 1954-11-03 00:00:00 | Bodo | Heusch | F | 1992-01-26 00:00:00 |
| 400921 | 1963-11-04 00:00:00 | Licheng | Dalton | M | 1985-05-12 00:00:00 |
| 400922 | 1963-12-07 00:00:00 | Utpal | Atrawala | M | 1990-06-25 00:00:00 |
| 400924 | 1956-11-02 00:00:00 | Rance | Braccini | M | 1994-03-13 00:00:00 |
| 400927 | 1959-08-19 00:00:00 | Steve | Luft | M | 1988-06-16 00:00:00 |
| 400928 | 1959-01-14 00:00:00 | Erez | Turnbull | M | 1986-10-19 00:00:00 |
| 400932 | 1953-06-20 00:00:00 | Xiahua | Binkley | M | 1986-04-06 00:00:00 |
| 400934 | 1963-04-25 00:00:00 | Jingling | Jonsson | M | 1990-03-10 00:00:00 |
| 400938 | 1958-09-25 00:00:00 | Van | Thummel | M | 1985-06-05 00:00:00 |
| 400939 | 1960-08-20 00:00:00 | Arumugam | Plessier | F | 1985-07-27 00:00:00 |
| 400941 | 1959-04-19 00:00:00 | Dietrich | Madeira | M | 1997-02-22 00:00:00 |
| 400943 | 1958-04-11 00:00:00 | Jovan | Weiland | M | 1992-08-22 00:00:00 |
| 400945 | 1952-04-22 00:00:00 | Olivera | Litvinov | M | 1995-11-27 00:00:00 |
| 400947 | 1957-06-18 00:00:00 | Peternela | Dahlbom | M | 1992-01-09 00:00:00 |
| 400951 | 1961-07-01 00:00:00 | Maya | Vickson | F | 1992-11-27 00:00:00 |
| 400952 | 1963-07-20 00:00:00 | Adel | Ranum | F | 1994-12-30 00:00:00 |
| 400953 | 1955-04-07 00:00:00 | Sham | Maksimenko | F | 1986-05-20 00:00:00 |
| 400960 | 1964-08-29 00:00:00 | Moie | McAlpine | M | 1988-03-31 00:00:00 |
| 400961 | 1958-12-06 00:00:00 | Emran | Engelmann | M | 1991-11-12 00:00:00 |
| 400963 | 1959-02-25 00:00:00 | Hisao | Rehfuss | F | 1994-06-28 00:00:00 |
| 400965 | 1960-07-01 00:00:00 | Mack | Dehkordi | M | 1991-11-07 00:00:00 |
| 400972 | 1957-08-19 00:00:00 | Chinho | Lalonde | M | 1996-01-30 00:00:00 |
| 400974 | 1957-11-25 00:00:00 | Anoosh | Nishimukai | M | 1990-09-08 00:00:00 |
| 400975 | 1955-07-21 00:00:00 | Toshiko | Gniady | M | 1985-08-24 00:00:00 |
| 400976 | 1958-12-24 00:00:00 | Otilia | Kornatzky | M | 1985-06-20 00:00:00 |
| 400978 | 1954-09-28 00:00:00 | Shuzo | Vesel | F | 1989-07-30 00:00:00 |
| 400979 | 1956-10-04 00:00:00 | Abdelaziz | Pocchiola | M | 1993-09-21 00:00:00 |
| 400981 | 1957-08-27 00:00:00 | Guadalupe | Furedi | M | 1994-09-11 00:00:00 |
| 400984 | 1954-03-19 00:00:00 | Valdiodio | Swift | M | 1987-12-06 00:00:00 |
| 400985 | 1963-09-16 00:00:00 | Nikolaos | Kaltofen | M | 1986-02-08 00:00:00 |
| 400986 | 1956-02-20 00:00:00 | Kensei | Gist | M | 1986-12-17 00:00:00 |
| 400988 | 1953-09-08 00:00:00 | Erez | Lovengreen | M | 1992-08-04 00:00:00 |
| 400990 | 1962-05-12 00:00:00 | Ziya | Koshiba | M | 1991-04-03 00:00:00 |
| 400991 | 1957-01-02 00:00:00 | Demos | Skrikant | F | 1992-09-24 00:00:00 |
| 400992 | 1964-11-03 00:00:00 | Niclas | Felder | M | 1987-11-26 00:00:00 |
| 400993 | 1955-09-29 00:00:00 | Feiyu | Brandsma | M | 1994-05-30 00:00:00 |
| 400995 | 1956-02-25 00:00:00 | Kazuhisa | Rotem | M | 1987-06-21 00:00:00 |
| 400996 | 1954-02-10 00:00:00 | LiMin | Atrawala | F | 1989-09-03 00:00:00 |
| 401000 | 1954-06-24 00:00:00 | Barry | Reeker | M | 1985-11-07 00:00:00 |
| 401001 | 1962-11-21 00:00:00 | Dinkar | Nyrup | F | 1987-09-16 00:00:00 |
| 401007 | 1954-05-30 00:00:00 | Zhonghui | Szemeredi | M | 1988-10-22 00:00:00 |
| 401009 | 1962-05-30 00:00:00 | Tru | Ozeri | F | 1995-09-19 00:00:00 |
| 401010 | 1953-07-15 00:00:00 | Richara | Terkki | M | 1988-09-25 00:00:00 |
| 401014 | 1956-01-14 00:00:00 | Masako | Farrel | F | 1989-11-08 00:00:00 |
| 401016 | 1956-09-29 00:00:00 | Yongmao | Tsukuda | M | 1989-06-24 00:00:00 |
| 401017 | 1954-09-05 00:00:00 | Shigeu | Provine | F | 1985-06-18 00:00:00 |
| 401018 | 1955-07-10 00:00:00 | Shunichi | Heemskerk | F | 1991-06-27 00:00:00 |
| 401019 | 1953-06-17 00:00:00 | Rosalyn | Codenie | F | 1985-06-20 00:00:00 |
| 401020 | 1962-05-27 00:00:00 | Arvin | Cronau | M | 1988-07-29 00:00:00 |
| 401021 | 1954-06-09 00:00:00 | Brigham | Unni | M | 1993-03-10 00:00:00 |
| 401023 | 1960-10-07 00:00:00 | Iara | Delaune | M | 1996-09-20 00:00:00 |
| 401025 | 1960-07-28 00:00:00 | Randy | Champarnaud | M | 1985-07-11 00:00:00 |
| 401029 | 1962-05-19 00:00:00 | Toshiki | Levergood | M | 1985-05-02 00:00:00 |
| 401030 | 1960-04-07 00:00:00 | Weiwu | Cappelletti | M | 1989-10-19 00:00:00 |
| 401031 | 1955-02-10 00:00:00 | Xumin | Butner | F | 1988-07-24 00:00:00 |
| 401032 | 1960-09-30 00:00:00 | Adly | Staudhammer | M | 1986-06-30 00:00:00 |
| 401033 | 1960-12-04 00:00:00 | Masato | Kornatzky | F | 1990-03-20 00:00:00 |
| 401036 | 1960-09-08 00:00:00 | Xinyu | Tomescu | F | 1998-12-02 00:00:00 |
| 401037 | 1953-12-16 00:00:00 | Aiichiro | Aloisi | M | 1990-08-20 00:00:00 |
| 401038 | 1956-06-05 00:00:00 | Jaideep | Merlo | F | 1989-06-23 00:00:00 |
| 401040 | 1964-04-01 00:00:00 | Doowon | Milicic | M | 1991-03-25 00:00:00 |
| 401044 | 1953-09-27 00:00:00 | Kwan | Cyne | F | 1992-03-04 00:00:00 |
| 401045 | 1957-06-05 00:00:00 | Xiong | Skogmar | M | 1985-06-14 00:00:00 |
| 401046 | 1959-05-19 00:00:00 | Hairong | Kornyak | M | 1988-02-17 00:00:00 |
| 401048 | 1956-05-19 00:00:00 | Leon | Jumpertz | M | 1992-08-15 00:00:00 |
| 401049 | 1960-03-17 00:00:00 | Niteen | Tiemann | M | 1987-11-10 00:00:00 |
| 401051 | 1956-09-26 00:00:00 | Shugo | Radhakrishnan | M | 1990-10-17 00:00:00 |
| 401052 | 1961-10-20 00:00:00 | Nikolaus | Panienski | M | 1988-04-17 00:00:00 |
| 401054 | 1961-07-22 00:00:00 | Bangqing | Zielinski | F | 1991-08-16 00:00:00 |
| 401056 | 1958-06-02 00:00:00 | Niranjan | Casperson | M | 1991-11-12 00:00:00 |
| 401058 | 1961-03-02 00:00:00 | Anneli | Stroustrup | F | 1987-01-03 00:00:00 |
| 401063 | 1957-03-27 00:00:00 | Dannz | Thebaut | F | 1991-06-12 00:00:00 |
| 401065 | 1960-03-21 00:00:00 | Vasilii | Castellani | F | 1990-08-23 00:00:00 |
| 401066 | 1958-02-15 00:00:00 | Adam | Valette | F | 1985-04-14 00:00:00 |
| 401067 | 1963-07-05 00:00:00 | Oksana | Genin | M | 1990-07-07 00:00:00 |
| 401068 | 1959-04-09 00:00:00 | Gladys | Karlin | M | 1987-03-02 00:00:00 |
| 401069 | 1957-10-06 00:00:00 | Moni | Matzel | M | 1985-10-27 00:00:00 |
| 401074 | 1960-09-19 00:00:00 | Janalee | Baby | M | 1985-10-27 00:00:00 |
| 401075 | 1959-07-26 00:00:00 | Muzhong | Milicic | M | 1987-11-16 00:00:00 |
| 401076 | 1954-05-09 00:00:00 | Zdislav | Hofmeyr | F | 1992-06-12 00:00:00 |
| 401078 | 1962-12-02 00:00:00 | Paloma | Zschoche | M | 1993-06-30 00:00:00 |
| 401086 | 1954-01-31 00:00:00 | Lorien | Linares | M | 1986-10-19 00:00:00 |
| 401087 | 1961-02-20 00:00:00 | Seshu | Vingron | M | 1995-11-16 00:00:00 |
| 401088 | 1960-06-22 00:00:00 | Odoardo | Cheshire | F | 1994-12-22 00:00:00 |
| 401094 | 1957-10-04 00:00:00 | Boaz | Marchesini | M | 1991-03-12 00:00:00 |
| 401096 | 1959-04-12 00:00:00 | Xiaoshan | Cardazo | F | 1986-01-20 00:00:00 |
| 401101 | 1963-08-31 00:00:00 | Mamdouh | Hatcliff | M | 1987-12-06 00:00:00 |
| 401102 | 1962-03-11 00:00:00 | Muneo | Azevdeo | M | 1987-01-22 00:00:00 |
| 401103 | 1956-09-02 00:00:00 | Tokuyasu | Budinsky | M | 1992-03-12 00:00:00 |
| 401105 | 1956-05-04 00:00:00 | Manu | Borstler | F | 1997-08-15 00:00:00 |
| 401106 | 1962-11-27 00:00:00 | Chrisa | Cappelletti | M | 1987-08-22 00:00:00 |
+--------+---------------------+---------------+----------------+--------+---------------------+
333 rows in set (0.01 sec)
StarRocks > select * from employees_tmp;
+--------+---------------------+---------------+------------------+--------+---------------------+
| emp_no | birth_date | first_name | last_name | gender | hire_date |
+--------+---------------------+---------------+------------------+--------+---------------------+
| 402109 | 1961-04-02 00:00:00 | Jiafu | Herath | M | 1994-07-09 00:00:00 |
| 402110 | 1962-11-24 00:00:00 | Etsuo | Zielinski | M | 1986-06-07 00:00:00 |
| 402111 | 1960-03-13 00:00:00 | Harjit | Silva | F | 1988-02-07 00:00:00 |
| 402114 | 1959-09-27 00:00:00 | Morrie | Awdeh | M | 1985-06-08 00:00:00 |
| 402115 | 1953-03-15 00:00:00 | Izaskun | Rijckaert | M | 1988-04-29 00:00:00 |
| 402116 | 1954-02-05 00:00:00 | Woody | Sudbeck | M | 1987-07-21 00:00:00 |
| 402117 | 1962-04-12 00:00:00 | Padma | Keohane | F | 1988-05-31 00:00:00 |
| 402123 | 1964-05-05 00:00:00 | Tesuro | Biran | M | 1991-02-14 00:00:00 |
| 402126 | 1955-10-31 00:00:00 | Odysseas | Auria | M | 1985-03-03 00:00:00 |
| 402133 | 1960-01-13 00:00:00 | Dharmaraja | Karcich | M | 1992-07-04 00:00:00 |
| 402134 | 1952-11-02 00:00:00 | Yuping | Szilard | M | 1996-01-06 00:00:00 |
| 402136 | 1955-02-26 00:00:00 | Hugh | Straney | F | 1987-09-17 00:00:00 |
| 402139 | 1957-11-10 00:00:00 | Zhongwei | Hofmeyr | F | 1992-10-29 00:00:00 |
| 402140 | 1962-02-04 00:00:00 | Angel | Aloia | M | 1994-06-12 00:00:00 |
| 402142 | 1957-07-15 00:00:00 | Mabo | Vieth | F | 1990-11-02 00:00:00 |
| 402145 | 1958-07-04 00:00:00 | Maja | Kenevan | F | 1987-03-02 00:00:00 |
| 402146 | 1962-10-06 00:00:00 | Demin | Benzmuller | M | 1988-07-01 00:00:00 |
| 402147 | 1961-03-02 00:00:00 | Pascal | Waleschkowski | M | 1995-10-25 00:00:00 |
| 402150 | 1956-01-19 00:00:00 | Tetsushi | Viele | F | 1987-09-17 00:00:00 |
| 402158 | 1959-09-12 00:00:00 | Goetz | Chvatal | M | 1985-04-22 00:00:00 |
| 402160 | 1963-02-05 00:00:00 | Jovan | Ranft | M | 1992-11-23 00:00:00 |
| 402161 | 1962-12-31 00:00:00 | Radoslaw | Dahlbom | M | 1994-12-07 00:00:00 |
| 402162 | 1953-07-11 00:00:00 | Yoshinari | Jenevein | F | 1986-10-01 00:00:00 |
| 402163 | 1954-03-06 00:00:00 | Alejandro | Sankaranarayanan | M | 1988-11-14 00:00:00 |
| 402165 | 1957-08-08 00:00:00 | Kellyn | Skogmar | F | 1986-02-08 00:00:00 |
| 402167 | 1962-09-23 00:00:00 | Dekang | Terwilliger | M | 1997-10-28 00:00:00 |
| 402168 | 1964-08-17 00:00:00 | Ohad | Tagansky | F | 1986-12-22 00:00:00 |
| 402172 | 1961-11-05 00:00:00 | Parke | Gajiwala | M | 1988-11-24 00:00:00 |
| 402173 | 1956-03-14 00:00:00 | Yannik | Stiles | F | 1990-04-06 00:00:00 |
| 402177 | 1953-06-23 00:00:00 | Xuedong | Rosaz | F | 1992-04-28 00:00:00 |
| 402178 | 1962-07-30 00:00:00 | Dzung | Pleszkun | F | 1988-11-08 00:00:00 |
| 402179 | 1958-12-14 00:00:00 | Macha | Knightly | F | 1991-03-27 00:00:00 |
| 402182 | 1962-11-29 00:00:00 | Along | Rijckaert | F | 1993-03-28 00:00:00 |
| 402184 | 1964-03-10 00:00:00 | Kwok | Ferriere | M | 1986-04-10 00:00:00 |
| 402187 | 1953-01-07 00:00:00 | Yuichiro | Peha | F | 1989-02-23 00:00:00 |
| 402188 | 1959-03-18 00:00:00 | Gill | Bazelow | F | 1991-04-26 00:00:00 |
| 402193 | 1963-08-10 00:00:00 | Uinam | Matzat | M | 1985-05-15 00:00:00 |
| 402194 | 1961-09-25 00:00:00 | Yolla | Haldar | M | 1993-11-08 00:00:00 |
| 402195 | 1954-06-19 00:00:00 | Yannik | Schapiro | F | 1994-05-19 00:00:00 |
| 402197 | 1953-08-06 00:00:00 | Tommaso | Chappelet | M | 1986-02-11 00:00:00 |
| 402199 | 1959-03-28 00:00:00 | Mingdong | Kaelbling | F | 1986-04-05 00:00:00 |
| 402200 | 1954-01-16 00:00:00 | Zine | Cyne | M | 1996-04-26 00:00:00 |
| 402202 | 1959-10-14 00:00:00 | Leni | Pusterhofer | M | 1995-01-29 00:00:00 |
| 402206 | 1956-09-07 00:00:00 | Kristin | Gini | F | 1988-11-25 00:00:00 |
| 402208 | 1963-12-26 00:00:00 | Visit | Hainaut | F | 1987-07-26 00:00:00 |
| 402211 | 1962-03-06 00:00:00 | Marko | Champarnaud | F | 1986-06-12 00:00:00 |
| 402213 | 1958-01-23 00:00:00 | Pasqua | Marzano | M | 1986-09-05 00:00:00 |
| 402214 | 1958-10-27 00:00:00 | Masanao | Yoshimura | M | 1992-03-23 00:00:00 |
| 402215 | 1952-07-05 00:00:00 | Susanta | Boguraev | M | 1995-03-09 00:00:00 |
| 402216 | 1957-10-10 00:00:00 | Filipe | Cools | F | 1985-04-20 00:00:00 |
| 402219 | 1952-09-13 00:00:00 | Greger | Gist | M | 1991-04-25 00:00:00 |
| 402222 | 1961-11-21 00:00:00 | Muneo | Redmiles | M | 1992-03-28 00:00:00 |
| 402225 | 1955-03-29 00:00:00 | Tsutomu | Jiang | F | 1988-09-19 00:00:00 |
| 402226 | 1962-09-21 00:00:00 | Leandro | Brookman | F | 1985-04-29 00:00:00 |
| 402228 | 1957-04-29 00:00:00 | Breannda | Baak | M | 1990-04-18 00:00:00 |
| 402229 | 1961-02-10 00:00:00 | Fai | Marletta | F | 1998-03-12 00:00:00 |
| 402230 | 1952-10-08 00:00:00 | Przemyslawa | Sanella | F | 1987-11-09 00:00:00 |
| 402231 | 1952-09-11 00:00:00 | Shim | Klerer | F | 1985-05-24 00:00:00 |
| 402233 | 1960-07-03 00:00:00 | Matt | Pauthner | M | 1996-02-10 00:00:00 |
| 402238 | 1955-08-11 00:00:00 | Sergi | Ramsay | M | 1987-04-14 00:00:00 |
| 402239 | 1964-11-02 00:00:00 | Peer | Birnbaum | M | 1987-12-25 00:00:00 |
| 402242 | 1954-09-25 00:00:00 | Toney | Boissier | M | 1990-07-23 00:00:00 |
| 402244 | 1958-05-11 00:00:00 | Doowon | Schnelling | M | 1998-01-01 00:00:00 |
| 402246 | 1955-10-07 00:00:00 | Leif | Aumann | F | 1985-10-07 00:00:00 |
| 402247 | 1952-03-26 00:00:00 | Jordanka | Krohn | F | 1989-03-06 00:00:00 |
| 402249 | 1956-05-04 00:00:00 | Ranga | Lamba | M | 1992-02-10 00:00:00 |
| 402250 | 1962-11-15 00:00:00 | Hiroyasu | Capobianchi | M | 1990-06-25 00:00:00 |
| 402251 | 1954-08-15 00:00:00 | Kellie | Miake | F | 1986-06-10 00:00:00 |
| 402254 | 1959-08-08 00:00:00 | Peternela | Trogemann | M | 1989-06-24 00:00:00 |
| 402258 | 1954-04-24 00:00:00 | Debaprosad | Besselaar | F | 1990-10-07 00:00:00 |
| 402259 | 1952-11-22 00:00:00 | Arno | Roohalamini | F | 1987-02-24 00:00:00 |
| 402260 | 1956-06-30 00:00:00 | Kellyn | Spataro | M | 1987-01-02 00:00:00 |
| 402261 | 1957-10-03 00:00:00 | Jaewoo | Strehl | M | 1996-07-04 00:00:00 |
| 402262 | 1958-09-05 00:00:00 | Vidar | Selenyi | F | 1990-03-08 00:00:00 |
| 402263 | 1958-06-29 00:00:00 | Kankanahalli | Chvatal | M | 1989-11-07 00:00:00 |
| 402266 | 1964-07-29 00:00:00 | Shim | Liedekerke | M | 1990-09-14 00:00:00 |
| 402269 | 1962-09-20 00:00:00 | Dulce | Baez | F | 1986-08-02 00:00:00 |
| 402270 | 1960-03-29 00:00:00 | Vishu | Lorie | M | 1990-05-10 00:00:00 |
| 402275 | 1954-06-27 00:00:00 | Rildo | Boguraev | F | 1992-05-29 00:00:00 |
| 402276 | 1959-02-02 00:00:00 | Patricio | Leivant | F | 1994-01-06 00:00:00 |
| 402278 | 1963-01-01 00:00:00 | Mooi | Range | F | 1994-07-30 00:00:00 |
| 402281 | 1964-11-28 00:00:00 | Boguslaw | Eiron | M | 1995-11-20 00:00:00 |
| 402285 | 1956-09-04 00:00:00 | Insup | Emmart | F | 1985-11-06 00:00:00 |
| 402287 | 1962-07-15 00:00:00 | Huiqun | Speckmann | F | 1994-12-13 00:00:00 |
| 402288 | 1964-06-02 00:00:00 | Hironoby | Lalonde | M | 1987-12-29 00:00:00 |
| 402291 | 1964-01-18 00:00:00 | Adhemar | Trogemann | F | 1990-04-05 00:00:00 |
| 402293 | 1959-01-13 00:00:00 | Pragnesh | Duclos | F | 1992-01-02 00:00:00 |
| 402296 | 1958-05-12 00:00:00 | Bezalel | Renear | M | 1994-02-14 00:00:00 |
| 402297 | 1956-12-11 00:00:00 | Shuzo | Magalhaes | M | 1987-12-13 00:00:00 |
| 402298 | 1956-12-25 00:00:00 | Kamakshi | Beetstra | M | 1986-03-07 00:00:00 |
| 402305 | 1959-09-06 00:00:00 | Bingning | Conia | M | 1992-03-23 00:00:00 |
| 402306 | 1957-03-17 00:00:00 | Makato | Potthoff | M | 1997-03-03 00:00:00 |
| 402314 | 1958-09-21 00:00:00 | Chikako | Kaltofen | M | 1989-05-28 00:00:00 |
| 402316 | 1958-12-27 00:00:00 | Boguslaw | Peot | M | 1997-07-08 00:00:00 |
| 402317 | 1959-11-29 00:00:00 | Monique | Schoegge | M | 1985-08-17 00:00:00 |
| 402320 | 1959-09-17 00:00:00 | Alejandro | Vernadat | M | 1989-07-31 00:00:00 |
| 402321 | 1956-09-16 00:00:00 | Guther | Farrel | F | 1986-05-31 00:00:00 |
| 402322 | 1955-12-03 00:00:00 | Somnath | Pargas | F | 1993-02-11 00:00:00 |
| 402327 | 1957-03-27 00:00:00 | Tetsurou | Breugel | M | 1987-04-12 00:00:00 |
| 402329 | 1959-12-11 00:00:00 | Paraskevi | Ghandeharizadeh | M | 1990-02-26 00:00:00 |
| 402330 | 1957-05-01 00:00:00 | Huan | Engberts | F | 1986-09-12 00:00:00 |
| 402331 | 1955-02-12 00:00:00 | Hidefumi | Bhattacharjee | M | 1988-07-01 00:00:00 |
| 402332 | 1959-05-03 00:00:00 | Mart | Czaja | M | 1990-06-10 00:00:00 |
| 402334 | 1956-02-26 00:00:00 | Shahid | Duclos | M | 1988-02-26 00:00:00 |
| 402336 | 1964-02-03 00:00:00 | Rafail | Kinley | M | 1985-12-11 00:00:00 |
| 402338 | 1961-04-25 00:00:00 | Ortrud | Ghandeharizadeh | F | 1985-02-11 00:00:00 |
| 402340 | 1954-10-17 00:00:00 | Doohun | Chelton | M | 1988-02-19 00:00:00 |
| 402341 | 1952-03-30 00:00:00 | Abdelwaheb | Bail | M | 1985-02-04 00:00:00 |
| 402343 | 1953-08-18 00:00:00 | Kokou | Farrar | F | 1992-05-27 00:00:00 |
| 402344 | 1954-10-23 00:00:00 | Izaskun | Nourani | F | 1992-01-12 00:00:00 |
| 402345 | 1958-06-21 00:00:00 | Chanjung | Czaja | M | 1991-12-25 00:00:00 |
| 402347 | 1961-03-16 00:00:00 | Ymte | Lorho | M | 1995-08-11 00:00:00 |
| 402348 | 1959-05-06 00:00:00 | Rosli | Jenevein | F | 1987-04-22 00:00:00 |
| 402349 | 1952-07-02 00:00:00 | Harngdar | Lipner | M | 1988-08-31 00:00:00 |
| 402350 | 1958-01-03 00:00:00 | Cedric | Tetzlaff | M | 1985-04-09 00:00:00 |
| 402351 | 1964-02-13 00:00:00 | Kazuhiko | Dulay | F | 1993-12-03 00:00:00 |
| 402355 | 1963-07-01 00:00:00 | Emdad | Budinsky | M | 1990-09-01 00:00:00 |
| 402356 | 1962-07-07 00:00:00 | Francoise | Colorni | F | 1996-06-29 00:00:00 |
| 402357 | 1961-12-04 00:00:00 | Duro | Papsdorf | M | 1985-04-10 00:00:00 |
| 402358 | 1959-03-25 00:00:00 | Zhilian | Buchter | M | 1987-10-22 00:00:00 |
| 402360 | 1957-08-07 00:00:00 | Guttorm | Speer | M | 1991-07-23 00:00:00 |
| 402361 | 1964-04-19 00:00:00 | Jaihie | Reinhard | M | 1996-04-09 00:00:00 |
| 402363 | 1959-01-21 00:00:00 | Shaz | Emmart | F | 1991-01-19 00:00:00 |
| 402365 | 1952-09-13 00:00:00 | Flemming | Menhoudj | F | 1986-05-15 00:00:00 |
| 402368 | 1964-05-30 00:00:00 | Zorica | Saoudi | F | 1995-11-23 00:00:00 |
| 402371 | 1957-02-26 00:00:00 | Mabo | Jervis | M | 1989-09-23 00:00:00 |
| 402372 | 1961-10-13 00:00:00 | Yurij | Thebaut | M | 1988-02-29 00:00:00 |
| 402375 | 1954-01-16 00:00:00 | Rasikan | Beeson | M | 1986-10-18 00:00:00 |
| 402376 | 1958-12-21 00:00:00 | Werner | Benveniste | F | 1987-02-27 00:00:00 |
| 402377 | 1962-08-20 00:00:00 | Djelloul | Pargaonkar | M | 1987-03-12 00:00:00 |
| 402378 | 1953-08-24 00:00:00 | Panayotis | Ritzmann | M | 1989-03-15 00:00:00 |
| 402379 | 1952-07-03 00:00:00 | Piyush | Setiz | F | 1988-11-07 00:00:00 |
| 402380 | 1958-12-14 00:00:00 | Yahiko | Vural | M | 1987-03-07 00:00:00 |
| 402382 | 1953-07-06 00:00:00 | Huiqun | Dahlbom | M | 1991-10-31 00:00:00 |
| 402386 | 1954-03-20 00:00:00 | Saniya | Soicher | M | 1985-11-16 00:00:00 |
| 402387 | 1953-11-16 00:00:00 | Perry | Gide | F | 1990-02-09 00:00:00 |
| 402391 | 1957-09-23 00:00:00 | Aruna | Nyrup | M | 1988-06-17 00:00:00 |
| 402392 | 1958-02-02 00:00:00 | Diederik | Maccarone | M | 1995-03-21 00:00:00 |
| 402394 | 1955-06-16 00:00:00 | Jeanne | Kossowski | M | 1985-05-12 00:00:00 |
| 402395 | 1963-11-24 00:00:00 | Zhilian | Openshaw | M | 1987-02-15 00:00:00 |
| 402396 | 1963-10-27 00:00:00 | Ingmar | Vural | M | 1993-01-03 00:00:00 |
| 402400 | 1962-02-07 00:00:00 | Zhigen | Baig | M | 1988-03-25 00:00:00 |
| 402401 | 1955-01-19 00:00:00 | Tze | Wroclawski | F | 1987-09-02 00:00:00 |
| 402402 | 1955-10-27 00:00:00 | Shaowen | Impagliazzo | M | 1996-06-17 00:00:00 |
| 402403 | 1958-06-22 00:00:00 | Sampalli | Neiman | M | 1998-11-07 00:00:00 |
| 402405 | 1958-04-13 00:00:00 | Guttorm | Piancastelli | F | 1989-05-16 00:00:00 |
| 402407 | 1956-07-30 00:00:00 | Xiaocheng | Simkin | M | 1994-06-05 00:00:00 |
| 402408 | 1960-10-20 00:00:00 | Genta | Welham | M | 1985-09-04 00:00:00 |
| 402415 | 1956-07-25 00:00:00 | Huei | Gonthier | M | 1993-11-19 00:00:00 |
| 402417 | 1958-10-10 00:00:00 | Akemi | Legleitner | M | 1997-07-10 00:00:00 |
| 402418 | 1960-10-01 00:00:00 | Younwoo | Irland | M | 1987-12-16 00:00:00 |
| 402420 | 1953-08-16 00:00:00 | Boalin | Delgrange | F | 1994-10-21 00:00:00 |
| 402421 | 1957-04-29 00:00:00 | Hironoby | Crabtree | M | 1992-05-27 00:00:00 |
| 402422 | 1958-03-04 00:00:00 | Sasan | Scharstein | M | 1988-01-08 00:00:00 |
| 402423 | 1953-06-19 00:00:00 | Basil | Vilarrasa | F | 1992-04-15 00:00:00 |
| 402427 | 1956-06-30 00:00:00 | Shirish | Verhaegen | F | 1985-06-30 00:00:00 |
| 402428 | 1953-10-11 00:00:00 | Mayuko | Ruemmler | M | 1991-12-18 00:00:00 |
| 402429 | 1964-06-11 00:00:00 | Marla | Bressoud | F | 1985-05-30 00:00:00 |
| 402432 | 1958-03-19 00:00:00 | Seongbae | Dalphin | F | 1990-03-07 00:00:00 |
| 402433 | 1958-03-10 00:00:00 | Chinya | Driscoll | M | 1985-03-26 00:00:00 |
| 402434 | 1960-11-06 00:00:00 | Yifei | Oppitz | F | 1993-11-28 00:00:00 |
| 402437 | 1956-09-26 00:00:00 | Udo | Benzmuller | M | 1990-01-27 00:00:00 |
| 402107 | 1961-10-04 00:00:00 | Yechezkel | Schapiro | F | 1986-06-09 00:00:00 |
| 402108 | 1960-10-31 00:00:00 | Marc | Verspoor | F | 1986-08-27 00:00:00 |
| 402112 | 1953-01-17 00:00:00 | Atreyi | Halloran | F | 1986-11-06 00:00:00 |
| 402113 | 1963-01-12 00:00:00 | Oldrich | Ciolek | F | 1994-08-10 00:00:00 |
| 402118 | 1955-04-18 00:00:00 | Tzu | Dayana | M | 1992-02-23 00:00:00 |
| 402119 | 1954-07-25 00:00:00 | Luise | Haldar | F | 1986-09-04 00:00:00 |
| 402120 | 1952-02-11 00:00:00 | George | Beausoleil | F | 1996-01-23 00:00:00 |
| 402121 | 1954-10-02 00:00:00 | Hauke | Bolsens | M | 1993-12-13 00:00:00 |
| 402122 | 1960-03-16 00:00:00 | Mahendra | Manders | M | 1989-11-12 00:00:00 |
| 402124 | 1963-02-04 00:00:00 | Gudjon | Riesenhuber | M | 1986-06-17 00:00:00 |
| 402125 | 1961-01-13 00:00:00 | Berthier | Escriba | M | 1990-12-31 00:00:00 |
| 402127 | 1953-11-02 00:00:00 | Nitsan | Georgakopoulos | F | 1988-01-18 00:00:00 |
| 402128 | 1955-01-06 00:00:00 | Edwin | Waeselynck | M | 1990-06-10 00:00:00 |
| 402129 | 1960-08-29 00:00:00 | Oksana | DeMori | F | 1987-03-31 00:00:00 |
| 402130 | 1963-12-05 00:00:00 | Lidong | Suwa | M | 1987-12-21 00:00:00 |
| 402131 | 1958-05-24 00:00:00 | Shin | Zhang | M | 1986-07-28 00:00:00 |
| 402132 | 1952-11-21 00:00:00 | Oscar | Wendorf | M | 1988-08-20 00:00:00 |
| 402135 | 1957-06-23 00:00:00 | Jaewon | Angelopoulos | F | 1992-09-16 00:00:00 |
| 402137 | 1956-05-30 00:00:00 | Xianlong | Escriba | F | 1989-10-14 00:00:00 |
| 402138 | 1953-12-14 00:00:00 | Aran | Kornatzky | M | 1991-06-26 00:00:00 |
| 402141 | 1957-07-09 00:00:00 | Shooichi | Parascandalo | F | 1996-04-07 00:00:00 |
| 402143 | 1964-03-12 00:00:00 | Jouni | Pero | M | 1987-07-19 00:00:00 |
| 402144 | 1961-01-10 00:00:00 | Feiyu | Koyama | F | 1988-10-17 00:00:00 |
| 402148 | 1963-03-12 00:00:00 | Kagan | Nilsson | F | 1992-03-09 00:00:00 |
| 402149 | 1956-07-31 00:00:00 | Akeno | Ibel | F | 1998-04-14 00:00:00 |
| 402151 | 1952-04-24 00:00:00 | Gennady | Rajaraman | F | 1994-07-03 00:00:00 |
| 402152 | 1961-04-06 00:00:00 | Alejandro | Lamba | M | 1986-06-19 00:00:00 |
| 402153 | 1958-04-20 00:00:00 | Mario | Dengi | M | 1996-08-04 00:00:00 |
| 402154 | 1964-05-24 00:00:00 | Genta | Baca | M | 1986-08-21 00:00:00 |
| 402155 | 1957-11-02 00:00:00 | Caolyn | Heiserman | F | 1988-12-15 00:00:00 |
| 402156 | 1961-08-02 00:00:00 | Vasiliy | Lovengreen | F | 1993-09-11 00:00:00 |
| 402157 | 1959-07-03 00:00:00 | Radhakrishnan | Zobel | F | 1987-05-06 00:00:00 |
| 402159 | 1953-04-01 00:00:00 | Mang | Oaver | F | 1990-11-06 00:00:00 |
| 402164 | 1958-01-30 00:00:00 | Lenore | Adachi | M | 1992-07-08 00:00:00 |
| 402166 | 1961-02-10 00:00:00 | Cullen | Percebois | F | 1990-03-10 00:00:00 |
| 402169 | 1960-07-10 00:00:00 | Martine | Kusalik | F | 1986-12-11 00:00:00 |
| 402170 | 1955-08-09 00:00:00 | King | Pulkowski | M | 1989-11-21 00:00:00 |
| 402171 | 1963-09-21 00:00:00 | Kazuhito | Munro | F | 1998-08-22 00:00:00 |
| 402174 | 1958-01-14 00:00:00 | Shushma | Botman | M | 1985-06-06 00:00:00 |
| 402175 | 1957-07-28 00:00:00 | Adel | Zaumen | M | 1986-02-07 00:00:00 |
| 402176 | 1958-07-16 00:00:00 | Tomofumi | Michaeli | F | 1986-09-08 00:00:00 |
| 402180 | 1958-02-13 00:00:00 | Vugranam | Underwood | F | 1992-02-14 00:00:00 |
| 402181 | 1960-06-11 00:00:00 | Persi | Flasterstein | M | 1987-02-11 00:00:00 |
| 402183 | 1964-04-17 00:00:00 | Evgueni | Fargier | F | 1996-08-07 00:00:00 |
| 402185 | 1963-08-21 00:00:00 | Sakthirel | Angelov | F | 1993-04-24 00:00:00 |
| 402186 | 1960-11-19 00:00:00 | Akeno | Chiola | M | 1986-09-03 00:00:00 |
| 402189 | 1955-02-05 00:00:00 | Erez | Zyda | F | 1994-04-30 00:00:00 |
| 402190 | 1958-07-06 00:00:00 | Tru | Dayang | F | 1997-03-10 00:00:00 |
| 402191 | 1959-09-08 00:00:00 | Udo | Wielonsky | M | 1988-11-05 00:00:00 |
| 402192 | 1958-03-20 00:00:00 | Zorica | Uehara | F | 1987-11-05 00:00:00 |
| 402196 | 1958-07-23 00:00:00 | Shmuel | Conti | M | 1990-07-18 00:00:00 |
| 402198 | 1958-05-18 00:00:00 | Larisa | Veeraraghavan | M | 1985-03-04 00:00:00 |
| 402201 | 1955-08-25 00:00:00 | Youssef | Grabner | F | 1988-07-21 00:00:00 |
| 402203 | 1957-03-10 00:00:00 | Fay | Mapelli | M | 1989-05-10 00:00:00 |
| 402204 | 1961-11-13 00:00:00 | Marco | Mitzlaff | F | 1999-02-13 00:00:00 |
| 402205 | 1960-12-01 00:00:00 | Shaleah | Sudkamp | M | 1985-02-13 00:00:00 |
| 402207 | 1963-01-17 00:00:00 | Lidong | Kinley | M | 1991-11-27 00:00:00 |
| 402209 | 1952-10-21 00:00:00 | Shuichi | Schonegge | F | 1985-05-20 00:00:00 |
| 402210 | 1957-10-23 00:00:00 | Otmar | Schaap | M | 1990-11-14 00:00:00 |
| 402212 | 1960-08-14 00:00:00 | Haldon | Delgrange | M | 1991-06-17 00:00:00 |
| 402217 | 1958-10-12 00:00:00 | Atreyi | Schnabel | M | 1992-08-26 00:00:00 |
| 402218 | 1963-12-22 00:00:00 | Aiichiro | Poupard | F | 1986-05-30 00:00:00 |
| 402220 | 1963-06-23 00:00:00 | Marc | Frolund | F | 1985-06-28 00:00:00 |
| 402221 | 1954-04-04 00:00:00 | Willard | Zastre | F | 1986-08-29 00:00:00 |
| 402223 | 1965-01-30 00:00:00 | Fai | Breugel | M | 1989-09-18 00:00:00 |
| 402224 | 1960-10-14 00:00:00 | Mabry | Desikan | M | 1986-10-23 00:00:00 |
| 402227 | 1956-01-09 00:00:00 | Billie | Rusterholz | F | 1988-12-19 00:00:00 |
| 402232 | 1957-03-17 00:00:00 | Olivera | Glinert | M | 1988-05-07 00:00:00 |
| 402234 | 1954-06-30 00:00:00 | Shaleah | Bratten | M | 1991-03-07 00:00:00 |
| 402235 | 1963-10-29 00:00:00 | Aleksandar | Slaats | M | 1992-08-16 00:00:00 |
| 402236 | 1959-01-27 00:00:00 | Ewing | Copas | F | 1993-06-24 00:00:00 |
| 402237 | 1954-05-12 00:00:00 | Teunis | Lorch | F | 1989-10-15 00:00:00 |
| 402240 | 1955-12-13 00:00:00 | Paloma | Olivero | F | 1988-03-16 00:00:00 |
| 402241 | 1953-10-09 00:00:00 | Akhilish | Mukaidono | M | 1985-02-10 00:00:00 |
| 402243 | 1954-11-12 00:00:00 | Tadahiko | Ginneken | M | 1992-12-20 00:00:00 |
| 402245 | 1956-12-11 00:00:00 | Yechiam | Hopewell | M | 1987-05-01 00:00:00 |
| 402248 | 1956-02-07 00:00:00 | Georgy | Thombley | F | 1986-09-19 00:00:00 |
| 402252 | 1957-10-18 00:00:00 | Rosella | Kamble | M | 1986-07-27 00:00:00 |
| 402253 | 1964-07-15 00:00:00 | Qingxiang | Feldhoffer | F | 1994-04-05 00:00:00 |
| 402255 | 1959-09-05 00:00:00 | Jaber | Ecklund | M | 1990-07-11 00:00:00 |
| 402256 | 1955-02-20 00:00:00 | Nalini | Gini | M | 1988-08-17 00:00:00 |
| 402257 | 1953-06-25 00:00:00 | Fabrizio | Levergood | M | 1991-09-13 00:00:00 |
| 402264 | 1964-04-03 00:00:00 | Berry | Anandan | M | 1991-11-21 00:00:00 |
| 402265 | 1954-12-09 00:00:00 | Sanjai | Ruther | M | 1990-11-21 00:00:00 |
| 402267 | 1958-08-20 00:00:00 | Shigenori | Isard | M | 1987-07-07 00:00:00 |
| 402268 | 1959-11-19 00:00:00 | Aron | Aseltine | F | 1992-03-23 00:00:00 |
| 402271 | 1963-08-03 00:00:00 | Tristan | Pell | M | 1997-09-01 00:00:00 |
| 402272 | 1959-06-28 00:00:00 | Yongmao | Setiz | F | 1988-03-28 00:00:00 |
| 402273 | 1962-03-07 00:00:00 | Marsja | Syang | M | 1986-05-18 00:00:00 |
| 402274 | 1961-02-03 00:00:00 | Peternela | Rosin | F | 1994-04-25 00:00:00 |
| 402277 | 1955-08-27 00:00:00 | Seshu | Besancenot | M | 1985-05-28 00:00:00 |
| 402279 | 1952-03-02 00:00:00 | Shrikanth | Lally | M | 1989-02-24 00:00:00 |
| 402280 | 1960-07-15 00:00:00 | Zeydy | Trumbly | M | 1986-08-04 00:00:00 |
| 402282 | 1955-05-14 00:00:00 | Lunjin | Bruckman | M | 1994-01-11 00:00:00 |
| 402283 | 1958-10-18 00:00:00 | Pranjal | Maliniak | F | 1993-05-30 00:00:00 |
| 402284 | 1956-06-27 00:00:00 | Martina | Kamber | M | 1989-12-04 00:00:00 |
| 402286 | 1955-08-24 00:00:00 | Ramalingam | Renear | M | 1989-04-30 00:00:00 |
| 402289 | 1962-06-11 00:00:00 | Mostafa | Merey | F | 1988-08-20 00:00:00 |
| 402290 | 1953-06-14 00:00:00 | Kagan | Riefers | M | 1987-02-24 00:00:00 |
| 402292 | 1961-01-29 00:00:00 | Sariel | Ressouche | F | 1988-03-05 00:00:00 |
| 402294 | 1953-08-12 00:00:00 | Jayson | Kavvadias | M | 1996-07-12 00:00:00 |
| 402295 | 1961-07-07 00:00:00 | Bodo | Brandsma | F | 1990-01-28 00:00:00 |
| 402299 | 1953-01-15 00:00:00 | Giao | Leivant | F | 1995-06-01 00:00:00 |
| 402300 | 1958-10-23 00:00:00 | Aiman | Welham | F | 1986-05-14 00:00:00 |
| 402301 | 1954-05-13 00:00:00 | Arunas | Herbst | F | 1989-02-09 00:00:00 |
| 402302 | 1962-12-26 00:00:00 | Utz | Kamble | M | 1991-11-22 00:00:00 |
| 402303 | 1956-06-16 00:00:00 | Henk | Falby | M | 1985-03-23 00:00:00 |
| 402304 | 1953-08-13 00:00:00 | Weiru | Kaiserswerth | M | 1989-06-23 00:00:00 |
| 402307 | 1963-04-02 00:00:00 | Bedrich | Pews | M | 1991-04-09 00:00:00 |
| 402308 | 1957-01-30 00:00:00 | Maren | Pettis | F | 1986-12-02 00:00:00 |
| 402309 | 1953-10-16 00:00:00 | Honglan | Coorg | M | 1989-09-10 00:00:00 |
| 402310 | 1958-07-28 00:00:00 | Aloys | Bennet | F | 1992-06-13 00:00:00 |
| 402311 | 1959-11-28 00:00:00 | Unal | Collavizza | M | 1988-01-17 00:00:00 |
| 402312 | 1959-01-20 00:00:00 | Marlo | Broomell | M | 1992-02-28 00:00:00 |
| 402313 | 1963-09-14 00:00:00 | Sariel | Bodoff | F | 1986-04-11 00:00:00 |
| 402315 | 1952-02-12 00:00:00 | Yannis | Birge | F | 1988-08-27 00:00:00 |
| 402318 | 1953-07-26 00:00:00 | Mahmut | Emmerich | F | 1992-04-28 00:00:00 |
| 402319 | 1964-04-13 00:00:00 | Jasminko | Kolvik | F | 1988-04-18 00:00:00 |
| 402323 | 1960-04-21 00:00:00 | Neven | Zaccaria | F | 1986-09-29 00:00:00 |
| 402324 | 1960-01-08 00:00:00 | Fox | Kalorkoti | M | 1987-11-09 00:00:00 |
| 402325 | 1964-12-17 00:00:00 | Alair | Speer | M | 1989-08-05 00:00:00 |
| 402326 | 1955-05-03 00:00:00 | Subbu | Shiratori | F | 1996-01-04 00:00:00 |
| 402328 | 1955-09-09 00:00:00 | Yongqiao | Jording | F | 1993-01-03 00:00:00 |
| 402333 | 1962-10-09 00:00:00 | Barna | Bahi | F | 1986-03-27 00:00:00 |
| 402335 | 1959-07-18 00:00:00 | Adhemar | Pelc | M | 1989-02-11 00:00:00 |
| 402337 | 1952-05-10 00:00:00 | Yagil | Guting | M | 1996-12-11 00:00:00 |
| 402339 | 1961-08-17 00:00:00 | Giordano | Weedon | F | 1993-04-04 00:00:00 |
| 402342 | 1955-01-17 00:00:00 | Giordano | Collavizza | F | 1986-04-05 00:00:00 |
| 402346 | 1958-11-02 00:00:00 | Weidon | Baranowski | F | 1995-07-19 00:00:00 |
| 402352 | 1954-06-09 00:00:00 | Kyoichi | Birch | M | 1989-11-06 00:00:00 |
| 402353 | 1957-07-30 00:00:00 | Munehiko | Heydon | M | 1993-06-20 00:00:00 |
| 402354 | 1964-04-22 00:00:00 | Dante | Mersereau | M | 1986-07-27 00:00:00 |
| 402359 | 1957-01-09 00:00:00 | Toney | Awdeh | M | 1990-02-08 00:00:00 |
| 402362 | 1961-08-28 00:00:00 | Kwangho | Bratten | F | 1990-08-18 00:00:00 |
| 402364 | 1959-01-05 00:00:00 | Xianlong | Hiyoshi | M | 1994-03-15 00:00:00 |
| 402366 | 1961-03-03 00:00:00 | Nakhoon | Furedi | M | 1992-11-23 00:00:00 |
| 402367 | 1955-06-24 00:00:00 | Doowon | Mikschl | F | 1988-03-13 00:00:00 |
| 402369 | 1957-07-30 00:00:00 | Hairong | Emmart | M | 1989-10-20 00:00:00 |
| 402370 | 1955-02-26 00:00:00 | Poornachandra | Cannata | M | 1989-09-13 00:00:00 |
| 402373 | 1956-09-06 00:00:00 | Cullen | Rousseau | F | 1987-06-18 00:00:00 |
| 402374 | 1964-07-13 00:00:00 | Hirochika | Kisuki | M | 1992-10-14 00:00:00 |
| 402381 | 1963-07-28 00:00:00 | Valeri | Melton | F | 1985-10-21 00:00:00 |
| 402383 | 1958-02-01 00:00:00 | Guadalupe | Perl | F | 1990-04-07 00:00:00 |
| 402384 | 1959-01-03 00:00:00 | Elvis | Borstler | M | 1991-02-13 00:00:00 |
| 402385 | 1956-06-29 00:00:00 | Randy | Falster | F | 1986-11-21 00:00:00 |
| 402388 | 1959-07-13 00:00:00 | Shaunak | Serna | M | 1988-09-01 00:00:00 |
| 402389 | 1953-10-20 00:00:00 | Vugranam | Dalphin | M | 1985-06-21 00:00:00 |
| 402390 | 1956-12-03 00:00:00 | Mabhin | Matzat | M | 1992-04-06 00:00:00 |
| 402393 | 1960-02-02 00:00:00 | Harngdar | Demeyer | M | 1989-04-20 00:00:00 |
| 402397 | 1962-08-21 00:00:00 | Yongmin | Ossenbruggen | F | 1992-01-08 00:00:00 |
| 402398 | 1956-12-24 00:00:00 | Rafols | Oxenboll | F | 1989-10-06 00:00:00 |
| 402399 | 1961-05-01 00:00:00 | Syozo | Gornas | F | 1995-07-07 00:00:00 |
| 402404 | 1957-11-20 00:00:00 | Hironobu | Czap | F | 1989-05-31 00:00:00 |
| 402406 | 1953-11-25 00:00:00 | Mats | Larfeldt | M | 1986-05-17 00:00:00 |
| 402409 | 1955-09-09 00:00:00 | Indrajit | Azuma | M | 1996-08-08 00:00:00 |
| 402410 | 1960-10-13 00:00:00 | Bokyung | Cooke | F | 1991-10-26 00:00:00 |
| 402411 | 1956-08-22 00:00:00 | Vitali | Eastman | F | 1987-10-08 00:00:00 |
| 402412 | 1956-07-12 00:00:00 | Murthy | Lubachevsky | F | 1987-03-30 00:00:00 |
| 402413 | 1957-02-13 00:00:00 | Mabhin | Kohling | M | 1988-03-05 00:00:00 |
| 402414 | 1964-08-11 00:00:00 | Makato | Stifter | M | 1986-11-02 00:00:00 |
| 402416 | 1964-09-06 00:00:00 | Mark | Sudbeck | M | 1991-06-19 00:00:00 |
| 402419 | 1962-10-14 00:00:00 | Hiroyasu | Gurbaxani | M | 1989-11-10 00:00:00 |
| 402424 | 1954-07-06 00:00:00 | Shushma | Khalil | M | 1986-03-25 00:00:00 |
| 402425 | 1952-02-19 00:00:00 | Jeanna | Kemmerer | M | 1985-09-29 00:00:00 |
| 402426 | 1961-12-20 00:00:00 | Sakthirel | Pavlopoulou | F | 1988-09-13 00:00:00 |
| 402430 | 1954-10-06 00:00:00 | Atreye | Ernst | M | 1986-04-27 00:00:00 |
| 402431 | 1956-09-23 00:00:00 | Boaz | Ambroszkiewicz | M | 1989-03-27 00:00:00 |
| 402435 | 1952-08-06 00:00:00 | Gennady | Serna | F | 1988-07-28 00:00:00 |
| 402436 | 1963-08-23 00:00:00 | Reinhold | Luce | M | 1993-07-31 00:00:00 |
| 402438 | 1959-04-26 00:00:00 | Shounak | Khamsi | F | 1987-03-11 00:00:00 |
| 402439 | 1957-10-30 00:00:00 | Adit | Laventhal | M | 1988-01-22 00:00:00 |
+--------+---------------------+---------------+------------------+--------+---------------------+
333 rows in set (0.01 sec)I can't be sure because debug doesn't say it but in the postgresql logs insert is using INSERT OVERWRITE. For StarRocks OVERWRITE means To overwrite the table with data. Can we try INSERT INTO?
https://docs.starrocks.io/docs/sql-reference/sql-statements/data-manipulation/INSERT/
alberttwong
commented
7 months ago atwong@Albert-CelerData sling-cli % grep -R OVERWRITE .
./core/dbio/database/database_starrocks.go: "INSERT OVERWRITE {table} ({fields}) VALUES {values} "+noDebugKey,
./core/dbio/database/templates/starrocks.yaml: INSERT OVERWRITE {tgt_table}So upserts are only allowed in primary key tables but we are creating duplicate key tables. https://docs.starrocks.io/docs/loading/Load_to_Primary_Key_tables/#upsert
alberttwong
commented
7 months ago Okay.. I validated on my side that the count is correct after switch the 2 files from INSERT OVERWRITE to INSERT INTO. @flarco
flarco
commented
7 months ago Ah, OK, thanks. Should we use Primary Key tables instead?
The create_table template (in ./core/dbio/database/templates/starrocks.yaml) currently is
create table if not exists {table} ({col_types}) duplicate key({primary_key}) distributed by hash({primary_key})
Should that be changed to:
create table if not exists {table} ({col_types}) primary key({primary_key}) distributed by hash({primary_key}) ?
Not too clear on the difference between duplicate vs primary key tables.
flarco
commented
7 months ago Ok so duplicate key is just a sort key. Here is what I'm thinking:
distributed by hash (since that's required). I think picking the _sling_loaded_at column may work for that, even though it won't be well distributed. The thing it, currently there isn't a good way to provide sort keys or hash keys in the configs, only a primary key and an update-key. Will think about that a bit more.primary key({primary_key}) distributed by hash({primary_key}).alberttwong
commented
7 months ago Well... for duplicate table... sling_loaded_at is fine as long as it's kinda unique and increasing or decreasing. You can pick more than one column for sort key and distributed by hash to make it more "unique" in terms of writing but in the big picture, it's not really that important because you can have duplicate rows and it'll store it that way.
For primary key, it's more like an OLTP table so we really need a unique key or else it'll do an update. I tested it out and I can already provide multiple columns to make a primary key.
in both situations, the downside is that our create table statement needs the keys to be defined in the correct column order for creation. Until the issue gets fixed, Sling has to solve it (sorry).
alberttwong
commented
7 months ago BTW, I didn't do the change PR for INSERT INTO because I don't know if I'm supposed to change both or only 1 place so I'll leave it to you to make the change.
flarco
commented
7 months ago in both situations, the downside is that our create table statement needs the keys to be defined in the correct column order for creation.
Ah ok, so the column order has to be correct in the CREATE TABLE statement? That's doable.
Can you explain that a bit more? Like if a table has col1, col2, col3, col4, with PK being col2, col3, the ddl column order needs to be col2, col3, col1, col4? Is it the same rule for duplicate key?
alberttwong
commented
7 months ago in both situations, the downside is that our create table statement needs the keys to be defined in the correct column order for creation.
Ah ok, so the column order has to be correct in the
CREATE TABLEstatement? That's doable.Can you explain that a bit more? Like if a table has
col1, col2, col3, col4, with PK beingcol2, col3, the ddl column order needs to becol2, col3, col1, col4? Is it the same rule for duplicate key?
Yes.
Also sort key and distribution hash are sometimes not the same. Eg key is customer order but distribution hash is on order date. Why? most queries are done by on a daily time dimensions. To limit data scan, we partition data out on a daily basis.
Examples https://docs.starrocks.io/docs/sql-reference/sql-statements/data-definition/CREATE_TABLE/#create-a-duplicate-key-table-that-uses-range-partition-hash-bucketing-and-column-based-storage-and-set-the-storage-medium-and-cooldown-time https://docs.starrocks.io/docs/sql-reference/sql-statements/data-definition/CREATE_TABLE/#create-a-primary-key-table-and-specify-the-sort-key
flarco
commented
7 months ago This is fixed in https://github.com/slingdata-io/sling-cli/pull/152 with removing OVERWRITE.
We can continue discussing table types logic in https://github.com/slingdata-io/sling-cli/issues/149.
Closing.
BNSBNS
commented
3 months ago @flarco Hi Flarco, I see this issue to be persistent on version 1.2.11 with backfill
fatal: --- proc.go:267 main --- --- sling_cli.go:442 main --- --- sling_cli.go:474 cliInit --- --- cli.go:286 CliProcess --- ~ failure running replication (see docs @ https://docs.slingdata.io/sling-cli) --- sling_run.go:188 processRun ---
--------------------------- xxxxxxxxxx --------------------------- --- task_run.go:99 func1 --- ~ execution failed --- task_run.go:541 runDbToDb --- ~ Could not WriteToDb --- task_run_write.go:333 WriteToDb --- inserted in temp table but table count (6692) != stream count (12236). Records missing/mismatch. Aborting
flarco
commented
3 months ago @BNSBNS is it deterministic? or random?
BNSBNS
commented
3 months ago @BNSBNS is it deterministic? or random?
@flarco Yes it's deterministic.
More background information: I am trying to migrate historical data from postgres into starrocks. I need to be able to re-order the column sequence and thus was trying out your tool.
ran another test with the CLI: --- task_run_write.go:333 WriteToDb --- inserted in temp table but table count (6692) != stream count (12236). Records missing/mismatch. Aborting
using dataset from https://dev.mysql.com/doc/employee/en/employees-installation.html
loaded it in mysql and then start ELT.
Table count and stream count are different?