You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by NileshKhaire <ng...@gmail.com> on 2019/03/13 10:13:13 UTC
Finding collocated data in ignite nodes
I am trying to collocate data based on SQL given in this link
https://ignite.apache.org/features/collocatedprocessing.html .
I have created 2 caches 'Country' and 'City' using following SQLs.
-- Cache Country
CREATE TABLE Country (
Code CHAR(3),
Name CHAR(52),
Continent CHAR(50),
Region CHAR(26),
SurfaceArea DECIMAL(10,2),
Population INT(11),
Capital INT(11),
PRIMARY KEY (Code)) WITH "template=partitioned, backups=1";
--Cache City
CREATE TABLE City (
ID INT(11),
Name CHAR(35),
CountryCode CHAR(3),
District CHAR(20),
Population INT(11),
PRIMARY KEY (ID, CountryCode)
) WITH "template=partitioned, backups=1, affinityKey=CountryCode";
I have inserted some sample records, for example :
insert into Country values('RU','Rusia','Rusia','Rusia',0.0,00,0);
insert into Country values('IND','India','Asia','Asia',0.0,00,0);
insert into City values(101,'Mumbai','IND','NA',00);
insert into City values(102,'Moscow','RU','NA',00);
I have started 2 ignite(on different machines) node to collocate data on
different nodes. After finding records presents on node 0 through visor
cache -scan -c=@c0 -id8=@n0
I can see both cities Mumbai and Moscow are present on node 0 (n0) as well
as on node 1. I was expecting that cities of India will be collocated on
node 0 and cities of Rusia will collocated on node 1 but not both on the
same node.
My questions are :
1. I am doing anything wrong while collocating the data .
2. Running visor cache -scan command is correct way to find collocated data
on nodes ?
3. If this is not correct way then, how can we find which data is collocated
on node 0 and node 1 ?
4. Let's say data is collocated on node 0 (cities of India) and node 1
(cities on Russia) . What will happen if one of the node will be
disconnected from cluster ? Will there be a data loss ? After restarting the
node, Will data be collocated again ?
Thank you in Advance.
PS : I have already asked this question on stack overflow but didn't get
answer
https://stackoverflow.com/questions/55100844/finding-collocated-data-in-ignite
<https://stackoverflow.com/questions/55100844/finding-collocated-data-in-ignite>
I have already tried collocated=true and local=true approaches . I also
tried to remove backups=1 flag from SQL query , starting 3rd node but
nothing is working. Hope I will get answer here :)
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
1) I think you do not actually have distributedJoins since with
distributedJoins I get:
sqlline> !connect jdbc:ignite:thin://localhost?distributedJoins=true
Enter username for jdbc:ignite:thin://localhost?distributedJoins=true:
Enter password for jdbc:ignite:thin://localhost?distributedJoins=true:
0: jdbc:ignite:thin://localhost> select count(*) from City c join Country
cc on cc.country_id != c.country_id;
Error: javax.cache.CacheException: Failed to prepare distributed join
query: join condition does not use index [joinedCache=SQL_PUBLIC_COUNTRY,
plan=SELECT
COUNT(*) AS __C0_0
FROM PUBLIC.CITY C__Z0
/* PUBLIC."_key_PK" */
INNER JOIN PUBLIC.COUNTRY CC__Z1
/* batched:broadcast PUBLIC."_key_PK_proxy" */
ON 1=1
WHERE CC__Z1.COUNTRY_ID <> C__Z0.COUNTRY_ID] (state=50000,code=1)
I guess this is expected behavior since you can only join on equality to an
indexed field when going distributed.
However, you can just ditch collocation and compare results:
sqlline> !connect jdbc:ignite:thin://localhost
0: jdbc:ignite:thin://localhost> CREATE TABLE Country (
. . . . . . . . . . . . . . . .> country_id INT(10),
. . . . . . . . . . . . . . . .> country_name CHAR(30),
. . . . . . . . . . . . . . . .> Continent CHAR(30),
. . . . . . . . . . . . . . . .> PRIMARY KEY (country_id)
. . . . . . . . . . . . . . . .> ) WITH "template=partitioned, backups=1";
0: jdbc:ignite:thin://localhost> CREATE TABLE City (
. . . . . . . . . . . . . . . .> city_id INT(15),
. . . . . . . . . . . . . . . .> country_id INT(10),
. . . . . . . . . . . . . . . .> city_name CHAR(50),
. . . . . . . . . . . . . . . .> Dist CHAR(20),
. . . . . . . . . . . . . . . .> PRIMARY KEY (city_id,country_id)
. . . . . . . . . . . . . . . .> ) WITH "template=partitioned, backups=1";
... INSERTs snip ...
0: jdbc:ignite:thin://localhost> !set outputFormat vertical
0: jdbc:ignite:thin://localhost> select count(*) from City c join Country
cc on cc.country_id = c.country_id ;
*COUNT(*) 346*
0: jdbc:ignite:thin://localhost> SELECT COUNT(*) FROM City;
COUNT(*) 1000
0: jdbc:ignite:thin://localhost> SELECT COUNT(*) FROM Country;
COUNT(*) 3
0: jdbc:ignite:thin://localhost> !connect
jdbc:ignite:thin://localhost?distributedJoins=true
1: jdbc:ignite:thin://localhost> select count(*) from City c join Country
cc on cc.country_id = c.country_id ;
*COUNT(*) 1000*
As you can see, as soon as we remove affinity_key clause, this query will
only work properly with distributed joins.
Regards,
--
Ilya Kasnacheev
ср, 27 мар. 2019 г. в 17:06, Nilesh K <ng...@gmail.com>:
> Hello Ilya Kasnacheev,
>
> Sure. Here is complete script :
>
>
> CREATE TABLE Country (
> country_id INT(10),
> country_name CHAR(30),
> Continent CHAR(30),
> PRIMARY KEY (country_id)
> ) WITH "template=partitioned, backups=1";
>
>
> CREATE TABLE City (
> city_id INT(15),
> country_id INT(10),
> city_name CHAR(50),
> Dist CHAR(20),
> PRIMARY KEY (city_id,country_id)
> ) WITH "template=partitioned, backups=1, affinityKey=country_id";
>
>
> insert into Country values('101','Russia','Russia');
> insert into Country values('102','India','Asia');
> insert into Country values('103','United States','America');
>
>
> insert into City values('12554105',101,'CITY_00000000012554105','SNZa');
> insert into City values('20467',101,'CITY_00000003720467','SN');
> insert into City values('10498',101,'CITY_00000003710498','SNZa');
> insert into City values('13617',101,'CITY_00000003713617','SNZb');
> insert into City values('13628',101,'CITY_00000003713628','SNZd');
> insert into City values('10502',101,'CITY_00000004610502','SN');
> insert into City values('703166',101,'CITY_000000046703166','1');
> insert into City values('13656',101,'CITY_00000007313656','SN');
> insert into City values('10507',101,'CITY_00000007310507','SNZa');
> insert into City values('13620',101,'CITY_00000007313620','SNZc');
> insert into City values('13629',101,'CITY_00000007313629','SNZe');
> insert into City values('10508',101,'CITY_00000009110508','SN');
> insert into City values('47403',101,'CITY_00000009147403','1');
> insert into City values('16774',101,'CITY_00000011616774','SN');
> insert into City values('16773',101,'CITY_00000012516773','SN');
> insert into City values('16778',101,'CITY_00000014316778','SN');
> insert into City values('16779',101,'CITY_00000016116779','SN');
> insert into City values('734192',101,'CITY_000000161734192','1');
> insert into City values('699080',101,'CITY_000000161699080','01Za');
> insert into City values('16781',101,'CITY_00000017016781','SN');
> insert into City values('16780',101,'CITY_00000018916780','SN');
> insert into City values('16802',101,'CITY_00000019816802','SN');
> insert into City values('16803',101,'CITY_00000020416803','SN');
> insert into City values('457688',101,'CITY_000000204457688','1');
> insert into City values('16806',101,'CITY_00000021316806','SN');
> insert into City values('16809',101,'CITY_00000023116809','SN');
> insert into City values('16815',101,'CITY_00000024016815','SN');
> insert into City values('6957',101,'CITY_0000053886957','SN');
> insert into City values('6747',101,'CITY_0000053886747','SNZa');
> insert into City values('21048',101,'CITY_00000538821048','SNZj');
> insert into City values('21058',101,'CITY_00000538821058','01Za');
> insert into City values('21068',101,'CITY_00000545821068','SN');
> insert into City values('6749',101,'CITY_0000054586749','SNZa');
> insert into City values('6780',101,'CITY_0000054586780','SNZb');
> insert into City values('113520',101,'CITY_000005467113520','SN');
> insert into City values('6750',101,'CITY_0000054676750','SNZa');
> insert into City values('6820',101,'CITY_0000054676820','SNZb');
> insert into City values('21066',101,'CITY_00000546721066','SNZc');
> insert into City values('6751',101,'CITY_0000054766751','SNZa');
> insert into City values('6821',101,'CITY_0000054766821','SNAb');
> insert into City values('113679',101,'CITY_000005485113679','SN');
> insert into City values('6822',101,'CITY_0000054856822','SNAb');
> insert into City values('6916',101,'CITY_0000054856916','SNAc');
> insert into City values('21064',101,'CITY_00000548521064','SNAd');
> insert into City values('23992',101,'CITY_00000548523992','SNAe');
> insert into City values('223623',101,'CITY_000005485223623','1');
> insert into City values('113562',101,'CITY_000005494113562','SN');
> insert into City values('6823',101,'CITY_0000054946823','SNAb');
> insert into City values('6840',101,'CITY_0000054946840','SNAc');
> insert into City values('21070',101,'CITY_00000549421070','SNAd');
> insert into City values('21859',101,'CITY_00000549421859','SNAe');
> insert into City values('50388',101,'CITY_00000549450388','SNAf');
> insert into City values('122190',101,'CITY_000005494122190','1');
> insert into City values('114520',101,'CITY_000005494114520','01Aa');
> insert into City values('118632',101,'CITY_000005494118632','01Ab');
> insert into City values('121228',101,'CITY_000005494121228','01Ac');
> insert into City values('125075',101,'CITY_000005494125075','2');
> insert into City values('7774147',101,'CITY_0000054947774147','3');
> insert into City values('7764624',101,'CITY_0000054947764624','03Aa');
> insert into City values('8002672',101,'CITY_0000054948002672','4');
> insert into City values('8153942',101,'CITY_0000054948153942','5');
> insert into City values('21857',101,'CITY_00000576821857','SN');
> insert into City values('6837',101,'CITY_0000057686837','SNAc');
> insert into City values('21071',101,'CITY_00000576821071','SNAd');
> insert into City values('8153946',101,'CITY_0000057688153946','1');
> insert into City values('8153949',101,'CITY_0000057688153949','2');
> insert into City values('50701',101,'CITY_00000578650701','SN');
> insert into City values('6825',101,'CITY_0000057866825','SNAb');
> insert into City values('6936',101,'CITY_0000057866936','SNAc');
> insert into City values('21062',101,'CITY_00000578621062','SNAd');
> insert into City values('21854',101,'CITY_00000578621854','SNBe');
> insert into City values('49691',101,'CITY_00000578649691','SNBf');
> insert into City values('50368',101,'CITY_00000578650368','SNBg');
> insert into City values('50673',101,'CITY_00000578650673','SNBh');
> insert into City values('1189982',101,'CITY_0000057861189982','1');
> insert into City values('50699',101,'CITY_00000579550699','SN');
> insert into City values('6826',101,'CITY_0000057956826','SNBb');
> insert into City values('6941',101,'CITY_0000057956941','SNBc');
> insert into City values('21060',101,'CITY_00000579521060','SNBd');
> insert into City values('21855',101,'CITY_00000579521855','SNBe');
> insert into City values('49690',101,'CITY_00000579549690','SNBf');
> insert into City values('50369',101,'CITY_00000579550369','SNBg');
> insert into City values('50484',101,'CITY_00000579550484','SNBh');
> insert into City values('50675',101,'CITY_00000579550675','SNBi');
> insert into City values('1190096',101,'CITY_0000057951190096','1');
> insert into City values('113616',101,'CITY_000005810113616','SN');
> insert into City values('6949',101,'CITY_0000058106949','SNBd');
> insert into City values('21043',101,'CITY_00000581021043','SNBe');
> insert into City values('105484',101,'CITY_000005865105484','SN');
> insert into City values('6951',101,'CITY_0000058656951','SNBc');
> insert into City values('21046',101,'CITY_00000586521046','SNCd');
> insert into City values('24635',101,'CITY_00000586524635','SNCe');
> insert into City values('46650',101,'CITY_00000586546650','SNCf');
> insert into City values('9590616',101,'CITY_0000058659590616','1');
> insert into City values('21084',101,'CITY_00000608621084','SN');
> insert into City values('21082',101,'CITY_00000609521082','SN');
> insert into City values('7397166',101,'CITY_0000060957397166','1');
> insert into City values('21371',101,'CITY_00000615621371','SNCd');
> insert into City values('21373',101,'CITY_00000617421373','SNCd');
> insert into City values('24237',101,'CITY_00000617424237','SNCe');
> insert into City values('24660',101,'CITY_00000617424660','SNCf');
> insert into City values('21703',101,'CITY_00000619221703','SN');
> insert into City values('21734',101,'CITY_00000620821734','SN');
> insert into City values('6816',101,'CITY_0000062086816','SNCb');
> insert into City values('7020',101,'CITY_0000062087020','SNCc');
> insert into City values('21041',101,'CITY_00000620821041','SNCd');
> insert into City values('6065581',101,'CITY_0000062086065581','1');
> insert into City values('21088',101,'CITY_00000624421088','SN');
> insert into City values('987784',101,'CITY_000006262987784','SN');
> insert into City values('21080',101,'CITY_00000626221080','SNCf');
> insert into City values('21811',101,'CITY_00000626221811','SNCg');
> insert into City values('989894',101,'CITY_000006262989894','1');
> insert into City values('7011',101,'CITY_0000063057011','SN');
> insert into City values('21898',101,'CITY_00000652721898','SN');
> insert into City values('6946',101,'CITY_0000065276946','SNCc');
> insert into City values('21858',101,'CITY_00000652721858','SNCe');
> insert into City values('24637',101,'CITY_00000653624637','SN');
> insert into City values('21092',101,'CITY_00000653621092','SNCc');
> insert into City values('21093',101,'CITY_00000655421093','SNCc');
> insert into City values('21372',101,'CITY_00000656321372','SNCc');
> insert into City values('39367',101,'CITY_00000656339367','SNCf');
> insert into City values('21086',101,'CITY_00000663321086','SN');
> insert into City values('6852',101,'CITY_0000067496852','SNCa');
> insert into City values('7109',101,'CITY_0000068557109','SNCb');
> insert into City values('7041',101,'CITY_0000078637041','SN');
> insert into City values('42730',101,'CITY_00000786342730','01Ca');
> insert into City values('6995',101,'CITY_0000080846995','SN');
> insert into City values('13553',101,'CITY_00000808413553','1');
> insert into City values('19104',101,'CITY_00000808419104','2');
> insert into City values('13586',101,'CITY_00000809313586','SN');
> insert into City values('7132',101,'CITY_0000080937132','SNCb');
> insert into City values('7671',101,'CITY_0000080937671','SNCd');
> insert into City values('19058',101,'CITY_00000809319058','1');
> insert into City values('13589',101,'CITY_00000810913589','SN');
> insert into City values('6997',101,'CITY_0000081096997','SNCa');
> insert into City values('19110',101,'CITY_00000810919110','1');
> insert into City values('6998',101,'CITY_0000081186998','SN');
> insert into City values('6999',101,'CITY_0000081276999','SN');
> insert into City values('7000',101,'CITY_0000081367000','SN');
> insert into City values('13607',101,'CITY_00000814513607','SN');
> insert into City values('13588',101,'CITY_00000814513588','SNCb');
> insert into City values('19088',101,'CITY_00000814519088','1');
> insert into City values('7002',101,'CITY_0000081547002','SN');
> insert into City values('7003',101,'CITY_0000081637003','SN');
> insert into City values('7004',101,'CITY_0000081727004','SN');
> insert into City values('13559',101,'CITY_00000817213559','1');
> insert into City values('13610',101,'CITY_00000817213610','2');
> insert into City values('13587',101,'CITY_00000817213587','02Ca');
> insert into City values('7005',101,'CITY_0000081817005','SN');
> insert into City values('7006',101,'CITY_0000081907006','SN');
> insert into City values('7007',101,'CITY_0000082067007','SN');
> insert into City values('13571',101,'CITY_00000821513571','SN');
> insert into City values('7008',101,'CITY_0000082157008','SNCa');
> insert into City values('7009',101,'CITY_0000082247009','SN');
> insert into City values('7056',101,'CITY_0000082607056','SNCc');
> insert into City values('13572',101,'CITY_00000827913572','SN');
> insert into City values('7024',101,'CITY_0000082797024','SNCa');
> insert into City values('7084',101,'CITY_0000082797084','SNCb');
> insert into City values('13581',101,'CITY_00000827913581','1');
> insert into City values('13579',101,'CITY_00000827913579','01Cb');
> insert into City values('33875',101,'CITY_00000827933875','2');
> insert into City values('7042',101,'CITY_0000082977042','SN');
> insert into City values('7078',101,'CITY_0000083127078','SN');
> insert into City values('13582',101,'CITY_00000831213582','1');
> insert into City values('33874',101,'CITY_00000831233874','2');
> insert into City values('7043',101,'CITY_0000083217043','SNCb');
> insert into City values('7044',101,'CITY_0000083307044','SN');
> insert into City values('7030',101,'CITY_0000083497030','SN');
> insert into City values('13550',101,'CITY_00000834913550','1');
> insert into City values('7529',101,'CITY_0000083497529','01Ca');
> insert into City values('13551',101,'CITY_00000834913551','2');
> insert into City values('7104',101,'CITY_0000083677104','SN');
> insert into City values('7040',101,'CITY_0000083677040','SNCb');
> insert into City values('7045',101,'CITY_0000083767045','SN');
> insert into City values('303450',101,'CITY_000008385303450','SN');
> insert into City values('7034',101,'CITY_0000083857034','SNCa');
> insert into City values('7046',101,'CITY_0000083857046','SNCb');
> insert into City values('7072',101,'CITY_0000083857072','SNEc');
> insert into City values('7442',101,'CITY_0000083947442','SN');
> insert into City values('7115',101,'CITY_0000083947115','SNEb');
> insert into City values('7698',101,'CITY_0000084197698','SN');
> insert into City values('7037',101,'CITY_0000084197037','SNEa');
> insert into City values('19113',101,'CITY_00000844619113','SN');
> insert into City values('7039',101,'CITY_0000084467039','SNEa');
> insert into City values('7425',101,'CITY_0000084467425','SNEb');
> insert into City values('7049',101,'CITY_0000084827049','SN');
> insert into City values('7139',101,'CITY_0000084917139','SN');
> insert into City values('7051',101,'CITY_0000084917051','SNEa');
> insert into City values('13548',101,'CITY_00000849113548','1');
> insert into City values('7527',101,'CITY_0000084917527','01Ea');
> insert into City values('7052',101,'CITY_0000085077052','SN');
> insert into City values('7053',101,'CITY_0000085167053','SN');
> insert into City values('7447',101,'CITY_0000085347447','SN');
> insert into City values('7057',101,'CITY_0000085347057','SNEa');
> insert into City values('7537',101,'CITY_0000085347537','1');
> insert into City values('7592',101,'CITY_0000085347592','2');
> insert into City values('7580',101,'CITY_0000085347580','02Ea');
> insert into City values('7647',101,'CITY_0000085347647','3');
> insert into City values('13557',101,'CITY_00000854313557','SN');
> insert into City values('7211',101,'CITY_0000085437211','SNEc');
> insert into City values('13568',101,'CITY_00000854313568','1');
> insert into City values('7137',101,'CITY_0000087927137','SNEb');
> insert into City values('21111',101,'CITY_00000879221111','SNEc');
> insert into City values('21925',101,'CITY_00000879221925','SNEd');
> insert into City values('21947',101,'CITY_00000879221947','SNEe');
> insert into City values('1311335',101,'CITY_0000088531311335','SNEb');
> insert into City values('7144',101,'CITY_0000090477144','SNEa');
> insert into City values('21103',101,'CITY_00000904721103','SNEb');
> insert into City values('7147',101,'CITY_0000090837147','SNEa');
> insert into City values('21116',101,'CITY_00000908321116','SNEb');
> insert into City values('21944',101,'CITY_00000908321944','SNEc');
> insert into City values('7206',101,'CITY_0000090927206','SN');
> insert into City values('7148',101,'CITY_0000090927148','SNEa');
> insert into City values('7205',101,'CITY_0000091177205','SN');
> insert into City values('7150',101,'CITY_0000091177150','SNEa');
> insert into City values('7156',101,'CITY_0000091357156','SNEa');
> insert into City values('7154',101,'CITY_0000091447154','SN');
> insert into City values('7163',101,'CITY_0000092327163','SNEa');
> insert into City values('21101',101,'CITY_00000923221101','SNEb');
> insert into City values('7165',101,'CITY_0000092507165','SNEa');
> insert into City values('7196',101,'CITY_0000092697196','SNEb');
> insert into City values('21114',101,'CITY_00000926921114','SNEc');
> insert into City values('21917',101,'CITY_00000926921917','SNEd');
> insert into City values('7167',101,'CITY_0000092787167','SN');
> insert into City values('7168',101,'CITY_0000092877168','SNEa');
> insert into City values('7169',101,'CITY_0000092967169','SNEa');
> insert into City values('7204',101,'CITY_0000093027204','SN');
> insert into City values('7170',101,'CITY_0000093027170','SNEa');
> insert into City values('7747',101,'CITY_0000093397747','SN');
> insert into City values('7173',101,'CITY_0000093397173','SNZa');
> insert into City values('30141',101,'CITY_00000933930141','1');
> insert into City values('7740',101,'CITY_0000093757740','SNZc');
> insert into City values('7180',101,'CITY_0000094097180','SN');
> insert into City values('7181',101,'CITY_0000094187181','SN');
> insert into City values('7182',101,'CITY_0000094277182','SN');
> insert into City values('7186',101,'CITY_0000094727186','SN');
> insert into City values('7187',101,'CITY_0000094817187','SN');
> insert into City values('7188',101,'CITY_0000094907188','SN');
> insert into City values('7197',101,'CITY_0000095517197','SNZa');
> insert into City values('7208',101,'CITY_0000095977208','SN');
> insert into City values('7213',101,'CITY_0000096307213','SNZa');
> insert into City values('21105',101,'CITY_00000963021105','SNZb');
> insert into City values('7216',101,'CITY_0000096677216','SNZa');
> insert into City values('21107',101,'CITY_00000966721107','SNZb');
> insert into City values('7502',101,'CITY_0000096947502','SN');
> insert into City values('7219',101,'CITY_0000096947219','SNZa');
> insert into City values('7220',101,'CITY_0000097197220','SNZa');
> insert into City values('21118',101,'CITY_00000971921118','SNZb');
> insert into City values('24083',101,'CITY_00000971924083','SNZc');
> insert into City values('7238',101,'CITY_0000098987238','SNZa');
> insert into City values('21133',101,'CITY_00000989821133','SNZb');
> insert into City values('24402',101,'CITY_00000992224402','SN');
> insert into City values('7242',101,'CITY_0000099227242','SNZa');
> insert into City values('21110',101,'CITY_00000992221110','SNZb');
> insert into City values('21940',101,'CITY_00000992221940','SNZc');
> insert into City values('44586',101,'CITY_00000996844586','SN');
> insert into City values('7246',101,'CITY_0000099687246','SNZa');
> insert into City values('21430',101,'CITY_00000996821430','SNZb');
> insert into City values('5910180',101,'CITY_0000099685910180','1');
> insert into City values('44576',101,'CITY_00001000744576','SN');
> insert into City values('7255',101,'CITY_0000100077255','SNZa');
> insert into City values('21431',101,'CITY_00001000721431','SNZb');
> insert into City values('22702',101,'CITY_00001000722702','SNZc');
> insert into City values('23545',101,'CITY_00001000723545','SNZd');
> insert into City values('7742',101,'CITY_0000100257742','SN');
> insert into City values('7261',101,'CITY_0000100257261','SNZa');
> insert into City values('7266',101,'CITY_0000101047266','SN');
> insert into City values('9018',101,'CITY_0000101049018','1');
> insert into City values('9137',101,'CITY_0000101049137','2');
> insert into City values('7271',101,'CITY_0000101597271','SNZa');
> insert into City values('7273',101,'CITY_0000101777273','SNZa');
> insert into City values('7300',101,'CITY_0000104057300','SN');
> insert into City values('7301',101,'CITY_0000104147301','SN');
> insert into City values('7659',101,'CITY_0000105027659','1');
> insert into City values('8546',101,'CITY_0000105028546','2');
> insert into City values('7321',101,'CITY_0000105757321','SN');
> insert into City values('20518',101,'CITY_00001057520518','1');
> insert into City values('13157',101,'CITY_00001057513157','01Za');
> insert into City values('20569',101,'CITY_00001057520569','2');
> insert into City values('24653',101,'CITY_00001059324653','SN');
> insert into City values('21595',101,'CITY_00001059321595','SNZf');
> insert into City values('22690',101,'CITY_00001061822690','SN');
> insert into City values('7350',101,'CITY_0000106187350','SNZb');
> insert into City values('21433',101,'CITY_00001061821433','SNZc');
> insert into City values('46953',101,'CITY_00001061846953','1');
> insert into City values('45551',101,'CITY_00001061845551','01Za');
> insert into City values('46828',101,'CITY_00001061846828','01Zb');
> insert into City values('46832',101,'CITY_00001061846832','01Zc');
> insert into City values('978719',101,'CITY_000010618978719','2');
> insert into City values('1087603',101,'CITY_0000106181087603','3');
> insert into City values('2739779',101,'CITY_0000106182739779','4');
> insert into City values('5708024',101,'CITY_0000106185708024','5');
> insert into City values('5708057',101,'CITY_0000106185708057','6');
> insert into City values('5708101',101,'CITY_0000106185708101','7');
> insert into City values('7339',101,'CITY_0000106727339','SNZa');
> insert into City values('7343',101,'CITY_0000107247343','SN');
> insert into City values('7352',101,'CITY_0000107517352','SN');
> insert into City values('7345',101,'CITY_0000107517345','SNZa');
> insert into City values('7353',101,'CITY_0000108037353','SNZa');
> insert into City values('21435',101,'CITY_00001080321435','SNZb');
> insert into City values('7365',101,'CITY_0000109197365','SNZa');
> insert into City values('360214',101,'CITY_000010937360214','SN');
> insert into City values('1879683',101,'CITY_0000109371879683','1');
> insert into City values('7368',101,'CITY_0000109467368','SNZa');
> insert into City values('721432',101,'CITY_000010955721432','SNZb');
> insert into City values('360223',101,'CITY_000010964360223','SN');
> insert into City values('7371',101,'CITY_0000109737371','SN');
> insert into City values('1879671',101,'CITY_0000109731879671','1');
> insert into City values('1879622',101,'CITY_0000109731879622','01Za');
> insert into City values('14400',101,'CITY_00001099114400','SN');
> insert into City values('14403',101,'CITY_00001099114403','1');
> insert into City values('14497',101,'CITY_00001099114497','2');
> insert into City values('7376',101,'CITY_0000110247376','SN');
> insert into City values('18170',101,'CITY_00001102418170','1');
> insert into City values('8091',101,'CITY_0000110428091','SNZb');
> insert into City values('8438',101,'CITY_0000110428438','SNZe');
> insert into City values('8525',101,'CITY_0000110428525','SNZf');
> insert into City values('21627',101,'CITY_00001104221627','SNZg');
> insert into City values('7389',101,'CITY_0000111947389','SN');
> insert into City values('20884',101,'CITY_00001119420884','1');
> insert into City values('23881',101,'CITY_00001119423881','2');
> insert into City values('23340',101,'CITY_00001119423340','02Za');
> insert into City values('7394',101,'CITY_0000112287394','SNZa');
> insert into City values('21438',101,'CITY_00001122821438','SNZb');
> insert into City values('7396',101,'CITY_0000112557396','SN');
> insert into City values('23924',101,'CITY_00001125523924','1');
> insert into City values('20886',101,'CITY_00001125520886','01Za');
> insert into City values('23337',101,'CITY_00001125523337','01Zb');
> insert into City values('2280111',101,'CITY_0000112552280111','2');
> insert into City values('21441',101,'CITY_00001126421441','SN');
> insert into City values('7397',101,'CITY_0000112647397','SNZa');
> insert into City values('7398',101,'CITY_0000112737398','SN');
> insert into City values('23923',101,'CITY_00001127323923','1');
> insert into City values('20888',101,'CITY_00001127320888','01Za');
> insert into City values('23336',101,'CITY_00001127323336','01Zb');
> insert into City values('7400',101,'CITY_0000112917400','SN');
> insert into City values('20880',101,'CITY_00001129120880','1');
> insert into City values('20893',101,'CITY_00001129120893','2');
> insert into City values('23339',101,'CITY_00001129123339','3');
> insert into City values('2926114',101,'CITY_0000112912926114','4');
> insert into City values('4673798',101,'CITY_0000112914673798','5');
> insert into City values('7402',101,'CITY_0000113167402','SN');
> insert into City values('20891',101,'CITY_00001131620891','01Za');
> insert into City values('23322',101,'CITY_00001131623322','01Zb');
> insert into City values('152495',101,'CITY_000011316152495','01Zc');
> insert into City values('23502',101,'CITY_00001134323502','SN');
> insert into City values('7426',101,'CITY_0000113437426','SNZb');
> insert into City values('21502',101,'CITY_00001134321502','SNZc');
> insert into City values('22742',101,'CITY_00001134322742','SNZd');
> insert into City values('7413',101,'CITY_0000113987413','SNZa');
> insert into City values('7423',101,'CITY_0000114957423','SNZa');
> insert into City values('21492',101,'CITY_00001160821492','SN');
> insert into City values('7453',101,'CITY_0000116087453','SNZa');
> insert into City values('1683111',101,'CITY_0000116081683111','1');
> insert into City values('5708022',101,'CITY_0000116085708022','2');
> insert into City values('5708103',101,'CITY_0000116085708103','3');
> insert into City values('6868077',101,'CITY_0000116086868077','4');
> insert into City values('24652',101,'CITY_00001162624652','SN');
> insert into City values('7464',101,'CITY_0000116267464','SNZa');
> insert into City values('21505',101,'CITY_00001162621505','SNZb');
> insert into City values('7466',101,'CITY_0000116447466','SNZa');
> insert into City values('21509',101,'CITY_00001164421509','SNZb');
> insert into City values('7542',101,'CITY_0000116717542','SN');
> insert into City values('7509',101,'CITY_0000116717509','SNZb');
> insert into City values('7530',101,'CITY_0000116717530','SNZc');
> insert into City values('7884',101,'CITY_0000116717884','1');
> insert into City values('8202',101,'CITY_0000116718202','2');
> insert into City values('8369',101,'CITY_0000116718369','3');
> insert into City values('8536',101,'CITY_0000116718536','4');
> insert into City values('8020',101,'CITY_0000116808020','SNZb');
> insert into City values('7478',101,'CITY_0000117697478','SNZa');
> insert into City values('45288',101,'CITY_00001177845288','SN');
> insert into City values('7479',101,'CITY_0000117787479','SNZa');
> insert into City values('21511',101,'CITY_00001181121511','SN');
> insert into City values('7515',101,'CITY_0000118117515','SNZb');
> insert into City values('46937',101,'CITY_00001181146937','1');
> insert into City values('6008866',101,'CITY_0000118116008866','02Za');
> insert into City values('6013938',101,'CITY_0000118116013938','02Zb');
> insert into City values('6057917',101,'CITY_0000118116057917','02Zc');
> insert into City values('7531',101,'CITY_0000119187531','SN');
> insert into City values('7511',101,'CITY_0000119187511','SNZa');
> insert into City values('7520',101,'CITY_0000119367520','SNZa');
> insert into City values('7521',101,'CITY_0000119457521','SNZa');
> insert into City values('7532',101,'CITY_0000119637532','SN');
> insert into City values('7523',101,'CITY_0000119637523','SNZa');
> insert into City values('7525',101,'CITY_0000119727525','SN');
> insert into City values('7552',101,'CITY_0000119727552','1');
> insert into City values('7882',101,'CITY_0000119727882','2');
> insert into City values('7907',101,'CITY_0000119727907','3');
> insert into City values('8357',101,'CITY_0000119728357','4');
> insert into City values('7526',101,'CITY_0000119817526','SN');
> insert into City values('8169',101,'CITY_0000119818169','1');
> insert into City values('7528',101,'CITY_0000119907528','SN');
> insert into City values('21514',101,'CITY_00001204121514','SN');
> insert into City values('7751',101,'CITY_0000120417751','SNZb');
> insert into City values('46941',101,'CITY_00001204146941','1');
> insert into City values('7548',101,'CITY_0000120507548','SN');
> insert into City values('7564',101,'CITY_0000121577564','SN');
> insert into City values('7894',101,'CITY_0000124587894','SNZc');
> insert into City values('7896',101,'CITY_0000125377896','SNZb');
> insert into City values('7956',101,'CITY_0000125647956','SNZb');
> insert into City values('7941',101,'CITY_0000125917941','SNZb');
> insert into City values('7942',101,'CITY_0000126077942','SNZb');
> insert into City values('7968',101,'CITY_0000126167968','SNZb');
> insert into City values('7736',101,'CITY_0000126987736','SN');
> insert into City values('122085',101,'CITY_000012704122085','SN');
> insert into City values('7738',101,'CITY_0000127047738','SNZa');
> insert into City values('9316',101,'CITY_0000127049316','SNZb');
> insert into City values('122095',101,'CITY_000012731122095','SN');
> insert into City values('7748',101,'CITY_0000127317748','SNZa');
> insert into City values('7749',101,'CITY_0000127407749','SN');
> insert into City values('21535',101,'CITY_00001276821535','SN');
> insert into City values('7753',101,'CITY_0000127687753','SNZa');
> insert into City values('7757',101,'CITY_0000127957757','SN');
> insert into City values('730092',101,'CITY_000012795730092','01Za');
> insert into City values('7759',101,'CITY_0000128107759','SN');
> insert into City values('7760',101,'CITY_0000128297760','SN');
> insert into City values('21539',101,'CITY_00001284721539','SN');
> insert into City values('7762',101,'CITY_0000128477762','SNZa');
> insert into City values('21621',101,'CITY_00001300421621','SN');
> insert into City values('7774',101,'CITY_0000130047774','SNZa');
> insert into City values('8253',101,'CITY_0000130048253','SNZb');
> insert into City values('5943619',101,'CITY_0000130045943619','01Za');
> insert into City values('7777',101,'CITY_0000130407777','SN');
> insert into City values('739681',101,'CITY_000013040739681','01Za');
> insert into City values('21542',101,'CITY_00001336921542','SN');
> insert into City values('7809',101,'CITY_0000133697809','SNZa');
> insert into City values('5707563',101,'CITY_0000133695707563','1');
> insert into City values('5667447',101,'CITY_0000133695667447','01Za');
> insert into City values('5708105',101,'CITY_0000133695708105','2');
> insert into City values('7810',101,'CITY_0000133787810','SNZa');
> insert into City values('21545',101,'CITY_00001348421545','SN');
> insert into City values('7836',101,'CITY_0000134847836','SNZa');
> insert into City values('7838',101,'CITY_0000135097838','SN');
> insert into City values('24659',101,'CITY_00001351824659','SN');
> insert into City values('7839',101,'CITY_0000135187839','SNZa');
> insert into City values('21548',101,'CITY_00001351821548','SNZb');
> insert into City values('22938',101,'CITY_00001351822938','SNZc');
> insert into City values('10823731',101,'CITY_00001351810823731','1');
> insert into City values('21551',101,'CITY_00001355421551','SN');
> insert into City values('7843',101,'CITY_0000135547843','SNZa');
> insert into City values('21554',101,'CITY_00001358121554','SN');
> insert into City values('7845',101,'CITY_0000135817845','SNZa');
> insert into City values('7849',101,'CITY_0000136157849','SNZa');
> insert into City values('21557',101,'CITY_00001362421557','SN');
> insert into City values('7850',101,'CITY_0000136247850','SNZa');
> insert into City values('22875',101,'CITY_00001364222875','SN');
> insert into City values('7852',101,'CITY_0000136427852','SNZa');
> insert into City values('21559',101,'CITY_00001364221559','SNZb');
> insert into City values('7859',101,'CITY_0000137037859','SN');
> insert into City values('733853',101,'CITY_000013703733853','01Za');
> insert into City values('7861',101,'CITY_0000137217861','SN');
> insert into City values('733809',101,'CITY_000013721733809','01Za');
> insert into City values('7863',101,'CITY_0000137497863','SN');
> insert into City values('7865',101,'CITY_0000137677865','SN');
> insert into City values('733748',101,'CITY_000013767733748','01Za');
> insert into City values('7866',101,'CITY_0000137767866','SN');
> insert into City values('733758',101,'CITY_000013776733758','01Za');
> insert into City values('7868',101,'CITY_0000137857868','SN');
> insert into City values('643516',101,'CITY_000013785643516','01Za');
> insert into City values('21563',101,'CITY_00001382821563','SN');
> insert into City values('7872',101,'CITY_0000138287872','SNZa');
> insert into City values('21565',101,'CITY_00001389121565','SN');
> insert into City values('7885',101,'CITY_0000138917885','SNZa');
> insert into City values('7895',101,'CITY_0000139437895','SNZa');
> insert into City values('21567',101,'CITY_00001394321567','SNZb');
> insert into City values('7947',101,'CITY_0000139707947','SN');
> insert into City values('7899',101,'CITY_0000139707899','SNZa');
> insert into City values('202846',101,'CITY_000013970202846','1');
> insert into City values('266065',101,'CITY_000013970266065','2');
> insert into City values('21570',101,'CITY_00001398921570','SN');
> insert into City values('7900',101,'CITY_0000139897900','SNZa');
> insert into City values('3297517',101,'CITY_0000139893297517','1');
> insert into City values('5708020',101,'CITY_0000139895708020','2');
> insert into City values('5708109',101,'CITY_0000139895708109','3');
> insert into City values('7905',101,'CITY_0000140037905','SNZa');
> insert into City values('21572',101,'CITY_00001400321572','SNZb');
> insert into City values('7909',101,'CITY_0000140307909','SNZa');
> insert into City values('21574',101,'CITY_00001403021574','SNZb');
> insert into City values('7912',101,'CITY_0000140587912','SNZa');
> insert into City values('7916',101,'CITY_0000140857916','SNZa');
> insert into City values('21576',101,'CITY_00001408521576','SNZb');
> insert into City values('7949',101,'CITY_0000140947949','SN');
> insert into City values('7917',101,'CITY_0000140947917','SNZa');
> insert into City values('202831',101,'CITY_000014094202831','1');
> insert into City values('23847',101,'CITY_00001417323847','SN');
> insert into City values('7946',101,'CITY_0000141737946','SNZb');
> insert into City values('21578',101,'CITY_00001417321578','SNZc');
> insert into City values('7950',101,'CITY_0000142347950','SN');
> insert into City values('7938',101,'CITY_0000142347938','SNZa');
> insert into City values('51438',101,'CITY_00001423451438','1');
> insert into City values('202840',101,'CITY_000014234202840','2');
> insert into City values('7986',101,'CITY_0000142527986','SNZb');
> insert into City values('7951',101,'CITY_0000142617951','SN');
> insert into City values('7944',101,'CITY_0000142617944','SNZa');
> insert into City values('24188',101,'CITY_00001430424188','SN');
> insert into City values('7954',101,'CITY_0000143047954','SNZa');
> insert into City values('21581',101,'CITY_00001430421581','SNZb');
> insert into City values('23851',101,'CITY_00001434023851','SN');
> insert into City values('7958',101,'CITY_0000143407958','SNZa');
> insert into City values('11221',102,'CITY_00000006411221','SN');
> insert into City values('32417',102,'CITY_00000006432417','1');
> insert into City values('101980',102,'CITY_000000064101980','2');
> insert into City values('498384',102,'CITY_000000064498384','3');
> insert into City values('1022956',102,'CITY_0000000641022956','4');
> insert into City values('113710',102,'CITY_000006572113710','SN');
> insert into City values('157284',102,'CITY_000006572157284','1');
> insert into City values('131894',102,'CITY_000006572131894','01Zc');
> insert into City values('223692',102,'CITY_000006572223692','2');
> insert into City values('360361',102,'CITY_000006572360361','3');
> insert into City values('1113393',102,'CITY_0000065721113393','4');
> insert into City values('1837552',102,'CITY_0000065721837552','5');
> insert into City values('2248350',102,'CITY_0000065722248350','6');
> insert into City values('7843924',102,'CITY_0000065727843924','7');
> insert into City values('6904400',102,'CITY_0000065726904400','07Za');
> insert into City values('7742941',102,'CITY_0000065727742941','07Zc');
> insert into City values('7742942',102,'CITY_0000065727742942','07Zd');
> insert into City values('7764627',102,'CITY_0000065727764627','07Ze');
> insert into City values('8153945',102,'CITY_0000065728153945','8');
> insert into City values('9590618',102,'CITY_0000065729590618','9');
> insert into City values('989911',102,'CITY_000006943989911','SN');
> insert into City values('988217',102,'CITY_000006943988217','SNZn');
> insert into City values('5710668',102,'CITY_0000069435710668','1');
> insert into City values('5710673',102,'CITY_0000069435710673','2');
> insert into City values('5712306',102,'CITY_0000069435712306','3');
> insert into City values('5721339',102,'CITY_0000069435721339','4');
> insert into City values('5727239',102,'CITY_0000069435727239','5');
> insert into City values('6621857',102,'CITY_0000069436621857','6');
> insert into City values('6869244',102,'CITY_0000069436869244','07Za');
> insert into City values('7081',102,'CITY_0000084737081','SN');
> insert into City values('42728',102,'CITY_00000847342728','01Za');
> insert into City values('21805',102,'CITY_00000873821805','SNZe');
> insert into City values('19225',102,'CITY_00000905619225','SN');
> insert into City values('7324',102,'CITY_0000090567324','SNZd');
> insert into City values('7615',102,'CITY_0000090567615','SNZh');
> insert into City values('34016',102,'CITY_00000905634016','1');
> insert into City values('34198',102,'CITY_00000905634198','2');
> insert into City values('34140',102,'CITY_00000932034140','SN');
> insert into City values('7312',102,'CITY_0000093207312','SNZd');
> insert into City values('7333',102,'CITY_0000093207333','SNZe');
> insert into City values('19231',102,'CITY_00000939319231','SN');
> insert into City values('7330',102,'CITY_0000093937330','SNZc');
> insert into City values('7331',102,'CITY_0000093937331','SNZd');
> insert into City values('33884',102,'CITY_00000939333884','1');
> insert into City values('33871',102,'CITY_00000939333871','01Za');
> insert into City values('13611',102,'CITY_00001044113611','SN');
> insert into City values('7320',102,'CITY_0000104417320','SNZc');
> insert into City values('7503',102,'CITY_0000104417503','SNZd');
> insert into City values('19219',102,'CITY_00001044119219','1');
> insert into City values('34006',102,'CITY_00001044134006','2');
> insert into City values('8128',102,'CITY_0000105488128','SNZb');
> insert into City values('11126',102,'CITY_00001054811126','SNZc');
> insert into City values('11437',102,'CITY_00001054811437','SNZd');
> insert into City values('20840',102,'CITY_00001054820840','SNZe');
> insert into City values('21135',102,'CITY_00001054821135','SNZf');
> insert into City values('21927',102,'CITY_00001054821927','SNZg');
> insert into City values('21948',102,'CITY_00001054821948','SNZh');
> insert into City values('24111',102,'CITY_00001054824111','SNZi');
> insert into City values('24401',102,'CITY_00001054824401','SNZj');
> insert into City values('69256',102,'CITY_00001054869256','SNZk');
> insert into City values('69797',102,'CITY_00001054869797','SNZl');
> insert into City values('69819',102,'CITY_00001054869819','SNZm');
> insert into City values('34197',102,'CITY_00001062734197','SN');
> insert into City values('7939',102,'CITY_0000107977939','SN');
> insert into City values('2066221',102,'CITY_0000107972066221','1');
> insert into City values('7550',102,'CITY_0000119097550','SN');
> insert into City values('7510',102,'CITY_0000119097510','SNZa');
> insert into City values('7524',102,'CITY_0000119097524','SNZb');
> insert into City values('7543',102,'CITY_0000119097543','SNZc');
> insert into City values('7551',102,'CITY_0000119097551','1');
> insert into City values('7898',102,'CITY_0000119097898','2');
> insert into City values('7883',102,'CITY_0000119097883','02Za');
> insert into City values('10821',102,'CITY_00001190910821','3');
> insert into City values('7920',102,'CITY_0000119097920','03Za');
> insert into City values('7927',102,'CITY_0000119097927','03Zb');
> insert into City values('10697',102,'CITY_00001190910697','03Zc');
> insert into City values('122196',102,'CITY_000012713122196','SN');
> insert into City values('7739',102,'CITY_0000127137739','SNZa');
> insert into City values('9303',102,'CITY_0000127139303','SNZc');
> insert into City values('122118',102,'CITY_000012713122118','SNZd');
> insert into City values('7864',102,'CITY_0000137587864','SN');
> insert into City values('7869',102,'CITY_0000137947869','SN');
> insert into City values('8177',102,'CITY_0000141828177','SN');
> insert into City values('8212',102,'CITY_0000141828212','1');
> insert into City values('8222',102,'CITY_0000141828222','2');
> insert into City values('8349',102,'CITY_0000141828349','3');
> insert into City values('8355',102,'CITY_0000141828355','4');
> insert into City values('8391',102,'CITY_0000141828391','5');
> insert into City values('8492',102,'CITY_0000141828492','6');
> insert into City values('8517',102,'CITY_0000141828517','7');
> insert into City values('8534',102,'CITY_0000141828534','8');
> insert into City values('7952',102,'CITY_0000142077952','SN');
> insert into City values('51502',102,'CITY_00001420751502','1');
> insert into City values('202865',102,'CITY_000014207202865','2');
> insert into City values('266066',102,'CITY_000014207266066','3');
> insert into City values('8460',102,'CITY_0000145088460','SN');
> insert into City values('739864',102,'CITY_000014508739864','01Za');
> insert into City values('45519',102,'CITY_00001472045519','SN');
> insert into City values('45302',102,'CITY_00001472045302','SNZaa');
> insert into City values('45214',102,'CITY_00001472045214','SNZz');
> insert into City values('48804',102,'CITY_00001472048804','1');
> insert into City values('46968',102,'CITY_00001472046968','01Zb');
> insert into City values('978683',102,'CITY_000014720978683','2');
> insert into City values('978632',102,'CITY_000014720978632','02Zb');
> insert into City values('5460781',102,'CITY_0000147205460781','3');
> insert into City values('5708031',102,'CITY_0000147205708031','4');
> insert into City values('5672178',102,'CITY_0000147205672178','04Za');
> insert into City values('5708064',102,'CITY_0000147205708064','5');
> insert into City values('5712309',102,'CITY_0000147205712309','6');
> insert into City values('5712311',102,'CITY_0000147205712311','7');
> insert into City values('5723959',102,'CITY_0000147205723959','8');
> insert into City values('5723962',102,'CITY_0000147205723962','9');
> insert into City values('5910185',102,'CITY_0000147205910185','10Za');
> insert into City values('5916481',102,'CITY_0000147205916481','10Zb');
> insert into City values('5930898',102,'CITY_0000147205930898','10Zc');
> insert into City values('5941638',102,'CITY_0000147205941638','10Zf');
> insert into City values('5967494',102,'CITY_0000147205967494','10Zg');
> insert into City values('6043059',102,'CITY_0000147206043059','10Zk');
> insert into City values('6057918',102,'CITY_0000147206057918','10Zl');
> insert into City values('6065579',102,'CITY_0000147206065579','10Zm');
> insert into City values('6865565',102,'CITY_0000147206865565','10Zo');
> insert into City values('8054',102,'CITY_0000150938054','SN');
> insert into City values('8149',102,'CITY_0000150938149','1');
> insert into City values('8090',102,'CITY_0000153588090','SN');
> insert into City values('8194',102,'CITY_0000153588194','1');
> insert into City values('8344',102,'CITY_0000153588344','2');
> insert into City values('8772',102,'CITY_0000153588772','3');
> insert into City values('9986',102,'CITY_0000153589986','4');
> insert into City values('10007',102,'CITY_00001535810007','5');
> insert into City values('10583',102,'CITY_00001535810583','6');
> insert into City values('10676',102,'CITY_00001535810676','07Za');
> insert into City values('8156',102,'CITY_0000157838156','SN');
> insert into City values('8213',102,'CITY_0000160298213','SN');
> insert into City values('17089',102,'CITY_00001602917089','02Za');
> insert into City values('8394',102,'CITY_0000165518394','SN');
> insert into City values('8585',102,'CITY_0000165518585','1');
> insert into City values('10008',102,'CITY_00001655110008','2');
> insert into City values('10022',102,'CITY_00001655110022','3');
> insert into City values('10596',102,'CITY_00001655110596','4');
> insert into City values('8507',102,'CITY_0000167468507','SN');
> insert into City values('21765',102,'CITY_00001711621765','SN');
> insert into City values('38543',102,'CITY_00001711638543','1');
> insert into City values('8739',102,'CITY_0000174268739','SNZa');
> insert into City values('8743',102,'CITY_0000174448743','SNZa');
> insert into City values('9006',102,'CITY_0000184079006','SN');
> insert into City values('9443',102,'CITY_0000196009443','SN');
> insert into City values('9471',102,'CITY_0000196009471','1');
> insert into City values('10283',102,'CITY_00001960010283','2');
> insert into City values('10275',102,'CITY_00002290510275','SNZc');
> insert into City values('10545',102,'CITY_00002310810545','SN');
> insert into City values('10299',102,'CITY_00002310810299','SNZa');
> insert into City values('108587',102,'CITY_000023108108587','1');
> insert into City values('108638',102,'CITY_000023108108638','2');
> insert into City values('108991',102,'CITY_000023108108991','3');
> insert into City values('10349',102,'CITY_00002339310349','SN');
> insert into City values('10533',102,'CITY_00002339310533','1');
> insert into City values('10479',102,'CITY_00002414310479','SNZa');
> insert into City values('13688',102,'CITY_00002414313688','SNZc');
> insert into City values('20570',102,'CITY_00002414320570','SNZf');
> insert into City values('21423',102,'CITY_00002414321423','SNZg');
> insert into City values('178039',102,'CITY_000024143178039','SNZm');
> insert into City values('191663',102,'CITY_000024143191663','SNZn');
> insert into City values('246276',102,'CITY_000024684246276','SN');
> insert into City values('10567',102,'CITY_00002468410567','SNZa');
> insert into City values('13642',102,'CITY_00002468413642','SNZd');
> insert into City values('20164',102,'CITY_00002468420164','SNZh');
> insert into City values('29524',102,'CITY_00002468429524','SNZj');
> insert into City values('48002',102,'CITY_00002468448002','SNZl');
> insert into City values('176820',102,'CITY_000024684176820','SNZm');
> insert into City values('10708',102,'CITY_00002512410708','SN');
> insert into City values('10865',102,'CITY_00002576210865','SNZb');
> insert into City values('13456',102,'CITY_00002750213456','SN');
> insert into City values('11432',102,'CITY_00002750211432','SNZb');
> insert into City values('11467',102,'CITY_00002750211467','SNZc');
> insert into City values('11506',102,'CITY_00002750211506','SNZd');
> insert into City values('11580',102,'CITY_00002750211580','SNZe');
> insert into City values('11634',102,'CITY_00002750211634','SNZf');
> insert into City values('12466',102,'CITY_00002750212466','SNZg');
> insert into City values('12515',102,'CITY_00002750212515','SNZh');
> insert into City values('12538',102,'CITY_00002750212538','SNZi');
> insert into City values('12753',102,'CITY_00002750212753','SNZj');
> insert into City values('12958',102,'CITY_00002750212958','SNZk');
> insert into City values('13063',102,'CITY_00002750213063','SNZl');
> insert into City values('13440',102,'CITY_00002750213440','SNZm');
> insert into City values('19046',102,'CITY_00002750219046','1');
> insert into City values('11299',102,'CITY_00002756611299','SNZa');
> insert into City values('11716',102,'CITY_00002833411716','SNZc');
> insert into City values('1287343',102,'CITY_0000283341287343','SNZd');
> insert into City values('12179',102,'CITY_00002851012179','SN');
> insert into City values('1402692',102,'CITY_0000285101402692','1');
> insert into City values('1410130',102,'CITY_0000285101410130','2');
> insert into City values('12014',102,'CITY_00002898112014','SN');
> insert into City values('11533',102,'CITY_00002898111533','SNZa');
> insert into City values('2353852',102,'CITY_0000290692353852','SNZo');
> insert into City values('432330',102,'CITY_000029236432330','SN');
> insert into City values('200312',102,'CITY_000029236200312','SNZg');
> insert into City values('667956',102,'CITY_000029236667956','1');
> insert into City values('2500684',102,'CITY_0000292362500684','02Zb');
> insert into City values('13478',102,'CITY_00002929013478','SN');
> insert into City values('13077',102,'CITY_00002929013077','SNZk');
> insert into City values('13450',102,'CITY_00002929013450','SNZl');
> insert into City values('14821',102,'CITY_00002929014821','1');
> insert into City values('19060',102,'CITY_00002929019060','2');
> insert into City values('12180',102,'CITY_00002931512180','SN');
> insert into City values('2027657',102,'CITY_0000293152027657','1');
> insert into City values('2760482',102,'CITY_0000293152760482','2');
> insert into City values('2813435',102,'CITY_0000293152813435','3');
> insert into City values('6479108',102,'CITY_0000293156479108','4');
> insert into City values('10948004',102,'CITY_00002931510948004','5');
> insert into City values('10992424',102,'CITY_00002931510992424','6');
> insert into City values('10992421',102,'CITY_00002931510992421','06Za');
> insert into City values('42894',102,'CITY_00002936042894','SN');
> insert into City values('23335',102,'CITY_00002936023335','SNZg');
> insert into City values('23464',102,'CITY_00002936023464','SNZh');
> insert into City values('23935',102,'CITY_00002936023935','SNZi');
> insert into City values('45641',102,'CITY_00002936045641','1');
> insert into City values('45733',102,'CITY_00002936045733','02Za');
> insert into City values('42902',102,'CITY_00002939742902','SN');
> insert into City values('23321',102,'CITY_00002939723321','SNZf');
> insert into City values('23463',102,'CITY_00002939723463','SNZg');
> insert into City values('23479',102,'CITY_00002939723479','SNZh');
> insert into City values('23936',102,'CITY_00002939723936','SNZi');
> insert into City values('45643',102,'CITY_00002939745643','1');
> insert into City values('45734',102,'CITY_00002939745734','02Za');
> insert into City values('12041',102,'CITY_00002989212041','SN');
> insert into City values('11720',102,'CITY_00002989211720','SNZa');
> insert into City values('12164',102,'CITY_00003034812164','SN');
> insert into City values('1404304',102,'CITY_0000303481404304','1');
> insert into City values('1410362',102,'CITY_0000303481410362','2');
> insert into City values('10832862',102,'CITY_00003034810832862','3');
> insert into City values('11023406',102,'CITY_00003034811023406','4');
> insert into City values('21478',102,'CITY_00003035721478','SN');
> insert into City values('11811',102,'CITY_00003035711811','SNZa');
> insert into City values('12166',102,'CITY_00003049012166','SN');
> insert into City values('2027629',102,'CITY_0000304902027629','1');
> insert into City values('2418908',102,'CITY_0000304902418908','2');
> insert into City values('2760711',102,'CITY_0000304902760711','3');
> insert into City values('3606258',102,'CITY_0000304903606258','4');
> insert into City values('11023403',102,'CITY_00003049011023403','5');
> insert into City values('11037609',102,'CITY_00003049011037609','6');
> insert into City values('11047721',102,'CITY_00003049011047721','7');
> insert into City values('11047722',102,'CITY_00003049011047722','8');
> insert into City values('11945',102,'CITY_00003099511945','SN');
> insert into City values('12165',102,'CITY_00003099512165','1');
> insert into City values('11970',102,'CITY_00003107311970','SNZb');
> insert into City values('12162',102,'CITY_00003133812162','SN');
> insert into City values('11996',102,'CITY_00003133811996','SNZa');
> insert into City values('10832863',102,'CITY_00003133810832863','01Za');
> insert into City values('20516',102,'CITY_00003152320516','SN');
> insert into City values('12040',102,'CITY_00003152312040','SNZa');
> insert into City values('13686',102,'CITY_00003152313686','SNZc');
> insert into City values('20171',102,'CITY_00003152320171','SNZf');
> insert into City values('175535',102,'CITY_000031523175535','01Za');
> insert into City values('12181',102,'CITY_00003206312181','SN');
> insert into City values('12182',102,'CITY_00003207212182','SN');
> insert into City values('10832866',102,'CITY_00003207210832866','1');
> insert into City values('30298',102,'CITY_00003230030298','SN');
> insert into City values('12758',102,'CITY_00003230012758','SNZb');
> insert into City values('28357',102,'CITY_00003230028357','SNZc');
> insert into City values('30297',102,'CITY_00003236430297','SN');
> insert into City values('12759',102,'CITY_00003236412759','SNZb');
> insert into City values('6695542',102,'CITY_0000323646695542','1');
> insert into City values('30300',102,'CITY_00003247030300','SN');
> insert into City values('12760',102,'CITY_00003247012760','SNZb');
> insert into City values('28350',102,'CITY_00003247028350','SNZc');
> insert into City values('6694405',102,'CITY_0000324706694405','1');
> insert into City values('8868465',102,'CITY_0000324708868465','2');
> insert into City values('30283',102,'CITY_00003260130283','SN');
> insert into City values('12761',102,'CITY_00003260112761','SNZb');
> insert into City values('12393',102,'CITY_00003262912393','SN');
> insert into City values('26171',102,'CITY_00003262926171','1');
> insert into City values('27957',102,'CITY_00003262927957','2');
> insert into City values('116878',102,'CITY_000032629116878','3');
> insert into City values('592111',102,'CITY_000032629592111','4');
> insert into City values('592382',102,'CITY_000032629592382','5');
> insert into City values('1654508',102,'CITY_0000326291654508','6');
> insert into City values('2964255',102,'CITY_0000326292964255','7');
> insert into City values('5803679',102,'CITY_0000326295803679','8');
> insert into City values('33361',102,'CITY_00003270833361','SN');
> insert into City values('12762',102,'CITY_00003270812762','SNZb');
> insert into City values('28362',102,'CITY_00003270828362','SNZc');
> insert into City values('30281',102,'CITY_00003270830281','SNZd');
> insert into City values('210483',102,'CITY_000032708210483','1');
> insert into City values('304235',102,'CITY_000032708304235','2');
> insert into City values('33363',102,'CITY_00003275333363','SN');
> insert into City values('12763',102,'CITY_00003275312763','SNZb');
> insert into City values('28361',102,'CITY_00003275328361','SNZc');
> insert into City values('28384',102,'CITY_00003275328384','SNZd');
> insert into City values('30285',102,'CITY_00003275330285','SNZe');
> insert into City values('210484',102,'CITY_000032753210484','1');
> insert into City values('278852',102,'CITY_000032753278852','2');
> insert into City values('30276',102,'CITY_00003281430276','SN');
> insert into City values('12764',102,'CITY_00003281412764','SNZb');
> insert into City values('28394',102,'CITY_00003286928394','SN');
> insert into City values('12765',102,'CITY_00003286912765 ','SNZb');
> insert into City values('87745',102,'CITY_00003286987745','1');
> insert into City values('210571',102,'CITY_000032869210571','2');
> insert into City values('33372',102,'CITY_00003296633372','SN');
> insert into City values('12766',102,'CITY_00003296612766','SNZb');
> insert into City values('28395',102,'CITY_00003296628395','SNZc');
> insert into City values('21069',103,'CITY_00000722521069','SNZc');
> insert into City values('21067',103,'CITY_00000725221067','SNZc');
> insert into City values('21059',103,'CITY_00000726121059','SNZd');
> insert into City values('223633',103,'CITY_000007368223633','SNZd');
> insert into City values('21072',103,'CITY_00000752621072','SNZc');
> insert into City values('21063',103,'CITY_00000753521063','SNZc');
> insert into City values('21061',103,'CITY_00000759921061','SNZd');
> insert into City values('21045',103,'CITY_00000763221045','SNZc');
> insert into City values('21047',103,'CITY_00000765021047','SNZb');
> insert into City values('304105',103,'CITY_000008552304105','2');
> insert into City values('10292',103,'CITY_00000857010292','SN');
> insert into City values('10296',103,'CITY_00000857010296','1');
> insert into City values('13558',103,'CITY_00000857013558','2');
> insert into City values('13570',103,'CITY_00000857013570','3');
> insert into City values('7080',103,'CITY_0000086597080','SN');
> insert into City values('13573',103,'CITY_00000865913573','1');
> insert into City values('13583',103,'CITY_00000865913583','2');
> insert into City values('30133',103,'CITY_00000865930133','3');
> insert into City values('33878',103,'CITY_00000865933878','4');
> insert into City values('7089',103,'CITY_0000086687089','SN');
> insert into City values('30128',103,'CITY_00000866830128','1');
> insert into City values('7101',103,'CITY_0000087107101','SN');
> insert into City values('19237',103,'CITY_00000871019237','1');
> insert into City values('20185',103,'CITY_00000871020185','02Za');
> insert into City values('7105',103,'CITY_0000087477105','SN');
> insert into City values('13608',103,'CITY_00000874713608','1');
> insert into City values('13609',103,'CITY_00000874713609','2');
> insert into City values('19167',103,'CITY_00000874719167','3');
> insert into City values('7107',103,'CITY_0000087567107','SN');
> insert into City values('30130',103,'CITY_00000875630130','1');
> insert into City values('7108',103,'CITY_0000087657108','SN');
> insert into City values('19238',103,'CITY_00000876519238','1');
> insert into City values('7110',103,'CITY_0000087747110','SN');
> insert into City values('13560',103,'CITY_00000877413560','1');
> insert into City values('19170',103,'CITY_00000877419170','2');
> insert into City values('7113',103,'CITY_0000088087113','SN');
> insert into City values('22918',103,'CITY_00000880822918','1');
> insert into City values('7504',103,'CITY_0000088267504','SN');
> insert into City values('23019',103,'CITY_00000882623019','1');
> insert into City values('23020',103,'CITY_00000882623020','2');
> insert into City values('7116',103,'CITY_0000088357116','SN');
> insert into City values('13552',103,'CITY_00000883513552','1');
> insert into City values('7117',103,'CITY_0000088447117','SN');
> insert into City values('30123',103,'CITY_00000884430123','1');
> insert into City values('13584',103,'CITY_00000886213584','SN');
> insert into City values('13585',103,'CITY_00000886213585','1');
> insert into City values('30134',103,'CITY_00000886230134','2');
> insert into City values('7120',103,'CITY_0000088717120','SN');
> insert into City values('30124',103,'CITY_00000887130124','1');
> insert into City values('8098',103,'CITY_0000088808098','SN');
> insert into City values('23022',103,'CITY_00000888023022','1');
> insert into City values('30116',103,'CITY_00000888030116','3');
> insert into City values('7122',103,'CITY_0000088997122','SN');
> insert into City values('22921',103,'CITY_00000889922921','1');
> insert into City values('8057',103,'CITY_0000089058057','SN');
> insert into City values('23021',103,'CITY_00000890523021','1');
> insert into City values('7124',103,'CITY_0000089147124','SN');
> insert into City values('19236',103,'CITY_00000891419236','1');
> insert into City values('7719',103,'CITY_0000089237719','SN');
> insert into City values('30120',103,'CITY_00000892330120','3');
> insert into City values('7140',103,'CITY_0000089327140','SN');
> insert into City values('7141',103,'CITY_0000089327141','1');
> insert into City values('13549',103,'CITY_00000893213549','2');
> insert into City values('7517',103,'CITY_0000089507517','SN');
> insert into City values('7541',103,'CITY_0000089507541','1');
> insert into City values('7593',103,'CITY_0000089507593','2');
> insert into City values('13556',103,'CITY_00000895013556','3');
> insert into City values('7129',103,'CITY_0000089697129','SN');
> insert into City values('13554',103,'CITY_00000896913554','1');
> insert into City values('19149',103,'CITY_00000896919149','2');
> insert into City values('19168',103,'CITY_00000897819168','SN');
> insert into City values('19169',103,'CITY_00000897819169','2');
> insert into City values('19116',103,'CITY_00000898719116','SN');
> insert into City values('19117',103,'CITY_00000898719117','1');
> insert into City values('7135',103,'CITY_0000089967135','SN');
> insert into City values('30113',103,'CITY_00000899630113','2');
> insert into City values('19176',103,'CITY_00000900119176','SN');
> insert into City values('19180',103,'CITY_00000900119180','1');
> insert into City values('7207',103,'CITY_0000095607207','SNZb');
> insert into City values('30136',103,'CITY_00000972830136','1');
> insert into City values('30137',103,'CITY_00001001630137','1');
> insert into City values('30138',103,'CITY_00001004330138','1');
> insert into City values('7269',103,'CITY_0000101137269','SN');
> insert into City values('9161',103,'CITY_0000101139161','1');
> insert into City values('130660',103,'CITY_000010113130660','2');
> insert into City values('34167',103,'CITY_00001043234167','1');
> insert into City values('7322',103,'CITY_0000105847322','SN');
> insert into City values('7327',103,'CITY_0000105847327','1');
> insert into City values('7328',103,'CITY_0000105847328','2');
> insert into City values('7377',103,'CITY_0000109287377','SNZb');
> insert into City values('7375',103,'CITY_0000110157375','SN');
> insert into City values('14405',103,'CITY_00001101514405','1');
> insert into City values('14498',103,'CITY_00001101514498','2');
> insert into City values('7380',103,'CITY_0000110517380','SN');
> insert into City values('18173',103,'CITY_00001105118173','1');
> insert into City values('18183',103,'CITY_00001105118183','2');
> insert into City values('7414',103,'CITY_0000114047414','SNZa');
> insert into City values('7424',103,'CITY_0000115017424','SNZa');
> insert into City values('6868080',103,'CITY_0000115296868080','SNZc');
> insert into City values('7545',103,'CITY_0000120327545','SN');
> insert into City values('7886',103,'CITY_0000120327886','1');
> insert into City values('7549',103,'CITY_0000120697549','SN');
> insert into City values('7658',103,'CITY_0000124037658','SN');
> insert into City values('7687',103,'CITY_0000124677687','SN');
> insert into City values('7691',103,'CITY_0000124947691','SN');
> insert into City values('7694',103,'CITY_0000125007694','SN');
> insert into City values('7696',103,'CITY_0000125197696','SN');
> insert into City values('7699',103,'CITY_0000125287699','SN');
> insert into City values('7704',103,'CITY_0000125467704','SN');
> insert into City values('7707',103,'CITY_0000125557707','SN');
> insert into City values('7709',103,'CITY_0000125737709','SN');
> insert into City values('7710',103,'CITY_0000125827710','SN');
> insert into City values('7731',103,'CITY_0000126707731','SN');
> insert into City values('22917',103,'CITY_00001267022917','1');
> insert into City values('6868081',103,'CITY_0000142896868081','SNZd');
> insert into City values('122148',103,'CITY_000014331122148','SN');
> insert into City values('7982',103,'CITY_0000145267982','SN');
> insert into City values('7989',103,'CITY_0000145807989','SN');
> insert into City values('7995',103,'CITY_0000146327995','SN');
> insert into City values('202944',103,'CITY_000014632202944','1');
> insert into City values('266067',103,'CITY_000014632266067','2');
> insert into City values('8001',103,'CITY_0000146878001','SN');
> insert into City values('11844',103,'CITY_00001468711844','1');
> insert into City values('202958',103,'CITY_000014687202958','2');
> insert into City values('8003',103,'CITY_0000147028003','SN');
> insert into City values('40285',103,'CITY_00001470240285','1');
> insert into City values('51444',103,'CITY_00001470251444','2');
> insert into City values('202969',103,'CITY_000014702202969','3');
> insert into City values('122225',103,'CITY_000014739122225','1');
> insert into City values('8013',103,'CITY_0000147848013','SN');
> insert into City values('51508',103,'CITY_00001478451508','1');
> insert into City values('204081',103,'CITY_000014784204081','2');
> insert into City values('8121',103,'CITY_0000148548121','SN');
> insert into City values('739882',103,'CITY_000014854739882','01Za');
> insert into City values('8688',103,'CITY_0000151818688','SNZb');
> insert into City values('8690',103,'CITY_0000151908690','SNZb');
> insert into City values('8689',103,'CITY_0000152068689','SNZb');
> insert into City values('8692',103,'CITY_0000152158692','SNZb');
> insert into City values('9208',103,'CITY_0000155079208','SN');
> insert into City values('9666',103,'CITY_0000155079666','1');
> insert into City values('9667',103,'CITY_0000155079667','2');
> insert into City values('9668',103,'CITY_0000155079668','3');
> insert into City values('1059913',103,'CITY_0000155071059913','4');
> insert into City values('3774117',103,'CITY_0000155073774117','5');
> insert into City values('8765368',103,'CITY_0000155078765368','6');
> insert into City values('8185',103,'CITY_0000159698185','SN');
> insert into City values('8221',103,'CITY_0000159698221','1');
> insert into City values('8224',103,'CITY_0000159698224','2');
> insert into City values('8351',103,'CITY_0000159698351','3');
> insert into City values('8352',103,'CITY_0000159698352','4');
> insert into City values('8358',103,'CITY_0000159698358','5');
> insert into City values('8416',103,'CITY_0000159698416','6');
> insert into City values('8431',103,'CITY_0000159698431','7');
> insert into City values('8509',103,'CITY_0000159698509','8');
> insert into City values('8519',103,'CITY_0000159698519','9');
> insert into City values('8257',103,'CITY_0000161718257','SN');
> insert into City values('560241',103,'CITY_000016171560241','01Zd');
> insert into City values('1378533',103,'CITY_0000167731378533','5');
> insert into City values('1489455',103,'CITY_0000167731489455','6');
> insert into City values('1633832',103,'CITY_0000167731633832','7');
> insert into City values('1678805',103,'CITY_0000167731678805','8');
> insert into City values('1788137',103,'CITY_0000167731788137','9');
> insert into City values('2026359',103,'CITY_0000167732026359','10');
> insert into City values('2749858',103,'CITY_0000167732749858','11');
> insert into City values('10312994',103,'CITY_00001677310312994','12');
> insert into City values('10312986',103,'CITY_00001677310312986','12Za');
> insert into City values('10312989',103,'CITY_00001677310312989','12Zb');
> insert into City values('16772',103,'CITY_00001678216772','SN');
> insert into City values('16874',103,'CITY_00001678216874','1');
> insert into City values('18279',103,'CITY_00001678218279','2');
> insert into City values('18280',103,'CITY_00001678218280','3');
> insert into City values('18459',103,'CITY_00001678218459','4');
> insert into City values('21504',103,'CITY_00001678221504','5');
> insert into City values('21785',103,'CITY_00001678221785','6');
> insert into City values('1828357',103,'CITY_0000167821828357','9');
> insert into City values('2060302',103,'CITY_0000167822060302','10');
> insert into City values('3126785',103,'CITY_0000167823126785','11');
> insert into City values('21484',103,'CITY_00001714321484','SN');
> insert into City values('21486',103,'CITY_00001714321486','1');
> insert into City values('21487',103,'CITY_00001714321487','2');
> insert into City values('21489',103,'CITY_00001714321489','3');
> insert into City values('21490',103,'CITY_00001714321490','4');
> insert into City values('131677',103,'CITY_000017143131677','5');
> insert into City values('9285',103,'CITY_0000189209285','SN');
> insert into City values('9347',103,'CITY_0000191969347','SN');
> insert into City values('9892',103,'CITY_0000212169892','SN');
> insert into City values('10046',103,'CITY_00002184510046','SN');
> insert into City values('10324',103,'CITY_00002184510324','1');
> insert into City values('10336',103,'CITY_00002184510336','2');
> insert into City values('10374',103,'CITY_00002184510374','3');
> insert into City values('10540',103,'CITY_00002184510540','4');
> insert into City values('110420',103,'CITY_000021845110420','5');
> insert into City values('8677601',103,'CITY_0000218458677601','6');
> insert into City values('10058',103,'CITY_00002199710058','SN');
> insert into City values('10467',103,'CITY_00002199710467','1');
> insert into City values('10598',103,'CITY_00002199710598','2');
> insert into City values('10188',103,'CITY_00002265910188','SN');
> insert into City values('10210',103,'CITY_00002270110210','SN');
> insert into City values('10216',103,'CITY_00002273810216','SN');
> insert into City values('10218',103,'CITY_00002275610218','SN');
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Finding collocated data in ignite nodes
Posted by Nilesh K <ng...@gmail.com>.
Hello Ilya Kasnacheev,
Sure. Here is complete script :
CREATE TABLE Country (
country_id INT(10),
country_name CHAR(30),
Continent CHAR(30),
PRIMARY KEY (country_id)
) WITH "template=partitioned, backups=1";
CREATE TABLE City (
city_id INT(15),
country_id INT(10),
city_name CHAR(50),
Dist CHAR(20),
PRIMARY KEY (city_id,country_id)
) WITH "template=partitioned, backups=1, affinityKey=country_id";
insert into Country values('101','Russia','Russia');
insert into Country values('102','India','Asia');
insert into Country values('103','United States','America');
insert into City values('12554105',101,'CITY_00000000012554105','SNZa');
insert into City values('20467',101,'CITY_00000003720467','SN');
insert into City values('10498',101,'CITY_00000003710498','SNZa');
insert into City values('13617',101,'CITY_00000003713617','SNZb');
insert into City values('13628',101,'CITY_00000003713628','SNZd');
insert into City values('10502',101,'CITY_00000004610502','SN');
insert into City values('703166',101,'CITY_000000046703166','1');
insert into City values('13656',101,'CITY_00000007313656','SN');
insert into City values('10507',101,'CITY_00000007310507','SNZa');
insert into City values('13620',101,'CITY_00000007313620','SNZc');
insert into City values('13629',101,'CITY_00000007313629','SNZe');
insert into City values('10508',101,'CITY_00000009110508','SN');
insert into City values('47403',101,'CITY_00000009147403','1');
insert into City values('16774',101,'CITY_00000011616774','SN');
insert into City values('16773',101,'CITY_00000012516773','SN');
insert into City values('16778',101,'CITY_00000014316778','SN');
insert into City values('16779',101,'CITY_00000016116779','SN');
insert into City values('734192',101,'CITY_000000161734192','1');
insert into City values('699080',101,'CITY_000000161699080','01Za');
insert into City values('16781',101,'CITY_00000017016781','SN');
insert into City values('16780',101,'CITY_00000018916780','SN');
insert into City values('16802',101,'CITY_00000019816802','SN');
insert into City values('16803',101,'CITY_00000020416803','SN');
insert into City values('457688',101,'CITY_000000204457688','1');
insert into City values('16806',101,'CITY_00000021316806','SN');
insert into City values('16809',101,'CITY_00000023116809','SN');
insert into City values('16815',101,'CITY_00000024016815','SN');
insert into City values('6957',101,'CITY_0000053886957','SN');
insert into City values('6747',101,'CITY_0000053886747','SNZa');
insert into City values('21048',101,'CITY_00000538821048','SNZj');
insert into City values('21058',101,'CITY_00000538821058','01Za');
insert into City values('21068',101,'CITY_00000545821068','SN');
insert into City values('6749',101,'CITY_0000054586749','SNZa');
insert into City values('6780',101,'CITY_0000054586780','SNZb');
insert into City values('113520',101,'CITY_000005467113520','SN');
insert into City values('6750',101,'CITY_0000054676750','SNZa');
insert into City values('6820',101,'CITY_0000054676820','SNZb');
insert into City values('21066',101,'CITY_00000546721066','SNZc');
insert into City values('6751',101,'CITY_0000054766751','SNZa');
insert into City values('6821',101,'CITY_0000054766821','SNAb');
insert into City values('113679',101,'CITY_000005485113679','SN');
insert into City values('6822',101,'CITY_0000054856822','SNAb');
insert into City values('6916',101,'CITY_0000054856916','SNAc');
insert into City values('21064',101,'CITY_00000548521064','SNAd');
insert into City values('23992',101,'CITY_00000548523992','SNAe');
insert into City values('223623',101,'CITY_000005485223623','1');
insert into City values('113562',101,'CITY_000005494113562','SN');
insert into City values('6823',101,'CITY_0000054946823','SNAb');
insert into City values('6840',101,'CITY_0000054946840','SNAc');
insert into City values('21070',101,'CITY_00000549421070','SNAd');
insert into City values('21859',101,'CITY_00000549421859','SNAe');
insert into City values('50388',101,'CITY_00000549450388','SNAf');
insert into City values('122190',101,'CITY_000005494122190','1');
insert into City values('114520',101,'CITY_000005494114520','01Aa');
insert into City values('118632',101,'CITY_000005494118632','01Ab');
insert into City values('121228',101,'CITY_000005494121228','01Ac');
insert into City values('125075',101,'CITY_000005494125075','2');
insert into City values('7774147',101,'CITY_0000054947774147','3');
insert into City values('7764624',101,'CITY_0000054947764624','03Aa');
insert into City values('8002672',101,'CITY_0000054948002672','4');
insert into City values('8153942',101,'CITY_0000054948153942','5');
insert into City values('21857',101,'CITY_00000576821857','SN');
insert into City values('6837',101,'CITY_0000057686837','SNAc');
insert into City values('21071',101,'CITY_00000576821071','SNAd');
insert into City values('8153946',101,'CITY_0000057688153946','1');
insert into City values('8153949',101,'CITY_0000057688153949','2');
insert into City values('50701',101,'CITY_00000578650701','SN');
insert into City values('6825',101,'CITY_0000057866825','SNAb');
insert into City values('6936',101,'CITY_0000057866936','SNAc');
insert into City values('21062',101,'CITY_00000578621062','SNAd');
insert into City values('21854',101,'CITY_00000578621854','SNBe');
insert into City values('49691',101,'CITY_00000578649691','SNBf');
insert into City values('50368',101,'CITY_00000578650368','SNBg');
insert into City values('50673',101,'CITY_00000578650673','SNBh');
insert into City values('1189982',101,'CITY_0000057861189982','1');
insert into City values('50699',101,'CITY_00000579550699','SN');
insert into City values('6826',101,'CITY_0000057956826','SNBb');
insert into City values('6941',101,'CITY_0000057956941','SNBc');
insert into City values('21060',101,'CITY_00000579521060','SNBd');
insert into City values('21855',101,'CITY_00000579521855','SNBe');
insert into City values('49690',101,'CITY_00000579549690','SNBf');
insert into City values('50369',101,'CITY_00000579550369','SNBg');
insert into City values('50484',101,'CITY_00000579550484','SNBh');
insert into City values('50675',101,'CITY_00000579550675','SNBi');
insert into City values('1190096',101,'CITY_0000057951190096','1');
insert into City values('113616',101,'CITY_000005810113616','SN');
insert into City values('6949',101,'CITY_0000058106949','SNBd');
insert into City values('21043',101,'CITY_00000581021043','SNBe');
insert into City values('105484',101,'CITY_000005865105484','SN');
insert into City values('6951',101,'CITY_0000058656951','SNBc');
insert into City values('21046',101,'CITY_00000586521046','SNCd');
insert into City values('24635',101,'CITY_00000586524635','SNCe');
insert into City values('46650',101,'CITY_00000586546650','SNCf');
insert into City values('9590616',101,'CITY_0000058659590616','1');
insert into City values('21084',101,'CITY_00000608621084','SN');
insert into City values('21082',101,'CITY_00000609521082','SN');
insert into City values('7397166',101,'CITY_0000060957397166','1');
insert into City values('21371',101,'CITY_00000615621371','SNCd');
insert into City values('21373',101,'CITY_00000617421373','SNCd');
insert into City values('24237',101,'CITY_00000617424237','SNCe');
insert into City values('24660',101,'CITY_00000617424660','SNCf');
insert into City values('21703',101,'CITY_00000619221703','SN');
insert into City values('21734',101,'CITY_00000620821734','SN');
insert into City values('6816',101,'CITY_0000062086816','SNCb');
insert into City values('7020',101,'CITY_0000062087020','SNCc');
insert into City values('21041',101,'CITY_00000620821041','SNCd');
insert into City values('6065581',101,'CITY_0000062086065581','1');
insert into City values('21088',101,'CITY_00000624421088','SN');
insert into City values('987784',101,'CITY_000006262987784','SN');
insert into City values('21080',101,'CITY_00000626221080','SNCf');
insert into City values('21811',101,'CITY_00000626221811','SNCg');
insert into City values('989894',101,'CITY_000006262989894','1');
insert into City values('7011',101,'CITY_0000063057011','SN');
insert into City values('21898',101,'CITY_00000652721898','SN');
insert into City values('6946',101,'CITY_0000065276946','SNCc');
insert into City values('21858',101,'CITY_00000652721858','SNCe');
insert into City values('24637',101,'CITY_00000653624637','SN');
insert into City values('21092',101,'CITY_00000653621092','SNCc');
insert into City values('21093',101,'CITY_00000655421093','SNCc');
insert into City values('21372',101,'CITY_00000656321372','SNCc');
insert into City values('39367',101,'CITY_00000656339367','SNCf');
insert into City values('21086',101,'CITY_00000663321086','SN');
insert into City values('6852',101,'CITY_0000067496852','SNCa');
insert into City values('7109',101,'CITY_0000068557109','SNCb');
insert into City values('7041',101,'CITY_0000078637041','SN');
insert into City values('42730',101,'CITY_00000786342730','01Ca');
insert into City values('6995',101,'CITY_0000080846995','SN');
insert into City values('13553',101,'CITY_00000808413553','1');
insert into City values('19104',101,'CITY_00000808419104','2');
insert into City values('13586',101,'CITY_00000809313586','SN');
insert into City values('7132',101,'CITY_0000080937132','SNCb');
insert into City values('7671',101,'CITY_0000080937671','SNCd');
insert into City values('19058',101,'CITY_00000809319058','1');
insert into City values('13589',101,'CITY_00000810913589','SN');
insert into City values('6997',101,'CITY_0000081096997','SNCa');
insert into City values('19110',101,'CITY_00000810919110','1');
insert into City values('6998',101,'CITY_0000081186998','SN');
insert into City values('6999',101,'CITY_0000081276999','SN');
insert into City values('7000',101,'CITY_0000081367000','SN');
insert into City values('13607',101,'CITY_00000814513607','SN');
insert into City values('13588',101,'CITY_00000814513588','SNCb');
insert into City values('19088',101,'CITY_00000814519088','1');
insert into City values('7002',101,'CITY_0000081547002','SN');
insert into City values('7003',101,'CITY_0000081637003','SN');
insert into City values('7004',101,'CITY_0000081727004','SN');
insert into City values('13559',101,'CITY_00000817213559','1');
insert into City values('13610',101,'CITY_00000817213610','2');
insert into City values('13587',101,'CITY_00000817213587','02Ca');
insert into City values('7005',101,'CITY_0000081817005','SN');
insert into City values('7006',101,'CITY_0000081907006','SN');
insert into City values('7007',101,'CITY_0000082067007','SN');
insert into City values('13571',101,'CITY_00000821513571','SN');
insert into City values('7008',101,'CITY_0000082157008','SNCa');
insert into City values('7009',101,'CITY_0000082247009','SN');
insert into City values('7056',101,'CITY_0000082607056','SNCc');
insert into City values('13572',101,'CITY_00000827913572','SN');
insert into City values('7024',101,'CITY_0000082797024','SNCa');
insert into City values('7084',101,'CITY_0000082797084','SNCb');
insert into City values('13581',101,'CITY_00000827913581','1');
insert into City values('13579',101,'CITY_00000827913579','01Cb');
insert into City values('33875',101,'CITY_00000827933875','2');
insert into City values('7042',101,'CITY_0000082977042','SN');
insert into City values('7078',101,'CITY_0000083127078','SN');
insert into City values('13582',101,'CITY_00000831213582','1');
insert into City values('33874',101,'CITY_00000831233874','2');
insert into City values('7043',101,'CITY_0000083217043','SNCb');
insert into City values('7044',101,'CITY_0000083307044','SN');
insert into City values('7030',101,'CITY_0000083497030','SN');
insert into City values('13550',101,'CITY_00000834913550','1');
insert into City values('7529',101,'CITY_0000083497529','01Ca');
insert into City values('13551',101,'CITY_00000834913551','2');
insert into City values('7104',101,'CITY_0000083677104','SN');
insert into City values('7040',101,'CITY_0000083677040','SNCb');
insert into City values('7045',101,'CITY_0000083767045','SN');
insert into City values('303450',101,'CITY_000008385303450','SN');
insert into City values('7034',101,'CITY_0000083857034','SNCa');
insert into City values('7046',101,'CITY_0000083857046','SNCb');
insert into City values('7072',101,'CITY_0000083857072','SNEc');
insert into City values('7442',101,'CITY_0000083947442','SN');
insert into City values('7115',101,'CITY_0000083947115','SNEb');
insert into City values('7698',101,'CITY_0000084197698','SN');
insert into City values('7037',101,'CITY_0000084197037','SNEa');
insert into City values('19113',101,'CITY_00000844619113','SN');
insert into City values('7039',101,'CITY_0000084467039','SNEa');
insert into City values('7425',101,'CITY_0000084467425','SNEb');
insert into City values('7049',101,'CITY_0000084827049','SN');
insert into City values('7139',101,'CITY_0000084917139','SN');
insert into City values('7051',101,'CITY_0000084917051','SNEa');
insert into City values('13548',101,'CITY_00000849113548','1');
insert into City values('7527',101,'CITY_0000084917527','01Ea');
insert into City values('7052',101,'CITY_0000085077052','SN');
insert into City values('7053',101,'CITY_0000085167053','SN');
insert into City values('7447',101,'CITY_0000085347447','SN');
insert into City values('7057',101,'CITY_0000085347057','SNEa');
insert into City values('7537',101,'CITY_0000085347537','1');
insert into City values('7592',101,'CITY_0000085347592','2');
insert into City values('7580',101,'CITY_0000085347580','02Ea');
insert into City values('7647',101,'CITY_0000085347647','3');
insert into City values('13557',101,'CITY_00000854313557','SN');
insert into City values('7211',101,'CITY_0000085437211','SNEc');
insert into City values('13568',101,'CITY_00000854313568','1');
insert into City values('7137',101,'CITY_0000087927137','SNEb');
insert into City values('21111',101,'CITY_00000879221111','SNEc');
insert into City values('21925',101,'CITY_00000879221925','SNEd');
insert into City values('21947',101,'CITY_00000879221947','SNEe');
insert into City values('1311335',101,'CITY_0000088531311335','SNEb');
insert into City values('7144',101,'CITY_0000090477144','SNEa');
insert into City values('21103',101,'CITY_00000904721103','SNEb');
insert into City values('7147',101,'CITY_0000090837147','SNEa');
insert into City values('21116',101,'CITY_00000908321116','SNEb');
insert into City values('21944',101,'CITY_00000908321944','SNEc');
insert into City values('7206',101,'CITY_0000090927206','SN');
insert into City values('7148',101,'CITY_0000090927148','SNEa');
insert into City values('7205',101,'CITY_0000091177205','SN');
insert into City values('7150',101,'CITY_0000091177150','SNEa');
insert into City values('7156',101,'CITY_0000091357156','SNEa');
insert into City values('7154',101,'CITY_0000091447154','SN');
insert into City values('7163',101,'CITY_0000092327163','SNEa');
insert into City values('21101',101,'CITY_00000923221101','SNEb');
insert into City values('7165',101,'CITY_0000092507165','SNEa');
insert into City values('7196',101,'CITY_0000092697196','SNEb');
insert into City values('21114',101,'CITY_00000926921114','SNEc');
insert into City values('21917',101,'CITY_00000926921917','SNEd');
insert into City values('7167',101,'CITY_0000092787167','SN');
insert into City values('7168',101,'CITY_0000092877168','SNEa');
insert into City values('7169',101,'CITY_0000092967169','SNEa');
insert into City values('7204',101,'CITY_0000093027204','SN');
insert into City values('7170',101,'CITY_0000093027170','SNEa');
insert into City values('7747',101,'CITY_0000093397747','SN');
insert into City values('7173',101,'CITY_0000093397173','SNZa');
insert into City values('30141',101,'CITY_00000933930141','1');
insert into City values('7740',101,'CITY_0000093757740','SNZc');
insert into City values('7180',101,'CITY_0000094097180','SN');
insert into City values('7181',101,'CITY_0000094187181','SN');
insert into City values('7182',101,'CITY_0000094277182','SN');
insert into City values('7186',101,'CITY_0000094727186','SN');
insert into City values('7187',101,'CITY_0000094817187','SN');
insert into City values('7188',101,'CITY_0000094907188','SN');
insert into City values('7197',101,'CITY_0000095517197','SNZa');
insert into City values('7208',101,'CITY_0000095977208','SN');
insert into City values('7213',101,'CITY_0000096307213','SNZa');
insert into City values('21105',101,'CITY_00000963021105','SNZb');
insert into City values('7216',101,'CITY_0000096677216','SNZa');
insert into City values('21107',101,'CITY_00000966721107','SNZb');
insert into City values('7502',101,'CITY_0000096947502','SN');
insert into City values('7219',101,'CITY_0000096947219','SNZa');
insert into City values('7220',101,'CITY_0000097197220','SNZa');
insert into City values('21118',101,'CITY_00000971921118','SNZb');
insert into City values('24083',101,'CITY_00000971924083','SNZc');
insert into City values('7238',101,'CITY_0000098987238','SNZa');
insert into City values('21133',101,'CITY_00000989821133','SNZb');
insert into City values('24402',101,'CITY_00000992224402','SN');
insert into City values('7242',101,'CITY_0000099227242','SNZa');
insert into City values('21110',101,'CITY_00000992221110','SNZb');
insert into City values('21940',101,'CITY_00000992221940','SNZc');
insert into City values('44586',101,'CITY_00000996844586','SN');
insert into City values('7246',101,'CITY_0000099687246','SNZa');
insert into City values('21430',101,'CITY_00000996821430','SNZb');
insert into City values('5910180',101,'CITY_0000099685910180','1');
insert into City values('44576',101,'CITY_00001000744576','SN');
insert into City values('7255',101,'CITY_0000100077255','SNZa');
insert into City values('21431',101,'CITY_00001000721431','SNZb');
insert into City values('22702',101,'CITY_00001000722702','SNZc');
insert into City values('23545',101,'CITY_00001000723545','SNZd');
insert into City values('7742',101,'CITY_0000100257742','SN');
insert into City values('7261',101,'CITY_0000100257261','SNZa');
insert into City values('7266',101,'CITY_0000101047266','SN');
insert into City values('9018',101,'CITY_0000101049018','1');
insert into City values('9137',101,'CITY_0000101049137','2');
insert into City values('7271',101,'CITY_0000101597271','SNZa');
insert into City values('7273',101,'CITY_0000101777273','SNZa');
insert into City values('7300',101,'CITY_0000104057300','SN');
insert into City values('7301',101,'CITY_0000104147301','SN');
insert into City values('7659',101,'CITY_0000105027659','1');
insert into City values('8546',101,'CITY_0000105028546','2');
insert into City values('7321',101,'CITY_0000105757321','SN');
insert into City values('20518',101,'CITY_00001057520518','1');
insert into City values('13157',101,'CITY_00001057513157','01Za');
insert into City values('20569',101,'CITY_00001057520569','2');
insert into City values('24653',101,'CITY_00001059324653','SN');
insert into City values('21595',101,'CITY_00001059321595','SNZf');
insert into City values('22690',101,'CITY_00001061822690','SN');
insert into City values('7350',101,'CITY_0000106187350','SNZb');
insert into City values('21433',101,'CITY_00001061821433','SNZc');
insert into City values('46953',101,'CITY_00001061846953','1');
insert into City values('45551',101,'CITY_00001061845551','01Za');
insert into City values('46828',101,'CITY_00001061846828','01Zb');
insert into City values('46832',101,'CITY_00001061846832','01Zc');
insert into City values('978719',101,'CITY_000010618978719','2');
insert into City values('1087603',101,'CITY_0000106181087603','3');
insert into City values('2739779',101,'CITY_0000106182739779','4');
insert into City values('5708024',101,'CITY_0000106185708024','5');
insert into City values('5708057',101,'CITY_0000106185708057','6');
insert into City values('5708101',101,'CITY_0000106185708101','7');
insert into City values('7339',101,'CITY_0000106727339','SNZa');
insert into City values('7343',101,'CITY_0000107247343','SN');
insert into City values('7352',101,'CITY_0000107517352','SN');
insert into City values('7345',101,'CITY_0000107517345','SNZa');
insert into City values('7353',101,'CITY_0000108037353','SNZa');
insert into City values('21435',101,'CITY_00001080321435','SNZb');
insert into City values('7365',101,'CITY_0000109197365','SNZa');
insert into City values('360214',101,'CITY_000010937360214','SN');
insert into City values('1879683',101,'CITY_0000109371879683','1');
insert into City values('7368',101,'CITY_0000109467368','SNZa');
insert into City values('721432',101,'CITY_000010955721432','SNZb');
insert into City values('360223',101,'CITY_000010964360223','SN');
insert into City values('7371',101,'CITY_0000109737371','SN');
insert into City values('1879671',101,'CITY_0000109731879671','1');
insert into City values('1879622',101,'CITY_0000109731879622','01Za');
insert into City values('14400',101,'CITY_00001099114400','SN');
insert into City values('14403',101,'CITY_00001099114403','1');
insert into City values('14497',101,'CITY_00001099114497','2');
insert into City values('7376',101,'CITY_0000110247376','SN');
insert into City values('18170',101,'CITY_00001102418170','1');
insert into City values('8091',101,'CITY_0000110428091','SNZb');
insert into City values('8438',101,'CITY_0000110428438','SNZe');
insert into City values('8525',101,'CITY_0000110428525','SNZf');
insert into City values('21627',101,'CITY_00001104221627','SNZg');
insert into City values('7389',101,'CITY_0000111947389','SN');
insert into City values('20884',101,'CITY_00001119420884','1');
insert into City values('23881',101,'CITY_00001119423881','2');
insert into City values('23340',101,'CITY_00001119423340','02Za');
insert into City values('7394',101,'CITY_0000112287394','SNZa');
insert into City values('21438',101,'CITY_00001122821438','SNZb');
insert into City values('7396',101,'CITY_0000112557396','SN');
insert into City values('23924',101,'CITY_00001125523924','1');
insert into City values('20886',101,'CITY_00001125520886','01Za');
insert into City values('23337',101,'CITY_00001125523337','01Zb');
insert into City values('2280111',101,'CITY_0000112552280111','2');
insert into City values('21441',101,'CITY_00001126421441','SN');
insert into City values('7397',101,'CITY_0000112647397','SNZa');
insert into City values('7398',101,'CITY_0000112737398','SN');
insert into City values('23923',101,'CITY_00001127323923','1');
insert into City values('20888',101,'CITY_00001127320888','01Za');
insert into City values('23336',101,'CITY_00001127323336','01Zb');
insert into City values('7400',101,'CITY_0000112917400','SN');
insert into City values('20880',101,'CITY_00001129120880','1');
insert into City values('20893',101,'CITY_00001129120893','2');
insert into City values('23339',101,'CITY_00001129123339','3');
insert into City values('2926114',101,'CITY_0000112912926114','4');
insert into City values('4673798',101,'CITY_0000112914673798','5');
insert into City values('7402',101,'CITY_0000113167402','SN');
insert into City values('20891',101,'CITY_00001131620891','01Za');
insert into City values('23322',101,'CITY_00001131623322','01Zb');
insert into City values('152495',101,'CITY_000011316152495','01Zc');
insert into City values('23502',101,'CITY_00001134323502','SN');
insert into City values('7426',101,'CITY_0000113437426','SNZb');
insert into City values('21502',101,'CITY_00001134321502','SNZc');
insert into City values('22742',101,'CITY_00001134322742','SNZd');
insert into City values('7413',101,'CITY_0000113987413','SNZa');
insert into City values('7423',101,'CITY_0000114957423','SNZa');
insert into City values('21492',101,'CITY_00001160821492','SN');
insert into City values('7453',101,'CITY_0000116087453','SNZa');
insert into City values('1683111',101,'CITY_0000116081683111','1');
insert into City values('5708022',101,'CITY_0000116085708022','2');
insert into City values('5708103',101,'CITY_0000116085708103','3');
insert into City values('6868077',101,'CITY_0000116086868077','4');
insert into City values('24652',101,'CITY_00001162624652','SN');
insert into City values('7464',101,'CITY_0000116267464','SNZa');
insert into City values('21505',101,'CITY_00001162621505','SNZb');
insert into City values('7466',101,'CITY_0000116447466','SNZa');
insert into City values('21509',101,'CITY_00001164421509','SNZb');
insert into City values('7542',101,'CITY_0000116717542','SN');
insert into City values('7509',101,'CITY_0000116717509','SNZb');
insert into City values('7530',101,'CITY_0000116717530','SNZc');
insert into City values('7884',101,'CITY_0000116717884','1');
insert into City values('8202',101,'CITY_0000116718202','2');
insert into City values('8369',101,'CITY_0000116718369','3');
insert into City values('8536',101,'CITY_0000116718536','4');
insert into City values('8020',101,'CITY_0000116808020','SNZb');
insert into City values('7478',101,'CITY_0000117697478','SNZa');
insert into City values('45288',101,'CITY_00001177845288','SN');
insert into City values('7479',101,'CITY_0000117787479','SNZa');
insert into City values('21511',101,'CITY_00001181121511','SN');
insert into City values('7515',101,'CITY_0000118117515','SNZb');
insert into City values('46937',101,'CITY_00001181146937','1');
insert into City values('6008866',101,'CITY_0000118116008866','02Za');
insert into City values('6013938',101,'CITY_0000118116013938','02Zb');
insert into City values('6057917',101,'CITY_0000118116057917','02Zc');
insert into City values('7531',101,'CITY_0000119187531','SN');
insert into City values('7511',101,'CITY_0000119187511','SNZa');
insert into City values('7520',101,'CITY_0000119367520','SNZa');
insert into City values('7521',101,'CITY_0000119457521','SNZa');
insert into City values('7532',101,'CITY_0000119637532','SN');
insert into City values('7523',101,'CITY_0000119637523','SNZa');
insert into City values('7525',101,'CITY_0000119727525','SN');
insert into City values('7552',101,'CITY_0000119727552','1');
insert into City values('7882',101,'CITY_0000119727882','2');
insert into City values('7907',101,'CITY_0000119727907','3');
insert into City values('8357',101,'CITY_0000119728357','4');
insert into City values('7526',101,'CITY_0000119817526','SN');
insert into City values('8169',101,'CITY_0000119818169','1');
insert into City values('7528',101,'CITY_0000119907528','SN');
insert into City values('21514',101,'CITY_00001204121514','SN');
insert into City values('7751',101,'CITY_0000120417751','SNZb');
insert into City values('46941',101,'CITY_00001204146941','1');
insert into City values('7548',101,'CITY_0000120507548','SN');
insert into City values('7564',101,'CITY_0000121577564','SN');
insert into City values('7894',101,'CITY_0000124587894','SNZc');
insert into City values('7896',101,'CITY_0000125377896','SNZb');
insert into City values('7956',101,'CITY_0000125647956','SNZb');
insert into City values('7941',101,'CITY_0000125917941','SNZb');
insert into City values('7942',101,'CITY_0000126077942','SNZb');
insert into City values('7968',101,'CITY_0000126167968','SNZb');
insert into City values('7736',101,'CITY_0000126987736','SN');
insert into City values('122085',101,'CITY_000012704122085','SN');
insert into City values('7738',101,'CITY_0000127047738','SNZa');
insert into City values('9316',101,'CITY_0000127049316','SNZb');
insert into City values('122095',101,'CITY_000012731122095','SN');
insert into City values('7748',101,'CITY_0000127317748','SNZa');
insert into City values('7749',101,'CITY_0000127407749','SN');
insert into City values('21535',101,'CITY_00001276821535','SN');
insert into City values('7753',101,'CITY_0000127687753','SNZa');
insert into City values('7757',101,'CITY_0000127957757','SN');
insert into City values('730092',101,'CITY_000012795730092','01Za');
insert into City values('7759',101,'CITY_0000128107759','SN');
insert into City values('7760',101,'CITY_0000128297760','SN');
insert into City values('21539',101,'CITY_00001284721539','SN');
insert into City values('7762',101,'CITY_0000128477762','SNZa');
insert into City values('21621',101,'CITY_00001300421621','SN');
insert into City values('7774',101,'CITY_0000130047774','SNZa');
insert into City values('8253',101,'CITY_0000130048253','SNZb');
insert into City values('5943619',101,'CITY_0000130045943619','01Za');
insert into City values('7777',101,'CITY_0000130407777','SN');
insert into City values('739681',101,'CITY_000013040739681','01Za');
insert into City values('21542',101,'CITY_00001336921542','SN');
insert into City values('7809',101,'CITY_0000133697809','SNZa');
insert into City values('5707563',101,'CITY_0000133695707563','1');
insert into City values('5667447',101,'CITY_0000133695667447','01Za');
insert into City values('5708105',101,'CITY_0000133695708105','2');
insert into City values('7810',101,'CITY_0000133787810','SNZa');
insert into City values('21545',101,'CITY_00001348421545','SN');
insert into City values('7836',101,'CITY_0000134847836','SNZa');
insert into City values('7838',101,'CITY_0000135097838','SN');
insert into City values('24659',101,'CITY_00001351824659','SN');
insert into City values('7839',101,'CITY_0000135187839','SNZa');
insert into City values('21548',101,'CITY_00001351821548','SNZb');
insert into City values('22938',101,'CITY_00001351822938','SNZc');
insert into City values('10823731',101,'CITY_00001351810823731','1');
insert into City values('21551',101,'CITY_00001355421551','SN');
insert into City values('7843',101,'CITY_0000135547843','SNZa');
insert into City values('21554',101,'CITY_00001358121554','SN');
insert into City values('7845',101,'CITY_0000135817845','SNZa');
insert into City values('7849',101,'CITY_0000136157849','SNZa');
insert into City values('21557',101,'CITY_00001362421557','SN');
insert into City values('7850',101,'CITY_0000136247850','SNZa');
insert into City values('22875',101,'CITY_00001364222875','SN');
insert into City values('7852',101,'CITY_0000136427852','SNZa');
insert into City values('21559',101,'CITY_00001364221559','SNZb');
insert into City values('7859',101,'CITY_0000137037859','SN');
insert into City values('733853',101,'CITY_000013703733853','01Za');
insert into City values('7861',101,'CITY_0000137217861','SN');
insert into City values('733809',101,'CITY_000013721733809','01Za');
insert into City values('7863',101,'CITY_0000137497863','SN');
insert into City values('7865',101,'CITY_0000137677865','SN');
insert into City values('733748',101,'CITY_000013767733748','01Za');
insert into City values('7866',101,'CITY_0000137767866','SN');
insert into City values('733758',101,'CITY_000013776733758','01Za');
insert into City values('7868',101,'CITY_0000137857868','SN');
insert into City values('643516',101,'CITY_000013785643516','01Za');
insert into City values('21563',101,'CITY_00001382821563','SN');
insert into City values('7872',101,'CITY_0000138287872','SNZa');
insert into City values('21565',101,'CITY_00001389121565','SN');
insert into City values('7885',101,'CITY_0000138917885','SNZa');
insert into City values('7895',101,'CITY_0000139437895','SNZa');
insert into City values('21567',101,'CITY_00001394321567','SNZb');
insert into City values('7947',101,'CITY_0000139707947','SN');
insert into City values('7899',101,'CITY_0000139707899','SNZa');
insert into City values('202846',101,'CITY_000013970202846','1');
insert into City values('266065',101,'CITY_000013970266065','2');
insert into City values('21570',101,'CITY_00001398921570','SN');
insert into City values('7900',101,'CITY_0000139897900','SNZa');
insert into City values('3297517',101,'CITY_0000139893297517','1');
insert into City values('5708020',101,'CITY_0000139895708020','2');
insert into City values('5708109',101,'CITY_0000139895708109','3');
insert into City values('7905',101,'CITY_0000140037905','SNZa');
insert into City values('21572',101,'CITY_00001400321572','SNZb');
insert into City values('7909',101,'CITY_0000140307909','SNZa');
insert into City values('21574',101,'CITY_00001403021574','SNZb');
insert into City values('7912',101,'CITY_0000140587912','SNZa');
insert into City values('7916',101,'CITY_0000140857916','SNZa');
insert into City values('21576',101,'CITY_00001408521576','SNZb');
insert into City values('7949',101,'CITY_0000140947949','SN');
insert into City values('7917',101,'CITY_0000140947917','SNZa');
insert into City values('202831',101,'CITY_000014094202831','1');
insert into City values('23847',101,'CITY_00001417323847','SN');
insert into City values('7946',101,'CITY_0000141737946','SNZb');
insert into City values('21578',101,'CITY_00001417321578','SNZc');
insert into City values('7950',101,'CITY_0000142347950','SN');
insert into City values('7938',101,'CITY_0000142347938','SNZa');
insert into City values('51438',101,'CITY_00001423451438','1');
insert into City values('202840',101,'CITY_000014234202840','2');
insert into City values('7986',101,'CITY_0000142527986','SNZb');
insert into City values('7951',101,'CITY_0000142617951','SN');
insert into City values('7944',101,'CITY_0000142617944','SNZa');
insert into City values('24188',101,'CITY_00001430424188','SN');
insert into City values('7954',101,'CITY_0000143047954','SNZa');
insert into City values('21581',101,'CITY_00001430421581','SNZb');
insert into City values('23851',101,'CITY_00001434023851','SN');
insert into City values('7958',101,'CITY_0000143407958','SNZa');
insert into City values('11221',102,'CITY_00000006411221','SN');
insert into City values('32417',102,'CITY_00000006432417','1');
insert into City values('101980',102,'CITY_000000064101980','2');
insert into City values('498384',102,'CITY_000000064498384','3');
insert into City values('1022956',102,'CITY_0000000641022956','4');
insert into City values('113710',102,'CITY_000006572113710','SN');
insert into City values('157284',102,'CITY_000006572157284','1');
insert into City values('131894',102,'CITY_000006572131894','01Zc');
insert into City values('223692',102,'CITY_000006572223692','2');
insert into City values('360361',102,'CITY_000006572360361','3');
insert into City values('1113393',102,'CITY_0000065721113393','4');
insert into City values('1837552',102,'CITY_0000065721837552','5');
insert into City values('2248350',102,'CITY_0000065722248350','6');
insert into City values('7843924',102,'CITY_0000065727843924','7');
insert into City values('6904400',102,'CITY_0000065726904400','07Za');
insert into City values('7742941',102,'CITY_0000065727742941','07Zc');
insert into City values('7742942',102,'CITY_0000065727742942','07Zd');
insert into City values('7764627',102,'CITY_0000065727764627','07Ze');
insert into City values('8153945',102,'CITY_0000065728153945','8');
insert into City values('9590618',102,'CITY_0000065729590618','9');
insert into City values('989911',102,'CITY_000006943989911','SN');
insert into City values('988217',102,'CITY_000006943988217','SNZn');
insert into City values('5710668',102,'CITY_0000069435710668','1');
insert into City values('5710673',102,'CITY_0000069435710673','2');
insert into City values('5712306',102,'CITY_0000069435712306','3');
insert into City values('5721339',102,'CITY_0000069435721339','4');
insert into City values('5727239',102,'CITY_0000069435727239','5');
insert into City values('6621857',102,'CITY_0000069436621857','6');
insert into City values('6869244',102,'CITY_0000069436869244','07Za');
insert into City values('7081',102,'CITY_0000084737081','SN');
insert into City values('42728',102,'CITY_00000847342728','01Za');
insert into City values('21805',102,'CITY_00000873821805','SNZe');
insert into City values('19225',102,'CITY_00000905619225','SN');
insert into City values('7324',102,'CITY_0000090567324','SNZd');
insert into City values('7615',102,'CITY_0000090567615','SNZh');
insert into City values('34016',102,'CITY_00000905634016','1');
insert into City values('34198',102,'CITY_00000905634198','2');
insert into City values('34140',102,'CITY_00000932034140','SN');
insert into City values('7312',102,'CITY_0000093207312','SNZd');
insert into City values('7333',102,'CITY_0000093207333','SNZe');
insert into City values('19231',102,'CITY_00000939319231','SN');
insert into City values('7330',102,'CITY_0000093937330','SNZc');
insert into City values('7331',102,'CITY_0000093937331','SNZd');
insert into City values('33884',102,'CITY_00000939333884','1');
insert into City values('33871',102,'CITY_00000939333871','01Za');
insert into City values('13611',102,'CITY_00001044113611','SN');
insert into City values('7320',102,'CITY_0000104417320','SNZc');
insert into City values('7503',102,'CITY_0000104417503','SNZd');
insert into City values('19219',102,'CITY_00001044119219','1');
insert into City values('34006',102,'CITY_00001044134006','2');
insert into City values('8128',102,'CITY_0000105488128','SNZb');
insert into City values('11126',102,'CITY_00001054811126','SNZc');
insert into City values('11437',102,'CITY_00001054811437','SNZd');
insert into City values('20840',102,'CITY_00001054820840','SNZe');
insert into City values('21135',102,'CITY_00001054821135','SNZf');
insert into City values('21927',102,'CITY_00001054821927','SNZg');
insert into City values('21948',102,'CITY_00001054821948','SNZh');
insert into City values('24111',102,'CITY_00001054824111','SNZi');
insert into City values('24401',102,'CITY_00001054824401','SNZj');
insert into City values('69256',102,'CITY_00001054869256','SNZk');
insert into City values('69797',102,'CITY_00001054869797','SNZl');
insert into City values('69819',102,'CITY_00001054869819','SNZm');
insert into City values('34197',102,'CITY_00001062734197','SN');
insert into City values('7939',102,'CITY_0000107977939','SN');
insert into City values('2066221',102,'CITY_0000107972066221','1');
insert into City values('7550',102,'CITY_0000119097550','SN');
insert into City values('7510',102,'CITY_0000119097510','SNZa');
insert into City values('7524',102,'CITY_0000119097524','SNZb');
insert into City values('7543',102,'CITY_0000119097543','SNZc');
insert into City values('7551',102,'CITY_0000119097551','1');
insert into City values('7898',102,'CITY_0000119097898','2');
insert into City values('7883',102,'CITY_0000119097883','02Za');
insert into City values('10821',102,'CITY_00001190910821','3');
insert into City values('7920',102,'CITY_0000119097920','03Za');
insert into City values('7927',102,'CITY_0000119097927','03Zb');
insert into City values('10697',102,'CITY_00001190910697','03Zc');
insert into City values('122196',102,'CITY_000012713122196','SN');
insert into City values('7739',102,'CITY_0000127137739','SNZa');
insert into City values('9303',102,'CITY_0000127139303','SNZc');
insert into City values('122118',102,'CITY_000012713122118','SNZd');
insert into City values('7864',102,'CITY_0000137587864','SN');
insert into City values('7869',102,'CITY_0000137947869','SN');
insert into City values('8177',102,'CITY_0000141828177','SN');
insert into City values('8212',102,'CITY_0000141828212','1');
insert into City values('8222',102,'CITY_0000141828222','2');
insert into City values('8349',102,'CITY_0000141828349','3');
insert into City values('8355',102,'CITY_0000141828355','4');
insert into City values('8391',102,'CITY_0000141828391','5');
insert into City values('8492',102,'CITY_0000141828492','6');
insert into City values('8517',102,'CITY_0000141828517','7');
insert into City values('8534',102,'CITY_0000141828534','8');
insert into City values('7952',102,'CITY_0000142077952','SN');
insert into City values('51502',102,'CITY_00001420751502','1');
insert into City values('202865',102,'CITY_000014207202865','2');
insert into City values('266066',102,'CITY_000014207266066','3');
insert into City values('8460',102,'CITY_0000145088460','SN');
insert into City values('739864',102,'CITY_000014508739864','01Za');
insert into City values('45519',102,'CITY_00001472045519','SN');
insert into City values('45302',102,'CITY_00001472045302','SNZaa');
insert into City values('45214',102,'CITY_00001472045214','SNZz');
insert into City values('48804',102,'CITY_00001472048804','1');
insert into City values('46968',102,'CITY_00001472046968','01Zb');
insert into City values('978683',102,'CITY_000014720978683','2');
insert into City values('978632',102,'CITY_000014720978632','02Zb');
insert into City values('5460781',102,'CITY_0000147205460781','3');
insert into City values('5708031',102,'CITY_0000147205708031','4');
insert into City values('5672178',102,'CITY_0000147205672178','04Za');
insert into City values('5708064',102,'CITY_0000147205708064','5');
insert into City values('5712309',102,'CITY_0000147205712309','6');
insert into City values('5712311',102,'CITY_0000147205712311','7');
insert into City values('5723959',102,'CITY_0000147205723959','8');
insert into City values('5723962',102,'CITY_0000147205723962','9');
insert into City values('5910185',102,'CITY_0000147205910185','10Za');
insert into City values('5916481',102,'CITY_0000147205916481','10Zb');
insert into City values('5930898',102,'CITY_0000147205930898','10Zc');
insert into City values('5941638',102,'CITY_0000147205941638','10Zf');
insert into City values('5967494',102,'CITY_0000147205967494','10Zg');
insert into City values('6043059',102,'CITY_0000147206043059','10Zk');
insert into City values('6057918',102,'CITY_0000147206057918','10Zl');
insert into City values('6065579',102,'CITY_0000147206065579','10Zm');
insert into City values('6865565',102,'CITY_0000147206865565','10Zo');
insert into City values('8054',102,'CITY_0000150938054','SN');
insert into City values('8149',102,'CITY_0000150938149','1');
insert into City values('8090',102,'CITY_0000153588090','SN');
insert into City values('8194',102,'CITY_0000153588194','1');
insert into City values('8344',102,'CITY_0000153588344','2');
insert into City values('8772',102,'CITY_0000153588772','3');
insert into City values('9986',102,'CITY_0000153589986','4');
insert into City values('10007',102,'CITY_00001535810007','5');
insert into City values('10583',102,'CITY_00001535810583','6');
insert into City values('10676',102,'CITY_00001535810676','07Za');
insert into City values('8156',102,'CITY_0000157838156','SN');
insert into City values('8213',102,'CITY_0000160298213','SN');
insert into City values('17089',102,'CITY_00001602917089','02Za');
insert into City values('8394',102,'CITY_0000165518394','SN');
insert into City values('8585',102,'CITY_0000165518585','1');
insert into City values('10008',102,'CITY_00001655110008','2');
insert into City values('10022',102,'CITY_00001655110022','3');
insert into City values('10596',102,'CITY_00001655110596','4');
insert into City values('8507',102,'CITY_0000167468507','SN');
insert into City values('21765',102,'CITY_00001711621765','SN');
insert into City values('38543',102,'CITY_00001711638543','1');
insert into City values('8739',102,'CITY_0000174268739','SNZa');
insert into City values('8743',102,'CITY_0000174448743','SNZa');
insert into City values('9006',102,'CITY_0000184079006','SN');
insert into City values('9443',102,'CITY_0000196009443','SN');
insert into City values('9471',102,'CITY_0000196009471','1');
insert into City values('10283',102,'CITY_00001960010283','2');
insert into City values('10275',102,'CITY_00002290510275','SNZc');
insert into City values('10545',102,'CITY_00002310810545','SN');
insert into City values('10299',102,'CITY_00002310810299','SNZa');
insert into City values('108587',102,'CITY_000023108108587','1');
insert into City values('108638',102,'CITY_000023108108638','2');
insert into City values('108991',102,'CITY_000023108108991','3');
insert into City values('10349',102,'CITY_00002339310349','SN');
insert into City values('10533',102,'CITY_00002339310533','1');
insert into City values('10479',102,'CITY_00002414310479','SNZa');
insert into City values('13688',102,'CITY_00002414313688','SNZc');
insert into City values('20570',102,'CITY_00002414320570','SNZf');
insert into City values('21423',102,'CITY_00002414321423','SNZg');
insert into City values('178039',102,'CITY_000024143178039','SNZm');
insert into City values('191663',102,'CITY_000024143191663','SNZn');
insert into City values('246276',102,'CITY_000024684246276','SN');
insert into City values('10567',102,'CITY_00002468410567','SNZa');
insert into City values('13642',102,'CITY_00002468413642','SNZd');
insert into City values('20164',102,'CITY_00002468420164','SNZh');
insert into City values('29524',102,'CITY_00002468429524','SNZj');
insert into City values('48002',102,'CITY_00002468448002','SNZl');
insert into City values('176820',102,'CITY_000024684176820','SNZm');
insert into City values('10708',102,'CITY_00002512410708','SN');
insert into City values('10865',102,'CITY_00002576210865','SNZb');
insert into City values('13456',102,'CITY_00002750213456','SN');
insert into City values('11432',102,'CITY_00002750211432','SNZb');
insert into City values('11467',102,'CITY_00002750211467','SNZc');
insert into City values('11506',102,'CITY_00002750211506','SNZd');
insert into City values('11580',102,'CITY_00002750211580','SNZe');
insert into City values('11634',102,'CITY_00002750211634','SNZf');
insert into City values('12466',102,'CITY_00002750212466','SNZg');
insert into City values('12515',102,'CITY_00002750212515','SNZh');
insert into City values('12538',102,'CITY_00002750212538','SNZi');
insert into City values('12753',102,'CITY_00002750212753','SNZj');
insert into City values('12958',102,'CITY_00002750212958','SNZk');
insert into City values('13063',102,'CITY_00002750213063','SNZl');
insert into City values('13440',102,'CITY_00002750213440','SNZm');
insert into City values('19046',102,'CITY_00002750219046','1');
insert into City values('11299',102,'CITY_00002756611299','SNZa');
insert into City values('11716',102,'CITY_00002833411716','SNZc');
insert into City values('1287343',102,'CITY_0000283341287343','SNZd');
insert into City values('12179',102,'CITY_00002851012179','SN');
insert into City values('1402692',102,'CITY_0000285101402692','1');
insert into City values('1410130',102,'CITY_0000285101410130','2');
insert into City values('12014',102,'CITY_00002898112014','SN');
insert into City values('11533',102,'CITY_00002898111533','SNZa');
insert into City values('2353852',102,'CITY_0000290692353852','SNZo');
insert into City values('432330',102,'CITY_000029236432330','SN');
insert into City values('200312',102,'CITY_000029236200312','SNZg');
insert into City values('667956',102,'CITY_000029236667956','1');
insert into City values('2500684',102,'CITY_0000292362500684','02Zb');
insert into City values('13478',102,'CITY_00002929013478','SN');
insert into City values('13077',102,'CITY_00002929013077','SNZk');
insert into City values('13450',102,'CITY_00002929013450','SNZl');
insert into City values('14821',102,'CITY_00002929014821','1');
insert into City values('19060',102,'CITY_00002929019060','2');
insert into City values('12180',102,'CITY_00002931512180','SN');
insert into City values('2027657',102,'CITY_0000293152027657','1');
insert into City values('2760482',102,'CITY_0000293152760482','2');
insert into City values('2813435',102,'CITY_0000293152813435','3');
insert into City values('6479108',102,'CITY_0000293156479108','4');
insert into City values('10948004',102,'CITY_00002931510948004','5');
insert into City values('10992424',102,'CITY_00002931510992424','6');
insert into City values('10992421',102,'CITY_00002931510992421','06Za');
insert into City values('42894',102,'CITY_00002936042894','SN');
insert into City values('23335',102,'CITY_00002936023335','SNZg');
insert into City values('23464',102,'CITY_00002936023464','SNZh');
insert into City values('23935',102,'CITY_00002936023935','SNZi');
insert into City values('45641',102,'CITY_00002936045641','1');
insert into City values('45733',102,'CITY_00002936045733','02Za');
insert into City values('42902',102,'CITY_00002939742902','SN');
insert into City values('23321',102,'CITY_00002939723321','SNZf');
insert into City values('23463',102,'CITY_00002939723463','SNZg');
insert into City values('23479',102,'CITY_00002939723479','SNZh');
insert into City values('23936',102,'CITY_00002939723936','SNZi');
insert into City values('45643',102,'CITY_00002939745643','1');
insert into City values('45734',102,'CITY_00002939745734','02Za');
insert into City values('12041',102,'CITY_00002989212041','SN');
insert into City values('11720',102,'CITY_00002989211720','SNZa');
insert into City values('12164',102,'CITY_00003034812164','SN');
insert into City values('1404304',102,'CITY_0000303481404304','1');
insert into City values('1410362',102,'CITY_0000303481410362','2');
insert into City values('10832862',102,'CITY_00003034810832862','3');
insert into City values('11023406',102,'CITY_00003034811023406','4');
insert into City values('21478',102,'CITY_00003035721478','SN');
insert into City values('11811',102,'CITY_00003035711811','SNZa');
insert into City values('12166',102,'CITY_00003049012166','SN');
insert into City values('2027629',102,'CITY_0000304902027629','1');
insert into City values('2418908',102,'CITY_0000304902418908','2');
insert into City values('2760711',102,'CITY_0000304902760711','3');
insert into City values('3606258',102,'CITY_0000304903606258','4');
insert into City values('11023403',102,'CITY_00003049011023403','5');
insert into City values('11037609',102,'CITY_00003049011037609','6');
insert into City values('11047721',102,'CITY_00003049011047721','7');
insert into City values('11047722',102,'CITY_00003049011047722','8');
insert into City values('11945',102,'CITY_00003099511945','SN');
insert into City values('12165',102,'CITY_00003099512165','1');
insert into City values('11970',102,'CITY_00003107311970','SNZb');
insert into City values('12162',102,'CITY_00003133812162','SN');
insert into City values('11996',102,'CITY_00003133811996','SNZa');
insert into City values('10832863',102,'CITY_00003133810832863','01Za');
insert into City values('20516',102,'CITY_00003152320516','SN');
insert into City values('12040',102,'CITY_00003152312040','SNZa');
insert into City values('13686',102,'CITY_00003152313686','SNZc');
insert into City values('20171',102,'CITY_00003152320171','SNZf');
insert into City values('175535',102,'CITY_000031523175535','01Za');
insert into City values('12181',102,'CITY_00003206312181','SN');
insert into City values('12182',102,'CITY_00003207212182','SN');
insert into City values('10832866',102,'CITY_00003207210832866','1');
insert into City values('30298',102,'CITY_00003230030298','SN');
insert into City values('12758',102,'CITY_00003230012758','SNZb');
insert into City values('28357',102,'CITY_00003230028357','SNZc');
insert into City values('30297',102,'CITY_00003236430297','SN');
insert into City values('12759',102,'CITY_00003236412759','SNZb');
insert into City values('6695542',102,'CITY_0000323646695542','1');
insert into City values('30300',102,'CITY_00003247030300','SN');
insert into City values('12760',102,'CITY_00003247012760','SNZb');
insert into City values('28350',102,'CITY_00003247028350','SNZc');
insert into City values('6694405',102,'CITY_0000324706694405','1');
insert into City values('8868465',102,'CITY_0000324708868465','2');
insert into City values('30283',102,'CITY_00003260130283','SN');
insert into City values('12761',102,'CITY_00003260112761','SNZb');
insert into City values('12393',102,'CITY_00003262912393','SN');
insert into City values('26171',102,'CITY_00003262926171','1');
insert into City values('27957',102,'CITY_00003262927957','2');
insert into City values('116878',102,'CITY_000032629116878','3');
insert into City values('592111',102,'CITY_000032629592111','4');
insert into City values('592382',102,'CITY_000032629592382','5');
insert into City values('1654508',102,'CITY_0000326291654508','6');
insert into City values('2964255',102,'CITY_0000326292964255','7');
insert into City values('5803679',102,'CITY_0000326295803679','8');
insert into City values('33361',102,'CITY_00003270833361','SN');
insert into City values('12762',102,'CITY_00003270812762','SNZb');
insert into City values('28362',102,'CITY_00003270828362','SNZc');
insert into City values('30281',102,'CITY_00003270830281','SNZd');
insert into City values('210483',102,'CITY_000032708210483','1');
insert into City values('304235',102,'CITY_000032708304235','2');
insert into City values('33363',102,'CITY_00003275333363','SN');
insert into City values('12763',102,'CITY_00003275312763','SNZb');
insert into City values('28361',102,'CITY_00003275328361','SNZc');
insert into City values('28384',102,'CITY_00003275328384','SNZd');
insert into City values('30285',102,'CITY_00003275330285','SNZe');
insert into City values('210484',102,'CITY_000032753210484','1');
insert into City values('278852',102,'CITY_000032753278852','2');
insert into City values('30276',102,'CITY_00003281430276','SN');
insert into City values('12764',102,'CITY_00003281412764','SNZb');
insert into City values('28394',102,'CITY_00003286928394','SN');
insert into City values('12765',102,'CITY_00003286912765 ','SNZb');
insert into City values('87745',102,'CITY_00003286987745','1');
insert into City values('210571',102,'CITY_000032869210571','2');
insert into City values('33372',102,'CITY_00003296633372','SN');
insert into City values('12766',102,'CITY_00003296612766','SNZb');
insert into City values('28395',102,'CITY_00003296628395','SNZc');
insert into City values('21069',103,'CITY_00000722521069','SNZc');
insert into City values('21067',103,'CITY_00000725221067','SNZc');
insert into City values('21059',103,'CITY_00000726121059','SNZd');
insert into City values('223633',103,'CITY_000007368223633','SNZd');
insert into City values('21072',103,'CITY_00000752621072','SNZc');
insert into City values('21063',103,'CITY_00000753521063','SNZc');
insert into City values('21061',103,'CITY_00000759921061','SNZd');
insert into City values('21045',103,'CITY_00000763221045','SNZc');
insert into City values('21047',103,'CITY_00000765021047','SNZb');
insert into City values('304105',103,'CITY_000008552304105','2');
insert into City values('10292',103,'CITY_00000857010292','SN');
insert into City values('10296',103,'CITY_00000857010296','1');
insert into City values('13558',103,'CITY_00000857013558','2');
insert into City values('13570',103,'CITY_00000857013570','3');
insert into City values('7080',103,'CITY_0000086597080','SN');
insert into City values('13573',103,'CITY_00000865913573','1');
insert into City values('13583',103,'CITY_00000865913583','2');
insert into City values('30133',103,'CITY_00000865930133','3');
insert into City values('33878',103,'CITY_00000865933878','4');
insert into City values('7089',103,'CITY_0000086687089','SN');
insert into City values('30128',103,'CITY_00000866830128','1');
insert into City values('7101',103,'CITY_0000087107101','SN');
insert into City values('19237',103,'CITY_00000871019237','1');
insert into City values('20185',103,'CITY_00000871020185','02Za');
insert into City values('7105',103,'CITY_0000087477105','SN');
insert into City values('13608',103,'CITY_00000874713608','1');
insert into City values('13609',103,'CITY_00000874713609','2');
insert into City values('19167',103,'CITY_00000874719167','3');
insert into City values('7107',103,'CITY_0000087567107','SN');
insert into City values('30130',103,'CITY_00000875630130','1');
insert into City values('7108',103,'CITY_0000087657108','SN');
insert into City values('19238',103,'CITY_00000876519238','1');
insert into City values('7110',103,'CITY_0000087747110','SN');
insert into City values('13560',103,'CITY_00000877413560','1');
insert into City values('19170',103,'CITY_00000877419170','2');
insert into City values('7113',103,'CITY_0000088087113','SN');
insert into City values('22918',103,'CITY_00000880822918','1');
insert into City values('7504',103,'CITY_0000088267504','SN');
insert into City values('23019',103,'CITY_00000882623019','1');
insert into City values('23020',103,'CITY_00000882623020','2');
insert into City values('7116',103,'CITY_0000088357116','SN');
insert into City values('13552',103,'CITY_00000883513552','1');
insert into City values('7117',103,'CITY_0000088447117','SN');
insert into City values('30123',103,'CITY_00000884430123','1');
insert into City values('13584',103,'CITY_00000886213584','SN');
insert into City values('13585',103,'CITY_00000886213585','1');
insert into City values('30134',103,'CITY_00000886230134','2');
insert into City values('7120',103,'CITY_0000088717120','SN');
insert into City values('30124',103,'CITY_00000887130124','1');
insert into City values('8098',103,'CITY_0000088808098','SN');
insert into City values('23022',103,'CITY_00000888023022','1');
insert into City values('30116',103,'CITY_00000888030116','3');
insert into City values('7122',103,'CITY_0000088997122','SN');
insert into City values('22921',103,'CITY_00000889922921','1');
insert into City values('8057',103,'CITY_0000089058057','SN');
insert into City values('23021',103,'CITY_00000890523021','1');
insert into City values('7124',103,'CITY_0000089147124','SN');
insert into City values('19236',103,'CITY_00000891419236','1');
insert into City values('7719',103,'CITY_0000089237719','SN');
insert into City values('30120',103,'CITY_00000892330120','3');
insert into City values('7140',103,'CITY_0000089327140','SN');
insert into City values('7141',103,'CITY_0000089327141','1');
insert into City values('13549',103,'CITY_00000893213549','2');
insert into City values('7517',103,'CITY_0000089507517','SN');
insert into City values('7541',103,'CITY_0000089507541','1');
insert into City values('7593',103,'CITY_0000089507593','2');
insert into City values('13556',103,'CITY_00000895013556','3');
insert into City values('7129',103,'CITY_0000089697129','SN');
insert into City values('13554',103,'CITY_00000896913554','1');
insert into City values('19149',103,'CITY_00000896919149','2');
insert into City values('19168',103,'CITY_00000897819168','SN');
insert into City values('19169',103,'CITY_00000897819169','2');
insert into City values('19116',103,'CITY_00000898719116','SN');
insert into City values('19117',103,'CITY_00000898719117','1');
insert into City values('7135',103,'CITY_0000089967135','SN');
insert into City values('30113',103,'CITY_00000899630113','2');
insert into City values('19176',103,'CITY_00000900119176','SN');
insert into City values('19180',103,'CITY_00000900119180','1');
insert into City values('7207',103,'CITY_0000095607207','SNZb');
insert into City values('30136',103,'CITY_00000972830136','1');
insert into City values('30137',103,'CITY_00001001630137','1');
insert into City values('30138',103,'CITY_00001004330138','1');
insert into City values('7269',103,'CITY_0000101137269','SN');
insert into City values('9161',103,'CITY_0000101139161','1');
insert into City values('130660',103,'CITY_000010113130660','2');
insert into City values('34167',103,'CITY_00001043234167','1');
insert into City values('7322',103,'CITY_0000105847322','SN');
insert into City values('7327',103,'CITY_0000105847327','1');
insert into City values('7328',103,'CITY_0000105847328','2');
insert into City values('7377',103,'CITY_0000109287377','SNZb');
insert into City values('7375',103,'CITY_0000110157375','SN');
insert into City values('14405',103,'CITY_00001101514405','1');
insert into City values('14498',103,'CITY_00001101514498','2');
insert into City values('7380',103,'CITY_0000110517380','SN');
insert into City values('18173',103,'CITY_00001105118173','1');
insert into City values('18183',103,'CITY_00001105118183','2');
insert into City values('7414',103,'CITY_0000114047414','SNZa');
insert into City values('7424',103,'CITY_0000115017424','SNZa');
insert into City values('6868080',103,'CITY_0000115296868080','SNZc');
insert into City values('7545',103,'CITY_0000120327545','SN');
insert into City values('7886',103,'CITY_0000120327886','1');
insert into City values('7549',103,'CITY_0000120697549','SN');
insert into City values('7658',103,'CITY_0000124037658','SN');
insert into City values('7687',103,'CITY_0000124677687','SN');
insert into City values('7691',103,'CITY_0000124947691','SN');
insert into City values('7694',103,'CITY_0000125007694','SN');
insert into City values('7696',103,'CITY_0000125197696','SN');
insert into City values('7699',103,'CITY_0000125287699','SN');
insert into City values('7704',103,'CITY_0000125467704','SN');
insert into City values('7707',103,'CITY_0000125557707','SN');
insert into City values('7709',103,'CITY_0000125737709','SN');
insert into City values('7710',103,'CITY_0000125827710','SN');
insert into City values('7731',103,'CITY_0000126707731','SN');
insert into City values('22917',103,'CITY_00001267022917','1');
insert into City values('6868081',103,'CITY_0000142896868081','SNZd');
insert into City values('122148',103,'CITY_000014331122148','SN');
insert into City values('7982',103,'CITY_0000145267982','SN');
insert into City values('7989',103,'CITY_0000145807989','SN');
insert into City values('7995',103,'CITY_0000146327995','SN');
insert into City values('202944',103,'CITY_000014632202944','1');
insert into City values('266067',103,'CITY_000014632266067','2');
insert into City values('8001',103,'CITY_0000146878001','SN');
insert into City values('11844',103,'CITY_00001468711844','1');
insert into City values('202958',103,'CITY_000014687202958','2');
insert into City values('8003',103,'CITY_0000147028003','SN');
insert into City values('40285',103,'CITY_00001470240285','1');
insert into City values('51444',103,'CITY_00001470251444','2');
insert into City values('202969',103,'CITY_000014702202969','3');
insert into City values('122225',103,'CITY_000014739122225','1');
insert into City values('8013',103,'CITY_0000147848013','SN');
insert into City values('51508',103,'CITY_00001478451508','1');
insert into City values('204081',103,'CITY_000014784204081','2');
insert into City values('8121',103,'CITY_0000148548121','SN');
insert into City values('739882',103,'CITY_000014854739882','01Za');
insert into City values('8688',103,'CITY_0000151818688','SNZb');
insert into City values('8690',103,'CITY_0000151908690','SNZb');
insert into City values('8689',103,'CITY_0000152068689','SNZb');
insert into City values('8692',103,'CITY_0000152158692','SNZb');
insert into City values('9208',103,'CITY_0000155079208','SN');
insert into City values('9666',103,'CITY_0000155079666','1');
insert into City values('9667',103,'CITY_0000155079667','2');
insert into City values('9668',103,'CITY_0000155079668','3');
insert into City values('1059913',103,'CITY_0000155071059913','4');
insert into City values('3774117',103,'CITY_0000155073774117','5');
insert into City values('8765368',103,'CITY_0000155078765368','6');
insert into City values('8185',103,'CITY_0000159698185','SN');
insert into City values('8221',103,'CITY_0000159698221','1');
insert into City values('8224',103,'CITY_0000159698224','2');
insert into City values('8351',103,'CITY_0000159698351','3');
insert into City values('8352',103,'CITY_0000159698352','4');
insert into City values('8358',103,'CITY_0000159698358','5');
insert into City values('8416',103,'CITY_0000159698416','6');
insert into City values('8431',103,'CITY_0000159698431','7');
insert into City values('8509',103,'CITY_0000159698509','8');
insert into City values('8519',103,'CITY_0000159698519','9');
insert into City values('8257',103,'CITY_0000161718257','SN');
insert into City values('560241',103,'CITY_000016171560241','01Zd');
insert into City values('1378533',103,'CITY_0000167731378533','5');
insert into City values('1489455',103,'CITY_0000167731489455','6');
insert into City values('1633832',103,'CITY_0000167731633832','7');
insert into City values('1678805',103,'CITY_0000167731678805','8');
insert into City values('1788137',103,'CITY_0000167731788137','9');
insert into City values('2026359',103,'CITY_0000167732026359','10');
insert into City values('2749858',103,'CITY_0000167732749858','11');
insert into City values('10312994',103,'CITY_00001677310312994','12');
insert into City values('10312986',103,'CITY_00001677310312986','12Za');
insert into City values('10312989',103,'CITY_00001677310312989','12Zb');
insert into City values('16772',103,'CITY_00001678216772','SN');
insert into City values('16874',103,'CITY_00001678216874','1');
insert into City values('18279',103,'CITY_00001678218279','2');
insert into City values('18280',103,'CITY_00001678218280','3');
insert into City values('18459',103,'CITY_00001678218459','4');
insert into City values('21504',103,'CITY_00001678221504','5');
insert into City values('21785',103,'CITY_00001678221785','6');
insert into City values('1828357',103,'CITY_0000167821828357','9');
insert into City values('2060302',103,'CITY_0000167822060302','10');
insert into City values('3126785',103,'CITY_0000167823126785','11');
insert into City values('21484',103,'CITY_00001714321484','SN');
insert into City values('21486',103,'CITY_00001714321486','1');
insert into City values('21487',103,'CITY_00001714321487','2');
insert into City values('21489',103,'CITY_00001714321489','3');
insert into City values('21490',103,'CITY_00001714321490','4');
insert into City values('131677',103,'CITY_000017143131677','5');
insert into City values('9285',103,'CITY_0000189209285','SN');
insert into City values('9347',103,'CITY_0000191969347','SN');
insert into City values('9892',103,'CITY_0000212169892','SN');
insert into City values('10046',103,'CITY_00002184510046','SN');
insert into City values('10324',103,'CITY_00002184510324','1');
insert into City values('10336',103,'CITY_00002184510336','2');
insert into City values('10374',103,'CITY_00002184510374','3');
insert into City values('10540',103,'CITY_00002184510540','4');
insert into City values('110420',103,'CITY_000021845110420','5');
insert into City values('8677601',103,'CITY_0000218458677601','6');
insert into City values('10058',103,'CITY_00002199710058','SN');
insert into City values('10467',103,'CITY_00002199710467','1');
insert into City values('10598',103,'CITY_00002199710598','2');
insert into City values('10188',103,'CITY_00002265910188','SN');
insert into City values('10210',103,'CITY_00002270110210','SN');
insert into City values('10216',103,'CITY_00002273810216','SN');
insert into City values('10218',103,'CITY_00002275610218','SN');
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
It's hard to say what happens here. Can you share SQL script to populate
your DB?
Regards,
--
Ilya Kasnacheev
пн, 25 мар. 2019 г. в 17:31, NileshKhaire <ng...@gmail.com>:
> Hello Ilya Kasnacheev,
>
> I am agree with your comments.
>
> But when I enabled distributedJoins, I should see result of query
>
> select count(*) from City c join Country cc on cc.country_id !=
> c.country_id;
>
> ==> 2000 , but unfortunately, it is still showing me count = 800 for both
> distributed and non distributed joins.
>
> Can you please explain the reason ?
>
> I test with DBeaver as well as SQLine , result is same.
>
> Thanks,
> Nilesh
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Hello Ilya Kasnacheev,
I am agree with your comments.
But when I enabled distributedJoins, I should see result of query
select count(*) from City c join Country cc on cc.country_id !=
c.country_id;
==> 2000 , but unfortunately, it is still showing me count = 800 for both
distributed and non distributed joins.
Can you please explain the reason ?
I test with DBeaver as well as SQLine , result is same.
Thanks,
Nilesh
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
I can't see your data so I'm not entirely sure, but:
The first query has expected number of records (500 + 300 + 200, every city
is collocated to its country), hence collocated.
The second query does not have expected number of records (expected (200 +
300) + (500 + 300) + (500 + 200) = 2000 but found just 800), displaying how
uncollocated query fails to join tables in full.
I think you're good now.
Note that your data layout is not very good now. Your cache has 1024
partitions but you're only using 3 at maximum. Our planet does not actually
have enough countries to make such collocation optimal.
Optimal collocation assumes that all your affinity keys are equally
frequent, and total number of affinity keys >> number of partitions.
Maybe you should make Country table REPLICATED instead, and have no
collocation by country_id?
Regards,
--
Ilya Kasnacheev
пт, 22 мар. 2019 г. в 19:12, NileshKhaire <ng...@gmail.com>:
> Hello,
>
> Sorry for late response.
>
> If you will see first message of this third, you will understand that
> initially I had used same schema. But collocation were not working.
>
> By the way, now I have again inserted sample data (sent in previous
> messages) as per your suggestion .
>
> 1000 cities and 3 countries.
>
> 1st Country = 500 cities
> 2nd Country = 300 cities
> 3rd Country = 200 cities
>
> CREATE TABLE Country (
> country_id INT(10),
> country_name CHAR(30),
> Continent CHAR(30),
> PRIMARY KEY (country_id)
> ) WITH "template=partitioned, backups=1";
>
>
> CREATE TABLE City (
> city_id INT(15),
> country_id INT(10),
> city_name CHAR(50),
> Dist CHAR(20),
> PRIMARY KEY (city_id,country_id)
> ) WITH "template=partitioned, backups=1, affinityKey=country_id";
>
> output :
>
> select count(*) from City c join Country cc on cc.country_id =
> c.country_id
> ;
> => Count = 1000
>
> select count(*) from City c join Country cc on cc.country_id !=
> c.country_id;
> => Count = 800
>
> Do you think data is collocated ?
>
> So what are the logical explanation for count=1000 for first query and
> count
> = 800 for second query.
>
>
> Thanks,
> Nilesh
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Hello,
Sorry for late response.
If you will see first message of this third, you will understand that
initially I had used same schema. But collocation were not working.
By the way, now I have again inserted sample data (sent in previous
messages) as per your suggestion .
1000 cities and 3 countries.
1st Country = 500 cities
2nd Country = 300 cities
3rd Country = 200 cities
CREATE TABLE Country (
country_id INT(10),
country_name CHAR(30),
Continent CHAR(30),
PRIMARY KEY (country_id)
) WITH "template=partitioned, backups=1";
CREATE TABLE City (
city_id INT(15),
country_id INT(10),
city_name CHAR(50),
Dist CHAR(20),
PRIMARY KEY (city_id,country_id)
) WITH "template=partitioned, backups=1, affinityKey=country_id";
output :
select count(*) from City c join Country cc on cc.country_id = c.country_id
;
=> Count = 1000
select count(*) from City c join Country cc on cc.country_id !=
c.country_id;
=> Count = 800
Do you think data is collocated ?
So what are the logical explanation for count=1000 for first query and count
= 800 for second query.
Thanks,
Nilesh
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Stephen Darlington <st...@gridgain.com>.
But you changed the schema from the documentation. In the guide, CountryCode is the primary key for the country table/cache. In your schema, you have country_id in the Country table and country_code in City.
Two possible solutions:
1. Change the primary key of Country from country_id to country_name
2. Change the affinity key in City from country_name to country_id
The key (pun intended) is that the key for Country and the affinity key for City are the same.
> On 19 Mar 2019, at 08:31, NileshKhaire <ng...@gmail.com> wrote:
>
> Hello,
>
> Thanks for response. I don't think it is necessary to have country_id as key
> in City. Because in the official documentation of ignite here
> https://ignite.apache.org/features/collocatedprocessing.html (See SQL
> schema) they haven't used 'Code CHAR(3)' as key in City table.
>
> By the way, if you know the schema for which collocation is working, please
> share with us .
>
> Thanks
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Hello,
Thanks for response. I don't think it is necessary to have country_id as key
in City. Because in the official documentation of ignite here
https://ignite.apache.org/features/collocatedprocessing.html (See SQL
schema) they haven't used 'Code CHAR(3)' as key in City table.
By the way, if you know the schema for which collocation is working, please
share with us .
Thanks
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Stephen Darlington <st...@gridgain.com>.
> CREATE TABLE Country (
> country_id INT(10),
> country_name CHAR(30),
> Continent CHAR(30),
> PRIMARY KEY (country_id)
> ) WITH "template=partitioned, backups=1";
>
>
> CREATE TABLE City (
> city_id INT(15),
> country_name CHAR(30),
> city_name CHAR(50),
> Dist CHAR(20),
> PRIMARY KEY (city_id,country_name)
> ) WITH "template=partitioned, backups=1, affinityKey=country_name";
This isn’t going to do what you’re expecting. You’re saying distribute the countries using the county_id and the city using he country name. You’re not co-locating the cities and the countries. You may need to enable non-colocated joins to make it work, or City needs to have country_id as part of its key.
Regards,
Stephen
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Attached SQL file is missing, So I am adding content in post directly :
CREATE TABLE Country (
country_id INT(10),
country_name CHAR(30),
Continent CHAR(30),
PRIMARY KEY (country_id)
) WITH "template=partitioned, backups=1";
CREATE TABLE City (
city_id INT(15),
country_name CHAR(30),
city_name CHAR(50),
Dist CHAR(20),
PRIMARY KEY (city_id,country_name)
) WITH "template=partitioned, backups=1, affinityKey=country_name";
insert into Country values('101','Russia','Russia');
insert into Country values('102','India','Asia');
insert into Country values('103','United States','America');
insert into City
values('12554105','Russia','CITY_00000000012554105','SNZa');
insert into City values('20467','Russia','CITY_00000003720467','SN');
insert into City values('10498','Russia','CITY_00000003710498','SNZa');
insert into City values('13617','Russia','CITY_00000003713617','SNZb');
insert into City values('13628','Russia','CITY_00000003713628','SNZd');
insert into City values('10502','Russia','CITY_00000004610502','SN');
insert into City values('703166','Russia','CITY_000000046703166','1');
insert into City values('13656','Russia','CITY_00000007313656','SN');
insert into City values('10507','Russia','CITY_00000007310507','SNZa');
insert into City values('13620','Russia','CITY_00000007313620','SNZc');
insert into City values('13629','Russia','CITY_00000007313629','SNZe');
insert into City values('10508','Russia','CITY_00000009110508','SN');
insert into City values('47403','Russia','CITY_00000009147403','1');
insert into City values('16774','Russia','CITY_00000011616774','SN');
insert into City values('16773','Russia','CITY_00000012516773','SN');
insert into City values('16778','Russia','CITY_00000014316778','SN');
insert into City values('16779','Russia','CITY_00000016116779','SN');
insert into City values('734192','Russia','CITY_000000161734192','1');
insert into City values('699080','Russia','CITY_000000161699080','01Za');
insert into City values('16781','Russia','CITY_00000017016781','SN');
insert into City values('16780','Russia','CITY_00000018916780','SN');
insert into City values('16802','Russia','CITY_00000019816802','SN');
insert into City values('16803','Russia','CITY_00000020416803','SN');
insert into City values('457688','Russia','CITY_000000204457688','1');
insert into City values('16806','Russia','CITY_00000021316806','SN');
insert into City values('16809','Russia','CITY_00000023116809','SN');
insert into City values('16815','Russia','CITY_00000024016815','SN');
insert into City values('6957','Russia','CITY_0000053886957','SN');
insert into City values('6747','Russia','CITY_0000053886747','SNZa');
insert into City values('21048','Russia','CITY_00000538821048','SNZj');
insert into City values('21058','Russia','CITY_00000538821058','01Za');
insert into City values('21068','Russia','CITY_00000545821068','SN');
insert into City values('6749','Russia','CITY_0000054586749','SNZa');
insert into City values('6780','Russia','CITY_0000054586780','SNZb');
insert into City values('113520','Russia','CITY_000005467113520','SN');
insert into City values('6750','Russia','CITY_0000054676750','SNZa');
insert into City values('6820','Russia','CITY_0000054676820','SNZb');
insert into City values('21066','Russia','CITY_00000546721066','SNZc');
insert into City values('6751','Russia','CITY_0000054766751','SNZa');
insert into City values('6821','Russia','CITY_0000054766821','SNAb');
insert into City values('113679','Russia','CITY_000005485113679','SN');
insert into City values('6822','Russia','CITY_0000054856822','SNAb');
insert into City values('6916','Russia','CITY_0000054856916','SNAc');
insert into City values('21064','Russia','CITY_00000548521064','SNAd');
insert into City values('23992','Russia','CITY_00000548523992','SNAe');
insert into City values('223623','Russia','CITY_000005485223623','1');
insert into City values('113562','Russia','CITY_000005494113562','SN');
insert into City values('6823','Russia','CITY_0000054946823','SNAb');
insert into City values('6840','Russia','CITY_0000054946840','SNAc');
insert into City values('21070','Russia','CITY_00000549421070','SNAd');
insert into City values('21859','Russia','CITY_00000549421859','SNAe');
insert into City values('50388','Russia','CITY_00000549450388','SNAf');
insert into City values('122190','Russia','CITY_000005494122190','1');
insert into City values('114520','Russia','CITY_000005494114520','01Aa');
insert into City values('118632','Russia','CITY_000005494118632','01Ab');
insert into City values('121228','Russia','CITY_000005494121228','01Ac');
insert into City values('125075','Russia','CITY_000005494125075','2');
insert into City values('7774147','Russia','CITY_0000054947774147','3');
insert into City values('7764624','Russia','CITY_0000054947764624','03Aa');
insert into City values('8002672','Russia','CITY_0000054948002672','4');
insert into City values('8153942','Russia','CITY_0000054948153942','5');
insert into City values('21857','Russia','CITY_00000576821857','SN');
insert into City values('6837','Russia','CITY_0000057686837','SNAc');
insert into City values('21071','Russia','CITY_00000576821071','SNAd');
insert into City values('8153946','Russia','CITY_0000057688153946','1');
insert into City values('8153949','Russia','CITY_0000057688153949','2');
insert into City values('50701','Russia','CITY_00000578650701','SN');
insert into City values('6825','Russia','CITY_0000057866825','SNAb');
insert into City values('6936','Russia','CITY_0000057866936','SNAc');
insert into City values('21062','Russia','CITY_00000578621062','SNAd');
insert into City values('21854','Russia','CITY_00000578621854','SNBe');
insert into City values('49691','Russia','CITY_00000578649691','SNBf');
insert into City values('50368','Russia','CITY_00000578650368','SNBg');
insert into City values('50673','Russia','CITY_00000578650673','SNBh');
insert into City values('1189982','Russia','CITY_0000057861189982','1');
insert into City values('50699','Russia','CITY_00000579550699','SN');
insert into City values('6826','Russia','CITY_0000057956826','SNBb');
insert into City values('6941','Russia','CITY_0000057956941','SNBc');
insert into City values('21060','Russia','CITY_00000579521060','SNBd');
insert into City values('21855','Russia','CITY_00000579521855','SNBe');
insert into City values('49690','Russia','CITY_00000579549690','SNBf');
insert into City values('50369','Russia','CITY_00000579550369','SNBg');
insert into City values('50484','Russia','CITY_00000579550484','SNBh');
insert into City values('50675','Russia','CITY_00000579550675','SNBi');
insert into City values('1190096','Russia','CITY_0000057951190096','1');
insert into City values('113616','Russia','CITY_000005810113616','SN');
insert into City values('6949','Russia','CITY_0000058106949','SNBd');
insert into City values('21043','Russia','CITY_00000581021043','SNBe');
insert into City values('105484','Russia','CITY_000005865105484','SN');
insert into City values('6951','Russia','CITY_0000058656951','SNBc');
insert into City values('21046','Russia','CITY_00000586521046','SNCd');
insert into City values('24635','Russia','CITY_00000586524635','SNCe');
insert into City values('46650','Russia','CITY_00000586546650','SNCf');
insert into City values('9590616','Russia','CITY_0000058659590616','1');
insert into City values('21084','Russia','CITY_00000608621084','SN');
insert into City values('21082','Russia','CITY_00000609521082','SN');
insert into City values('7397166','Russia','CITY_0000060957397166','1');
insert into City values('21371','Russia','CITY_00000615621371','SNCd');
insert into City values('21373','Russia','CITY_00000617421373','SNCd');
insert into City values('24237','Russia','CITY_00000617424237','SNCe');
insert into City values('24660','Russia','CITY_00000617424660','SNCf');
insert into City values('21703','Russia','CITY_00000619221703','SN');
insert into City values('21734','Russia','CITY_00000620821734','SN');
insert into City values('6816','Russia','CITY_0000062086816','SNCb');
insert into City values('7020','Russia','CITY_0000062087020','SNCc');
insert into City values('21041','Russia','CITY_00000620821041','SNCd');
insert into City values('6065581','Russia','CITY_0000062086065581','1');
insert into City values('21088','Russia','CITY_00000624421088','SN');
insert into City values('987784','Russia','CITY_000006262987784','SN');
insert into City values('21080','Russia','CITY_00000626221080','SNCf');
insert into City values('21811','Russia','CITY_00000626221811','SNCg');
insert into City values('989894','Russia','CITY_000006262989894','1');
insert into City values('7011','Russia','CITY_0000063057011','SN');
insert into City values('21898','Russia','CITY_00000652721898','SN');
insert into City values('6946','Russia','CITY_0000065276946','SNCc');
insert into City values('21858','Russia','CITY_00000652721858','SNCe');
insert into City values('24637','Russia','CITY_00000653624637','SN');
insert into City values('21092','Russia','CITY_00000653621092','SNCc');
insert into City values('21093','Russia','CITY_00000655421093','SNCc');
insert into City values('21372','Russia','CITY_00000656321372','SNCc');
insert into City values('39367','Russia','CITY_00000656339367','SNCf');
insert into City values('21086','Russia','CITY_00000663321086','SN');
insert into City values('6852','Russia','CITY_0000067496852','SNCa');
insert into City values('7109','Russia','CITY_0000068557109','SNCb');
insert into City values('7041','Russia','CITY_0000078637041','SN');
insert into City values('42730','Russia','CITY_00000786342730','01Ca');
insert into City values('6995','Russia','CITY_0000080846995','SN');
insert into City values('13553','Russia','CITY_00000808413553','1');
insert into City values('19104','Russia','CITY_00000808419104','2');
insert into City values('13586','Russia','CITY_00000809313586','SN');
insert into City values('7132','Russia','CITY_0000080937132','SNCb');
insert into City values('7671','Russia','CITY_0000080937671','SNCd');
insert into City values('19058','Russia','CITY_00000809319058','1');
insert into City values('13589','Russia','CITY_00000810913589','SN');
insert into City values('6997','Russia','CITY_0000081096997','SNCa');
insert into City values('19110','Russia','CITY_00000810919110','1');
insert into City values('6998','Russia','CITY_0000081186998','SN');
insert into City values('6999','Russia','CITY_0000081276999','SN');
insert into City values('7000','Russia','CITY_0000081367000','SN');
insert into City values('13607','Russia','CITY_00000814513607','SN');
insert into City values('13588','Russia','CITY_00000814513588','SNCb');
insert into City values('19088','Russia','CITY_00000814519088','1');
insert into City values('7002','Russia','CITY_0000081547002','SN');
insert into City values('7003','Russia','CITY_0000081637003','SN');
insert into City values('7004','Russia','CITY_0000081727004','SN');
insert into City values('13559','Russia','CITY_00000817213559','1');
insert into City values('13610','Russia','CITY_00000817213610','2');
insert into City values('13587','Russia','CITY_00000817213587','02Ca');
insert into City values('7005','Russia','CITY_0000081817005','SN');
insert into City values('7006','Russia','CITY_0000081907006','SN');
insert into City values('7007','Russia','CITY_0000082067007','SN');
insert into City values('13571','Russia','CITY_00000821513571','SN');
insert into City values('7008','Russia','CITY_0000082157008','SNCa');
insert into City values('7009','Russia','CITY_0000082247009','SN');
insert into City values('7056','Russia','CITY_0000082607056','SNCc');
insert into City values('13572','Russia','CITY_00000827913572','SN');
insert into City values('7024','Russia','CITY_0000082797024','SNCa');
insert into City values('7084','Russia','CITY_0000082797084','SNCb');
insert into City values('13581','Russia','CITY_00000827913581','1');
insert into City values('13579','Russia','CITY_00000827913579','01Cb');
insert into City values('33875','Russia','CITY_00000827933875','2');
insert into City values('7042','Russia','CITY_0000082977042','SN');
insert into City values('7078','Russia','CITY_0000083127078','SN');
insert into City values('13582','Russia','CITY_00000831213582','1');
insert into City values('33874','Russia','CITY_00000831233874','2');
insert into City values('7043','Russia','CITY_0000083217043','SNCb');
insert into City values('7044','Russia','CITY_0000083307044','SN');
insert into City values('7030','Russia','CITY_0000083497030','SN');
insert into City values('13550','Russia','CITY_00000834913550','1');
insert into City values('7529','Russia','CITY_0000083497529','01Ca');
insert into City values('13551','Russia','CITY_00000834913551','2');
insert into City values('7104','Russia','CITY_0000083677104','SN');
insert into City values('7040','Russia','CITY_0000083677040','SNCb');
insert into City values('7045','Russia','CITY_0000083767045','SN');
insert into City values('303450','Russia','CITY_000008385303450','SN');
insert into City values('7034','Russia','CITY_0000083857034','SNCa');
insert into City values('7046','Russia','CITY_0000083857046','SNCb');
insert into City values('7072','Russia','CITY_0000083857072','SNEc');
insert into City values('7442','Russia','CITY_0000083947442','SN');
insert into City values('7115','Russia','CITY_0000083947115','SNEb');
insert into City values('7698','Russia','CITY_0000084197698','SN');
insert into City values('7037','Russia','CITY_0000084197037','SNEa');
insert into City values('19113','Russia','CITY_00000844619113','SN');
insert into City values('7039','Russia','CITY_0000084467039','SNEa');
insert into City values('7425','Russia','CITY_0000084467425','SNEb');
insert into City values('7049','Russia','CITY_0000084827049','SN');
insert into City values('7139','Russia','CITY_0000084917139','SN');
insert into City values('7051','Russia','CITY_0000084917051','SNEa');
insert into City values('13548','Russia','CITY_00000849113548','1');
insert into City values('7527','Russia','CITY_0000084917527','01Ea');
insert into City values('7052','Russia','CITY_0000085077052','SN');
insert into City values('7053','Russia','CITY_0000085167053','SN');
insert into City values('7447','Russia','CITY_0000085347447','SN');
insert into City values('7057','Russia','CITY_0000085347057','SNEa');
insert into City values('7537','Russia','CITY_0000085347537','1');
insert into City values('7592','Russia','CITY_0000085347592','2');
insert into City values('7580','Russia','CITY_0000085347580','02Ea');
insert into City values('7647','Russia','CITY_0000085347647','3');
insert into City values('13557','Russia','CITY_00000854313557','SN');
insert into City values('7211','Russia','CITY_0000085437211','SNEc');
insert into City values('13568','Russia','CITY_00000854313568','1');
insert into City values('7137','Russia','CITY_0000087927137','SNEb');
insert into City values('21111','Russia','CITY_00000879221111','SNEc');
insert into City values('21925','Russia','CITY_00000879221925','SNEd');
insert into City values('21947','Russia','CITY_00000879221947','SNEe');
insert into City values('1311335','Russia','CITY_0000088531311335','SNEb');
insert into City values('7144','Russia','CITY_0000090477144','SNEa');
insert into City values('21103','Russia','CITY_00000904721103','SNEb');
insert into City values('7147','Russia','CITY_0000090837147','SNEa');
insert into City values('21116','Russia','CITY_00000908321116','SNEb');
insert into City values('21944','Russia','CITY_00000908321944','SNEc');
insert into City values('7206','Russia','CITY_0000090927206','SN');
insert into City values('7148','Russia','CITY_0000090927148','SNEa');
insert into City values('7205','Russia','CITY_0000091177205','SN');
insert into City values('7150','Russia','CITY_0000091177150','SNEa');
insert into City values('7156','Russia','CITY_0000091357156','SNEa');
insert into City values('7154','Russia','CITY_0000091447154','SN');
insert into City values('7163','Russia','CITY_0000092327163','SNEa');
insert into City values('21101','Russia','CITY_00000923221101','SNEb');
insert into City values('7165','Russia','CITY_0000092507165','SNEa');
insert into City values('7196','Russia','CITY_0000092697196','SNEb');
insert into City values('21114','Russia','CITY_00000926921114','SNEc');
insert into City values('21917','Russia','CITY_00000926921917','SNEd');
insert into City values('7167','Russia','CITY_0000092787167','SN');
insert into City values('7168','Russia','CITY_0000092877168','SNEa');
insert into City values('7169','Russia','CITY_0000092967169','SNEa');
insert into City values('7204','Russia','CITY_0000093027204','SN');
insert into City values('7170','Russia','CITY_0000093027170','SNEa');
insert into City values('7747','Russia','CITY_0000093397747','SN');
insert into City values('7173','Russia','CITY_0000093397173','SNZa');
insert into City values('30141','Russia','CITY_00000933930141','1');
insert into City values('7740','Russia','CITY_0000093757740','SNZc');
insert into City values('7180','Russia','CITY_0000094097180','SN');
insert into City values('7181','Russia','CITY_0000094187181','SN');
insert into City values('7182','Russia','CITY_0000094277182','SN');
insert into City values('7186','Russia','CITY_0000094727186','SN');
insert into City values('7187','Russia','CITY_0000094817187','SN');
insert into City values('7188','Russia','CITY_0000094907188','SN');
insert into City values('7197','Russia','CITY_0000095517197','SNZa');
insert into City values('7208','Russia','CITY_0000095977208','SN');
insert into City values('7213','Russia','CITY_0000096307213','SNZa');
insert into City values('21105','Russia','CITY_00000963021105','SNZb');
insert into City values('7216','Russia','CITY_0000096677216','SNZa');
insert into City values('21107','Russia','CITY_00000966721107','SNZb');
insert into City values('7502','Russia','CITY_0000096947502','SN');
insert into City values('7219','Russia','CITY_0000096947219','SNZa');
insert into City values('7220','Russia','CITY_0000097197220','SNZa');
insert into City values('21118','Russia','CITY_00000971921118','SNZb');
insert into City values('24083','Russia','CITY_00000971924083','SNZc');
insert into City values('7238','Russia','CITY_0000098987238','SNZa');
insert into City values('21133','Russia','CITY_00000989821133','SNZb');
insert into City values('24402','Russia','CITY_00000992224402','SN');
insert into City values('7242','Russia','CITY_0000099227242','SNZa');
insert into City values('21110','Russia','CITY_00000992221110','SNZb');
insert into City values('21940','Russia','CITY_00000992221940','SNZc');
insert into City values('44586','Russia','CITY_00000996844586','SN');
insert into City values('7246','Russia','CITY_0000099687246','SNZa');
insert into City values('21430','Russia','CITY_00000996821430','SNZb');
insert into City values('5910180','Russia','CITY_0000099685910180','1');
insert into City values('44576','Russia','CITY_00001000744576','SN');
insert into City values('7255','Russia','CITY_0000100077255','SNZa');
insert into City values('21431','Russia','CITY_00001000721431','SNZb');
insert into City values('22702','Russia','CITY_00001000722702','SNZc');
insert into City values('23545','Russia','CITY_00001000723545','SNZd');
insert into City values('7742','Russia','CITY_0000100257742','SN');
insert into City values('7261','Russia','CITY_0000100257261','SNZa');
insert into City values('7266','Russia','CITY_0000101047266','SN');
insert into City values('9018','Russia','CITY_0000101049018','1');
insert into City values('9137','Russia','CITY_0000101049137','2');
insert into City values('7271','Russia','CITY_0000101597271','SNZa');
insert into City values('7273','Russia','CITY_0000101777273','SNZa');
insert into City values('7300','Russia','CITY_0000104057300','SN');
insert into City values('7301','Russia','CITY_0000104147301','SN');
insert into City values('7659','Russia','CITY_0000105027659','1');
insert into City values('8546','Russia','CITY_0000105028546','2');
insert into City values('7321','Russia','CITY_0000105757321','SN');
insert into City values('20518','Russia','CITY_00001057520518','1');
insert into City values('13157','Russia','CITY_00001057513157','01Za');
insert into City values('20569','Russia','CITY_00001057520569','2');
insert into City values('24653','Russia','CITY_00001059324653','SN');
insert into City values('21595','Russia','CITY_00001059321595','SNZf');
insert into City values('22690','Russia','CITY_00001061822690','SN');
insert into City values('7350','Russia','CITY_0000106187350','SNZb');
insert into City values('21433','Russia','CITY_00001061821433','SNZc');
insert into City values('46953','Russia','CITY_00001061846953','1');
insert into City values('45551','Russia','CITY_00001061845551','01Za');
insert into City values('46828','Russia','CITY_00001061846828','01Zb');
insert into City values('46832','Russia','CITY_00001061846832','01Zc');
insert into City values('978719','Russia','CITY_000010618978719','2');
insert into City values('1087603','Russia','CITY_0000106181087603','3');
insert into City values('2739779','Russia','CITY_0000106182739779','4');
insert into City values('5708024','Russia','CITY_0000106185708024','5');
insert into City values('5708057','Russia','CITY_0000106185708057','6');
insert into City values('5708101','Russia','CITY_0000106185708101','7');
insert into City values('7339','Russia','CITY_0000106727339','SNZa');
insert into City values('7343','Russia','CITY_0000107247343','SN');
insert into City values('7352','Russia','CITY_0000107517352','SN');
insert into City values('7345','Russia','CITY_0000107517345','SNZa');
insert into City values('7353','Russia','CITY_0000108037353','SNZa');
insert into City values('21435','Russia','CITY_00001080321435','SNZb');
insert into City values('7365','Russia','CITY_0000109197365','SNZa');
insert into City values('360214','Russia','CITY_000010937360214','SN');
insert into City values('1879683','Russia','CITY_0000109371879683','1');
insert into City values('7368','Russia','CITY_0000109467368','SNZa');
insert into City values('721432','Russia','CITY_000010955721432','SNZb');
insert into City values('360223','Russia','CITY_000010964360223','SN');
insert into City values('7371','Russia','CITY_0000109737371','SN');
insert into City values('1879671','Russia','CITY_0000109731879671','1');
insert into City values('1879622','Russia','CITY_0000109731879622','01Za');
insert into City values('14400','Russia','CITY_00001099114400','SN');
insert into City values('14403','Russia','CITY_00001099114403','1');
insert into City values('14497','Russia','CITY_00001099114497','2');
insert into City values('7376','Russia','CITY_0000110247376','SN');
insert into City values('18170','Russia','CITY_00001102418170','1');
insert into City values('8091','Russia','CITY_0000110428091','SNZb');
insert into City values('8438','Russia','CITY_0000110428438','SNZe');
insert into City values('8525','Russia','CITY_0000110428525','SNZf');
insert into City values('21627','Russia','CITY_00001104221627','SNZg');
insert into City values('7389','Russia','CITY_0000111947389','SN');
insert into City values('20884','Russia','CITY_00001119420884','1');
insert into City values('23881','Russia','CITY_00001119423881','2');
insert into City values('23340','Russia','CITY_00001119423340','02Za');
insert into City values('7394','Russia','CITY_0000112287394','SNZa');
insert into City values('21438','Russia','CITY_00001122821438','SNZb');
insert into City values('7396','Russia','CITY_0000112557396','SN');
insert into City values('23924','Russia','CITY_00001125523924','1');
insert into City values('20886','Russia','CITY_00001125520886','01Za');
insert into City values('23337','Russia','CITY_00001125523337','01Zb');
insert into City values('2280111','Russia','CITY_0000112552280111','2');
insert into City values('21441','Russia','CITY_00001126421441','SN');
insert into City values('7397','Russia','CITY_0000112647397','SNZa');
insert into City values('7398','Russia','CITY_0000112737398','SN');
insert into City values('23923','Russia','CITY_00001127323923','1');
insert into City values('20888','Russia','CITY_00001127320888','01Za');
insert into City values('23336','Russia','CITY_00001127323336','01Zb');
insert into City values('7400','Russia','CITY_0000112917400','SN');
insert into City values('20880','Russia','CITY_00001129120880','1');
insert into City values('20893','Russia','CITY_00001129120893','2');
insert into City values('23339','Russia','CITY_00001129123339','3');
insert into City values('2926114','Russia','CITY_0000112912926114','4');
insert into City values('4673798','Russia','CITY_0000112914673798','5');
insert into City values('7402','Russia','CITY_0000113167402','SN');
insert into City values('20891','Russia','CITY_00001131620891','01Za');
insert into City values('23322','Russia','CITY_00001131623322','01Zb');
insert into City values('152495','Russia','CITY_000011316152495','01Zc');
insert into City values('23502','Russia','CITY_00001134323502','SN');
insert into City values('7426','Russia','CITY_0000113437426','SNZb');
insert into City values('21502','Russia','CITY_00001134321502','SNZc');
insert into City values('22742','Russia','CITY_00001134322742','SNZd');
insert into City values('7413','Russia','CITY_0000113987413','SNZa');
insert into City values('7423','Russia','CITY_0000114957423','SNZa');
insert into City values('21492','Russia','CITY_00001160821492','SN');
insert into City values('7453','Russia','CITY_0000116087453','SNZa');
insert into City values('1683111','Russia','CITY_0000116081683111','1');
insert into City values('5708022','Russia','CITY_0000116085708022','2');
insert into City values('5708103','Russia','CITY_0000116085708103','3');
insert into City values('6868077','Russia','CITY_0000116086868077','4');
insert into City values('24652','Russia','CITY_00001162624652','SN');
insert into City values('7464','Russia','CITY_0000116267464','SNZa');
insert into City values('21505','Russia','CITY_00001162621505','SNZb');
insert into City values('7466','Russia','CITY_0000116447466','SNZa');
insert into City values('21509','Russia','CITY_00001164421509','SNZb');
insert into City values('7542','Russia','CITY_0000116717542','SN');
insert into City values('7509','Russia','CITY_0000116717509','SNZb');
insert into City values('7530','Russia','CITY_0000116717530','SNZc');
insert into City values('7884','Russia','CITY_0000116717884','1');
insert into City values('8202','Russia','CITY_0000116718202','2');
insert into City values('8369','Russia','CITY_0000116718369','3');
insert into City values('8536','Russia','CITY_0000116718536','4');
insert into City values('8020','Russia','CITY_0000116808020','SNZb');
insert into City values('7478','Russia','CITY_0000117697478','SNZa');
insert into City values('45288','Russia','CITY_00001177845288','SN');
insert into City values('7479','Russia','CITY_0000117787479','SNZa');
insert into City values('21511','Russia','CITY_00001181121511','SN');
insert into City values('7515','Russia','CITY_0000118117515','SNZb');
insert into City values('46937','Russia','CITY_00001181146937','1');
insert into City values('6008866','Russia','CITY_0000118116008866','02Za');
insert into City values('6013938','Russia','CITY_0000118116013938','02Zb');
insert into City values('6057917','Russia','CITY_0000118116057917','02Zc');
insert into City values('7531','Russia','CITY_0000119187531','SN');
insert into City values('7511','Russia','CITY_0000119187511','SNZa');
insert into City values('7520','Russia','CITY_0000119367520','SNZa');
insert into City values('7521','Russia','CITY_0000119457521','SNZa');
insert into City values('7532','Russia','CITY_0000119637532','SN');
insert into City values('7523','Russia','CITY_0000119637523','SNZa');
insert into City values('7525','Russia','CITY_0000119727525','SN');
insert into City values('7552','Russia','CITY_0000119727552','1');
insert into City values('7882','Russia','CITY_0000119727882','2');
insert into City values('7907','Russia','CITY_0000119727907','3');
insert into City values('8357','Russia','CITY_0000119728357','4');
insert into City values('7526','Russia','CITY_0000119817526','SN');
insert into City values('8169','Russia','CITY_0000119818169','1');
insert into City values('7528','Russia','CITY_0000119907528','SN');
insert into City values('21514','Russia','CITY_00001204121514','SN');
insert into City values('7751','Russia','CITY_0000120417751','SNZb');
insert into City values('46941','Russia','CITY_00001204146941','1');
insert into City values('7548','Russia','CITY_0000120507548','SN');
insert into City values('7564','Russia','CITY_0000121577564','SN');
insert into City values('7894','Russia','CITY_0000124587894','SNZc');
insert into City values('7896','Russia','CITY_0000125377896','SNZb');
insert into City values('7956','Russia','CITY_0000125647956','SNZb');
insert into City values('7941','Russia','CITY_0000125917941','SNZb');
insert into City values('7942','Russia','CITY_0000126077942','SNZb');
insert into City values('7968','Russia','CITY_0000126167968','SNZb');
insert into City values('7736','Russia','CITY_0000126987736','SN');
insert into City values('122085','Russia','CITY_000012704122085','SN');
insert into City values('7738','Russia','CITY_0000127047738','SNZa');
insert into City values('9316','Russia','CITY_0000127049316','SNZb');
insert into City values('122095','Russia','CITY_000012731122095','SN');
insert into City values('7748','Russia','CITY_0000127317748','SNZa');
insert into City values('7749','Russia','CITY_0000127407749','SN');
insert into City values('21535','Russia','CITY_00001276821535','SN');
insert into City values('7753','Russia','CITY_0000127687753','SNZa');
insert into City values('7757','Russia','CITY_0000127957757','SN');
insert into City values('730092','Russia','CITY_000012795730092','01Za');
insert into City values('7759','Russia','CITY_0000128107759','SN');
insert into City values('7760','Russia','CITY_0000128297760','SN');
insert into City values('21539','Russia','CITY_00001284721539','SN');
insert into City values('7762','Russia','CITY_0000128477762','SNZa');
insert into City values('21621','Russia','CITY_00001300421621','SN');
insert into City values('7774','Russia','CITY_0000130047774','SNZa');
insert into City values('8253','Russia','CITY_0000130048253','SNZb');
insert into City values('5943619','Russia','CITY_0000130045943619','01Za');
insert into City values('7777','Russia','CITY_0000130407777','SN');
insert into City values('739681','Russia','CITY_000013040739681','01Za');
insert into City values('21542','Russia','CITY_00001336921542','SN');
insert into City values('7809','Russia','CITY_0000133697809','SNZa');
insert into City values('5707563','Russia','CITY_0000133695707563','1');
insert into City values('5667447','Russia','CITY_0000133695667447','01Za');
insert into City values('5708105','Russia','CITY_0000133695708105','2');
insert into City values('7810','Russia','CITY_0000133787810','SNZa');
insert into City values('21545','Russia','CITY_00001348421545','SN');
insert into City values('7836','Russia','CITY_0000134847836','SNZa');
insert into City values('7838','Russia','CITY_0000135097838','SN');
insert into City values('24659','Russia','CITY_00001351824659','SN');
insert into City values('7839','Russia','CITY_0000135187839','SNZa');
insert into City values('21548','Russia','CITY_00001351821548','SNZb');
insert into City values('22938','Russia','CITY_00001351822938','SNZc');
insert into City values('10823731','Russia','CITY_00001351810823731','1');
insert into City values('21551','Russia','CITY_00001355421551','SN');
insert into City values('7843','Russia','CITY_0000135547843','SNZa');
insert into City values('21554','Russia','CITY_00001358121554','SN');
insert into City values('7845','Russia','CITY_0000135817845','SNZa');
insert into City values('7849','Russia','CITY_0000136157849','SNZa');
insert into City values('21557','Russia','CITY_00001362421557','SN');
insert into City values('7850','Russia','CITY_0000136247850','SNZa');
insert into City values('22875','Russia','CITY_00001364222875','SN');
insert into City values('7852','Russia','CITY_0000136427852','SNZa');
insert into City values('21559','Russia','CITY_00001364221559','SNZb');
insert into City values('7859','Russia','CITY_0000137037859','SN');
insert into City values('733853','Russia','CITY_000013703733853','01Za');
insert into City values('7861','Russia','CITY_0000137217861','SN');
insert into City values('733809','Russia','CITY_000013721733809','01Za');
insert into City values('7863','Russia','CITY_0000137497863','SN');
insert into City values('7865','Russia','CITY_0000137677865','SN');
insert into City values('733748','Russia','CITY_000013767733748','01Za');
insert into City values('7866','Russia','CITY_0000137767866','SN');
insert into City values('733758','Russia','CITY_000013776733758','01Za');
insert into City values('7868','Russia','CITY_0000137857868','SN');
insert into City values('643516','Russia','CITY_000013785643516','01Za');
insert into City values('21563','Russia','CITY_00001382821563','SN');
insert into City values('7872','Russia','CITY_0000138287872','SNZa');
insert into City values('21565','Russia','CITY_00001389121565','SN');
insert into City values('7885','Russia','CITY_0000138917885','SNZa');
insert into City values('7895','Russia','CITY_0000139437895','SNZa');
insert into City values('21567','Russia','CITY_00001394321567','SNZb');
insert into City values('7947','Russia','CITY_0000139707947','SN');
insert into City values('7899','Russia','CITY_0000139707899','SNZa');
insert into City values('202846','Russia','CITY_000013970202846','1');
insert into City values('266065','Russia','CITY_000013970266065','2');
insert into City values('21570','Russia','CITY_00001398921570','SN');
insert into City values('7900','Russia','CITY_0000139897900','SNZa');
insert into City values('3297517','Russia','CITY_0000139893297517','1');
insert into City values('5708020','Russia','CITY_0000139895708020','2');
insert into City values('5708109','Russia','CITY_0000139895708109','3');
insert into City values('7905','Russia','CITY_0000140037905','SNZa');
insert into City values('21572','Russia','CITY_00001400321572','SNZb');
insert into City values('7909','Russia','CITY_0000140307909','SNZa');
insert into City values('21574','Russia','CITY_00001403021574','SNZb');
insert into City values('7912','Russia','CITY_0000140587912','SNZa');
insert into City values('7916','Russia','CITY_0000140857916','SNZa');
insert into City values('21576','Russia','CITY_00001408521576','SNZb');
insert into City values('7949','Russia','CITY_0000140947949','SN');
insert into City values('7917','Russia','CITY_0000140947917','SNZa');
insert into City values('202831','Russia','CITY_000014094202831','1');
insert into City values('23847','Russia','CITY_00001417323847','SN');
insert into City values('7946','Russia','CITY_0000141737946','SNZb');
insert into City values('21578','Russia','CITY_00001417321578','SNZc');
insert into City values('7950','Russia','CITY_0000142347950','SN');
insert into City values('7938','Russia','CITY_0000142347938','SNZa');
insert into City values('51438','Russia','CITY_00001423451438','1');
insert into City values('202840','Russia','CITY_000014234202840','2');
insert into City values('7986','Russia','CITY_0000142527986','SNZb');
insert into City values('7951','Russia','CITY_0000142617951','SN');
insert into City values('7944','Russia','CITY_0000142617944','SNZa');
insert into City values('24188','Russia','CITY_00001430424188','SN');
insert into City values('7954','Russia','CITY_0000143047954','SNZa');
insert into City values('21581','Russia','CITY_00001430421581','SNZb');
insert into City values('23851','Russia','CITY_00001434023851','SN');
insert into City values('7958','Russia','CITY_0000143407958','SNZa');
insert into City values('11221','India','CITY_00000006411221','SN');
insert into City values('32417','India','CITY_00000006432417','1');
insert into City values('101980','India','CITY_000000064101980','2');
insert into City values('498384','India','CITY_000000064498384','3');
insert into City values('1022956','India','CITY_0000000641022956','4');
insert into City values('113710','India','CITY_000006572113710','SN');
insert into City values('157284','India','CITY_000006572157284','1');
insert into City values('131894','India','CITY_000006572131894','01Zc');
insert into City values('223692','India','CITY_000006572223692','2');
insert into City values('360361','India','CITY_000006572360361','3');
insert into City values('1113393','India','CITY_0000065721113393','4');
insert into City values('1837552','India','CITY_0000065721837552','5');
insert into City values('2248350','India','CITY_0000065722248350','6');
insert into City values('7843924','India','CITY_0000065727843924','7');
insert into City values('6904400','India','CITY_0000065726904400','07Za');
insert into City values('7742941','India','CITY_0000065727742941','07Zc');
insert into City values('7742942','India','CITY_0000065727742942','07Zd');
insert into City values('7764627','India','CITY_0000065727764627','07Ze');
insert into City values('8153945','India','CITY_0000065728153945','8');
insert into City values('9590618','India','CITY_0000065729590618','9');
insert into City values('989911','India','CITY_000006943989911','SN');
insert into City values('988217','India','CITY_000006943988217','SNZn');
insert into City values('5710668','India','CITY_0000069435710668','1');
insert into City values('5710673','India','CITY_0000069435710673','2');
insert into City values('5712306','India','CITY_0000069435712306','3');
insert into City values('5721339','India','CITY_0000069435721339','4');
insert into City values('5727239','India','CITY_0000069435727239','5');
insert into City values('6621857','India','CITY_0000069436621857','6');
insert into City values('6869244','India','CITY_0000069436869244','07Za');
insert into City values('7081','India','CITY_0000084737081','SN');
insert into City values('42728','India','CITY_00000847342728','01Za');
insert into City values('21805','India','CITY_00000873821805','SNZe');
insert into City values('19225','India','CITY_00000905619225','SN');
insert into City values('7324','India','CITY_0000090567324','SNZd');
insert into City values('7615','India','CITY_0000090567615','SNZh');
insert into City values('34016','India','CITY_00000905634016','1');
insert into City values('34198','India','CITY_00000905634198','2');
insert into City values('34140','India','CITY_00000932034140','SN');
insert into City values('7312','India','CITY_0000093207312','SNZd');
insert into City values('7333','India','CITY_0000093207333','SNZe');
insert into City values('19231','India','CITY_00000939319231','SN');
insert into City values('7330','India','CITY_0000093937330','SNZc');
insert into City values('7331','India','CITY_0000093937331','SNZd');
insert into City values('33884','India','CITY_00000939333884','1');
insert into City values('33871','India','CITY_00000939333871','01Za');
insert into City values('13611','India','CITY_00001044113611','SN');
insert into City values('7320','India','CITY_0000104417320','SNZc');
insert into City values('7503','India','CITY_0000104417503','SNZd');
insert into City values('19219','India','CITY_00001044119219','1');
insert into City values('34006','India','CITY_00001044134006','2');
insert into City values('8128','India','CITY_0000105488128','SNZb');
insert into City values('11126','India','CITY_00001054811126','SNZc');
insert into City values('11437','India','CITY_00001054811437','SNZd');
insert into City values('20840','India','CITY_00001054820840','SNZe');
insert into City values('21135','India','CITY_00001054821135','SNZf');
insert into City values('21927','India','CITY_00001054821927','SNZg');
insert into City values('21948','India','CITY_00001054821948','SNZh');
insert into City values('24111','India','CITY_00001054824111','SNZi');
insert into City values('24401','India','CITY_00001054824401','SNZj');
insert into City values('69256','India','CITY_00001054869256','SNZk');
insert into City values('69797','India','CITY_00001054869797','SNZl');
insert into City values('69819','India','CITY_00001054869819','SNZm');
insert into City values('34197','India','CITY_00001062734197','SN');
insert into City values('7939','India','CITY_0000107977939','SN');
insert into City values('2066221','India','CITY_0000107972066221','1');
insert into City values('7550','India','CITY_0000119097550','SN');
insert into City values('7510','India','CITY_0000119097510','SNZa');
insert into City values('7524','India','CITY_0000119097524','SNZb');
insert into City values('7543','India','CITY_0000119097543','SNZc');
insert into City values('7551','India','CITY_0000119097551','1');
insert into City values('7898','India','CITY_0000119097898','2');
insert into City values('7883','India','CITY_0000119097883','02Za');
insert into City values('10821','India','CITY_00001190910821','3');
insert into City values('7920','India','CITY_0000119097920','03Za');
insert into City values('7927','India','CITY_0000119097927','03Zb');
insert into City values('10697','India','CITY_00001190910697','03Zc');
insert into City values('122196','India','CITY_000012713122196','SN');
insert into City values('7739','India','CITY_0000127137739','SNZa');
insert into City values('9303','India','CITY_0000127139303','SNZc');
insert into City values('122118','India','CITY_000012713122118','SNZd');
insert into City values('7864','India','CITY_0000137587864','SN');
insert into City values('7869','India','CITY_0000137947869','SN');
insert into City values('8177','India','CITY_0000141828177','SN');
insert into City values('8212','India','CITY_0000141828212','1');
insert into City values('8222','India','CITY_0000141828222','2');
insert into City values('8349','India','CITY_0000141828349','3');
insert into City values('8355','India','CITY_0000141828355','4');
insert into City values('8391','India','CITY_0000141828391','5');
insert into City values('8492','India','CITY_0000141828492','6');
insert into City values('8517','India','CITY_0000141828517','7');
insert into City values('8534','India','CITY_0000141828534','8');
insert into City values('7952','India','CITY_0000142077952','SN');
insert into City values('51502','India','CITY_00001420751502','1');
insert into City values('202865','India','CITY_000014207202865','2');
insert into City values('266066','India','CITY_000014207266066','3');
insert into City values('8460','India','CITY_0000145088460','SN');
insert into City values('739864','India','CITY_000014508739864','01Za');
insert into City values('45519','India','CITY_00001472045519','SN');
insert into City values('45302','India','CITY_00001472045302','SNZaa');
insert into City values('45214','India','CITY_00001472045214','SNZz');
insert into City values('48804','India','CITY_00001472048804','1');
insert into City values('46968','India','CITY_00001472046968','01Zb');
insert into City values('978683','India','CITY_000014720978683','2');
insert into City values('978632','India','CITY_000014720978632','02Zb');
insert into City values('5460781','India','CITY_0000147205460781','3');
insert into City values('5708031','India','CITY_0000147205708031','4');
insert into City values('5672178','India','CITY_0000147205672178','04Za');
insert into City values('5708064','India','CITY_0000147205708064','5');
insert into City values('5712309','India','CITY_0000147205712309','6');
insert into City values('5712311','India','CITY_0000147205712311','7');
insert into City values('5723959','India','CITY_0000147205723959','8');
insert into City values('5723962','India','CITY_0000147205723962','9');
insert into City values('5910185','India','CITY_0000147205910185','10Za');
insert into City values('5916481','India','CITY_0000147205916481','10Zb');
insert into City values('5930898','India','CITY_0000147205930898','10Zc');
insert into City values('5941638','India','CITY_0000147205941638','10Zf');
insert into City values('5967494','India','CITY_0000147205967494','10Zg');
insert into City values('6043059','India','CITY_0000147206043059','10Zk');
insert into City values('6057918','India','CITY_0000147206057918','10Zl');
insert into City values('6065579','India','CITY_0000147206065579','10Zm');
insert into City values('6865565','India','CITY_0000147206865565','10Zo');
insert into City values('8054','India','CITY_0000150938054','SN');
insert into City values('8149','India','CITY_0000150938149','1');
insert into City values('8090','India','CITY_0000153588090','SN');
insert into City values('8194','India','CITY_0000153588194','1');
insert into City values('8344','India','CITY_0000153588344','2');
insert into City values('8772','India','CITY_0000153588772','3');
insert into City values('9986','India','CITY_0000153589986','4');
insert into City values('10007','India','CITY_00001535810007','5');
insert into City values('10583','India','CITY_00001535810583','6');
insert into City values('10676','India','CITY_00001535810676','07Za');
insert into City values('8156','India','CITY_0000157838156','SN');
insert into City values('8213','India','CITY_0000160298213','SN');
insert into City values('17089','India','CITY_00001602917089','02Za');
insert into City values('8394','India','CITY_0000165518394','SN');
insert into City values('8585','India','CITY_0000165518585','1');
insert into City values('10008','India','CITY_00001655110008','2');
insert into City values('10022','India','CITY_00001655110022','3');
insert into City values('10596','India','CITY_00001655110596','4');
insert into City values('8507','India','CITY_0000167468507','SN');
insert into City values('21765','India','CITY_00001711621765','SN');
insert into City values('38543','India','CITY_00001711638543','1');
insert into City values('8739','India','CITY_0000174268739','SNZa');
insert into City values('8743','India','CITY_0000174448743','SNZa');
insert into City values('9006','India','CITY_0000184079006','SN');
insert into City values('9443','India','CITY_0000196009443','SN');
insert into City values('9471','India','CITY_0000196009471','1');
insert into City values('10283','India','CITY_00001960010283','2');
insert into City values('10275','India','CITY_00002290510275','SNZc');
insert into City values('10545','India','CITY_00002310810545','SN');
insert into City values('10299','India','CITY_00002310810299','SNZa');
insert into City values('108587','India','CITY_000023108108587','1');
insert into City values('108638','India','CITY_000023108108638','2');
insert into City values('108991','India','CITY_000023108108991','3');
insert into City values('10349','India','CITY_00002339310349','SN');
insert into City values('10533','India','CITY_00002339310533','1');
insert into City values('10479','India','CITY_00002414310479','SNZa');
insert into City values('13688','India','CITY_00002414313688','SNZc');
insert into City values('20570','India','CITY_00002414320570','SNZf');
insert into City values('21423','India','CITY_00002414321423','SNZg');
insert into City values('178039','India','CITY_000024143178039','SNZm');
insert into City values('191663','India','CITY_000024143191663','SNZn');
insert into City values('246276','India','CITY_000024684246276','SN');
insert into City values('10567','India','CITY_00002468410567','SNZa');
insert into City values('13642','India','CITY_00002468413642','SNZd');
insert into City values('20164','India','CITY_00002468420164','SNZh');
insert into City values('29524','India','CITY_00002468429524','SNZj');
insert into City values('48002','India','CITY_00002468448002','SNZl');
insert into City values('176820','India','CITY_000024684176820','SNZm');
insert into City values('10708','India','CITY_00002512410708','SN');
insert into City values('10865','India','CITY_00002576210865','SNZb');
insert into City values('13456','India','CITY_00002750213456','SN');
insert into City values('11432','India','CITY_00002750211432','SNZb');
insert into City values('11467','India','CITY_00002750211467','SNZc');
insert into City values('11506','India','CITY_00002750211506','SNZd');
insert into City values('11580','India','CITY_00002750211580','SNZe');
insert into City values('11634','India','CITY_00002750211634','SNZf');
insert into City values('12466','India','CITY_00002750212466','SNZg');
insert into City values('12515','India','CITY_00002750212515','SNZh');
insert into City values('12538','India','CITY_00002750212538','SNZi');
insert into City values('12753','India','CITY_00002750212753','SNZj');
insert into City values('12958','India','CITY_00002750212958','SNZk');
insert into City values('13063','India','CITY_00002750213063','SNZl');
insert into City values('13440','India','CITY_00002750213440','SNZm');
insert into City values('19046','India','CITY_00002750219046','1');
insert into City values('11299','India','CITY_00002756611299','SNZa');
insert into City values('11716','India','CITY_00002833411716','SNZc');
insert into City values('1287343','India','CITY_0000283341287343','SNZd');
insert into City values('12179','India','CITY_00002851012179','SN');
insert into City values('1402692','India','CITY_0000285101402692','1');
insert into City values('1410130','India','CITY_0000285101410130','2');
insert into City values('12014','India','CITY_00002898112014','SN');
insert into City values('11533','India','CITY_00002898111533','SNZa');
insert into City values('2353852','India','CITY_0000290692353852','SNZo');
insert into City values('432330','India','CITY_000029236432330','SN');
insert into City values('200312','India','CITY_000029236200312','SNZg');
insert into City values('667956','India','CITY_000029236667956','1');
insert into City values('2500684','India','CITY_0000292362500684','02Zb');
insert into City values('13478','India','CITY_00002929013478','SN');
insert into City values('13077','India','CITY_00002929013077','SNZk');
insert into City values('13450','India','CITY_00002929013450','SNZl');
insert into City values('14821','India','CITY_00002929014821','1');
insert into City values('19060','India','CITY_00002929019060','2');
insert into City values('12180','India','CITY_00002931512180','SN');
insert into City values('2027657','India','CITY_0000293152027657','1');
insert into City values('2760482','India','CITY_0000293152760482','2');
insert into City values('2813435','India','CITY_0000293152813435','3');
insert into City values('6479108','India','CITY_0000293156479108','4');
insert into City values('10948004','India','CITY_00002931510948004','5');
insert into City values('10992424','India','CITY_00002931510992424','6');
insert into City values('10992421','India','CITY_00002931510992421','06Za');
insert into City values('42894','India','CITY_00002936042894','SN');
insert into City values('23335','India','CITY_00002936023335','SNZg');
insert into City values('23464','India','CITY_00002936023464','SNZh');
insert into City values('23935','India','CITY_00002936023935','SNZi');
insert into City values('45641','India','CITY_00002936045641','1');
insert into City values('45733','India','CITY_00002936045733','02Za');
insert into City values('42902','India','CITY_00002939742902','SN');
insert into City values('23321','India','CITY_00002939723321','SNZf');
insert into City values('23463','India','CITY_00002939723463','SNZg');
insert into City values('23479','India','CITY_00002939723479','SNZh');
insert into City values('23936','India','CITY_00002939723936','SNZi');
insert into City values('45643','India','CITY_00002939745643','1');
insert into City values('45734','India','CITY_00002939745734','02Za');
insert into City values('12041','India','CITY_00002989212041','SN');
insert into City values('11720','India','CITY_00002989211720','SNZa');
insert into City values('12164','India','CITY_00003034812164','SN');
insert into City values('1404304','India','CITY_0000303481404304','1');
insert into City values('1410362','India','CITY_0000303481410362','2');
insert into City values('10832862','India','CITY_00003034810832862','3');
insert into City values('11023406','India','CITY_00003034811023406','4');
insert into City values('21478','India','CITY_00003035721478','SN');
insert into City values('11811','India','CITY_00003035711811','SNZa');
insert into City values('12166','India','CITY_00003049012166','SN');
insert into City values('2027629','India','CITY_0000304902027629','1');
insert into City values('2418908','India','CITY_0000304902418908','2');
insert into City values('2760711','India','CITY_0000304902760711','3');
insert into City values('3606258','India','CITY_0000304903606258','4');
insert into City values('11023403','India','CITY_00003049011023403','5');
insert into City values('11037609','India','CITY_00003049011037609','6');
insert into City values('11047721','India','CITY_00003049011047721','7');
insert into City values('11047722','India','CITY_00003049011047722','8');
insert into City values('11945','India','CITY_00003099511945','SN');
insert into City values('12165','India','CITY_00003099512165','1');
insert into City values('11970','India','CITY_00003107311970','SNZb');
insert into City values('12162','India','CITY_00003133812162','SN');
insert into City values('11996','India','CITY_00003133811996','SNZa');
insert into City values('10832863','India','CITY_00003133810832863','01Za');
insert into City values('20516','India','CITY_00003152320516','SN');
insert into City values('12040','India','CITY_00003152312040','SNZa');
insert into City values('13686','India','CITY_00003152313686','SNZc');
insert into City values('20171','India','CITY_00003152320171','SNZf');
insert into City values('175535','India','CITY_000031523175535','01Za');
insert into City values('12181','India','CITY_00003206312181','SN');
insert into City values('12182','India','CITY_00003207212182','SN');
insert into City values('10832866','India','CITY_00003207210832866','1');
insert into City values('30298','India','CITY_00003230030298','SN');
insert into City values('12758','India','CITY_00003230012758','SNZb');
insert into City values('28357','India','CITY_00003230028357','SNZc');
insert into City values('30297','India','CITY_00003236430297','SN');
insert into City values('12759','India','CITY_00003236412759','SNZb');
insert into City values('6695542','India','CITY_0000323646695542','1');
insert into City values('30300','India','CITY_00003247030300','SN');
insert into City values('12760','India','CITY_00003247012760','SNZb');
insert into City values('28350','India','CITY_00003247028350','SNZc');
insert into City values('6694405','India','CITY_0000324706694405','1');
insert into City values('8868465','India','CITY_0000324708868465','2');
insert into City values('30283','India','CITY_00003260130283','SN');
insert into City values('12761','India','CITY_00003260112761','SNZb');
insert into City values('12393','India','CITY_00003262912393','SN');
insert into City values('26171','India','CITY_00003262926171','1');
insert into City values('27957','India','CITY_00003262927957','2');
insert into City values('116878','India','CITY_000032629116878','3');
insert into City values('592111','India','CITY_000032629592111','4');
insert into City values('592382','India','CITY_000032629592382','5');
insert into City values('1654508','India','CITY_0000326291654508','6');
insert into City values('2964255','India','CITY_0000326292964255','7');
insert into City values('5803679','India','CITY_0000326295803679','8');
insert into City values('33361','India','CITY_00003270833361','SN');
insert into City values('12762','India','CITY_00003270812762','SNZb');
insert into City values('28362','India','CITY_00003270828362','SNZc');
insert into City values('30281','India','CITY_00003270830281','SNZd');
insert into City values('210483','India','CITY_000032708210483','1');
insert into City values('304235','India','CITY_000032708304235','2');
insert into City values('33363','India','CITY_00003275333363','SN');
insert into City values('12763','India','CITY_00003275312763','SNZb');
insert into City values('28361','India','CITY_00003275328361','SNZc');
insert into City values('28384','India','CITY_00003275328384','SNZd');
insert into City values('30285','India','CITY_00003275330285','SNZe');
insert into City values('210484','India','CITY_000032753210484','1');
insert into City values('278852','India','CITY_000032753278852','2');
insert into City values('30276','India','CITY_00003281430276','SN');
insert into City values('12764','India','CITY_00003281412764','SNZb');
insert into City values('28394','India','CITY_00003286928394','SN');
insert into City values('12765','India','CITY_00003286912765 ','SNZb');
insert into City values('87745','India','CITY_00003286987745','1');
insert into City values('210571','India','CITY_000032869210571','2');
insert into City values('33372','India','CITY_00003296633372','SN');
insert into City values('12766','India','CITY_00003296612766','SNZb');
insert into City values('28395','India','CITY_00003296628395','SNZc');
insert into City values('21069','United
States','CITY_00000722521069','SNZc');
insert into City values('21067','United
States','CITY_00000725221067','SNZc');
insert into City values('21059','United
States','CITY_00000726121059','SNZd');
insert into City values('223633','United
States','CITY_000007368223633','SNZd');
insert into City values('21072','United
States','CITY_00000752621072','SNZc');
insert into City values('21063','United
States','CITY_00000753521063','SNZc');
insert into City values('21061','United
States','CITY_00000759921061','SNZd');
insert into City values('21045','United
States','CITY_00000763221045','SNZc');
insert into City values('21047','United
States','CITY_00000765021047','SNZb');
insert into City values('304105','United
States','CITY_000008552304105','2');
insert into City values('10292','United States','CITY_00000857010292','SN');
insert into City values('10296','United States','CITY_00000857010296','1');
insert into City values('13558','United States','CITY_00000857013558','2');
insert into City values('13570','United States','CITY_00000857013570','3');
insert into City values('7080','United States','CITY_0000086597080','SN');
insert into City values('13573','United States','CITY_00000865913573','1');
insert into City values('13583','United States','CITY_00000865913583','2');
insert into City values('30133','United States','CITY_00000865930133','3');
insert into City values('33878','United States','CITY_00000865933878','4');
insert into City values('7089','United States','CITY_0000086687089','SN');
insert into City values('30128','United States','CITY_00000866830128','1');
insert into City values('7101','United States','CITY_0000087107101','SN');
insert into City values('19237','United States','CITY_00000871019237','1');
insert into City values('20185','United
States','CITY_00000871020185','02Za');
insert into City values('7105','United States','CITY_0000087477105','SN');
insert into City values('13608','United States','CITY_00000874713608','1');
insert into City values('13609','United States','CITY_00000874713609','2');
insert into City values('19167','United States','CITY_00000874719167','3');
insert into City values('7107','United States','CITY_0000087567107','SN');
insert into City values('30130','United States','CITY_00000875630130','1');
insert into City values('7108','United States','CITY_0000087657108','SN');
insert into City values('19238','United States','CITY_00000876519238','1');
insert into City values('7110','United States','CITY_0000087747110','SN');
insert into City values('13560','United States','CITY_00000877413560','1');
insert into City values('19170','United States','CITY_00000877419170','2');
insert into City values('7113','United States','CITY_0000088087113','SN');
insert into City values('22918','United States','CITY_00000880822918','1');
insert into City values('7504','United States','CITY_0000088267504','SN');
insert into City values('23019','United States','CITY_00000882623019','1');
insert into City values('23020','United States','CITY_00000882623020','2');
insert into City values('7116','United States','CITY_0000088357116','SN');
insert into City values('13552','United States','CITY_00000883513552','1');
insert into City values('7117','United States','CITY_0000088447117','SN');
insert into City values('30123','United States','CITY_00000884430123','1');
insert into City values('13584','United States','CITY_00000886213584','SN');
insert into City values('13585','United States','CITY_00000886213585','1');
insert into City values('30134','United States','CITY_00000886230134','2');
insert into City values('7120','United States','CITY_0000088717120','SN');
insert into City values('30124','United States','CITY_00000887130124','1');
insert into City values('8098','United States','CITY_0000088808098','SN');
insert into City values('23022','United States','CITY_00000888023022','1');
insert into City values('30116','United States','CITY_00000888030116','3');
insert into City values('7122','United States','CITY_0000088997122','SN');
insert into City values('22921','United States','CITY_00000889922921','1');
insert into City values('8057','United States','CITY_0000089058057','SN');
insert into City values('23021','United States','CITY_00000890523021','1');
insert into City values('7124','United States','CITY_0000089147124','SN');
insert into City values('19236','United States','CITY_00000891419236','1');
insert into City values('7719','United States','CITY_0000089237719','SN');
insert into City values('30120','United States','CITY_00000892330120','3');
insert into City values('7140','United States','CITY_0000089327140','SN');
insert into City values('7141','United States','CITY_0000089327141','1');
insert into City values('13549','United States','CITY_00000893213549','2');
insert into City values('7517','United States','CITY_0000089507517','SN');
insert into City values('7541','United States','CITY_0000089507541','1');
insert into City values('7593','United States','CITY_0000089507593','2');
insert into City values('13556','United States','CITY_00000895013556','3');
insert into City values('7129','United States','CITY_0000089697129','SN');
insert into City values('13554','United States','CITY_00000896913554','1');
insert into City values('19149','United States','CITY_00000896919149','2');
insert into City values('19168','United States','CITY_00000897819168','SN');
insert into City values('19169','United States','CITY_00000897819169','2');
insert into City values('19116','United States','CITY_00000898719116','SN');
insert into City values('19117','United States','CITY_00000898719117','1');
insert into City values('7135','United States','CITY_0000089967135','SN');
insert into City values('30113','United States','CITY_00000899630113','2');
insert into City values('19176','United States','CITY_00000900119176','SN');
insert into City values('19180','United States','CITY_00000900119180','1');
insert into City values('7207','United States','CITY_0000095607207','SNZb');
insert into City values('30136','United States','CITY_00000972830136','1');
insert into City values('30137','United States','CITY_00001001630137','1');
insert into City values('30138','United States','CITY_00001004330138','1');
insert into City values('7269','United States','CITY_0000101137269','SN');
insert into City values('9161','United States','CITY_0000101139161','1');
insert into City values('130660','United
States','CITY_000010113130660','2');
insert into City values('34167','United States','CITY_00001043234167','1');
insert into City values('7322','United States','CITY_0000105847322','SN');
insert into City values('7327','United States','CITY_0000105847327','1');
insert into City values('7328','United States','CITY_0000105847328','2');
insert into City values('7377','United States','CITY_0000109287377','SNZb');
insert into City values('7375','United States','CITY_0000110157375','SN');
insert into City values('14405','United States','CITY_00001101514405','1');
insert into City values('14498','United States','CITY_00001101514498','2');
insert into City values('7380','United States','CITY_0000110517380','SN');
insert into City values('18173','United States','CITY_00001105118173','1');
insert into City values('18183','United States','CITY_00001105118183','2');
insert into City values('7414','United States','CITY_0000114047414','SNZa');
insert into City values('7424','United States','CITY_0000115017424','SNZa');
insert into City values('6868080','United
States','CITY_0000115296868080','SNZc');
insert into City values('7545','United States','CITY_0000120327545','SN');
insert into City values('7886','United States','CITY_0000120327886','1');
insert into City values('7549','United States','CITY_0000120697549','SN');
insert into City values('7658','United States','CITY_0000124037658','SN');
insert into City values('7687','United States','CITY_0000124677687','SN');
insert into City values('7691','United States','CITY_0000124947691','SN');
insert into City values('7694','United States','CITY_0000125007694','SN');
insert into City values('7696','United States','CITY_0000125197696','SN');
insert into City values('7699','United States','CITY_0000125287699','SN');
insert into City values('7704','United States','CITY_0000125467704','SN');
insert into City values('7707','United States','CITY_0000125557707','SN');
insert into City values('7709','United States','CITY_0000125737709','SN');
insert into City values('7710','United States','CITY_0000125827710','SN');
insert into City values('7731','United States','CITY_0000126707731','SN');
insert into City values('22917','United States','CITY_00001267022917','1');
insert into City values('6868081','United
States','CITY_0000142896868081','SNZd');
insert into City values('122148','United
States','CITY_000014331122148','SN');
insert into City values('7982','United States','CITY_0000145267982','SN');
insert into City values('7989','United States','CITY_0000145807989','SN');
insert into City values('7995','United States','CITY_0000146327995','SN');
insert into City values('202944','United
States','CITY_000014632202944','1');
insert into City values('266067','United
States','CITY_000014632266067','2');
insert into City values('8001','United States','CITY_0000146878001','SN');
insert into City values('11844','United States','CITY_00001468711844','1');
insert into City values('202958','United
States','CITY_000014687202958','2');
insert into City values('8003','United States','CITY_0000147028003','SN');
insert into City values('40285','United States','CITY_00001470240285','1');
insert into City values('51444','United States','CITY_00001470251444','2');
insert into City values('202969','United
States','CITY_000014702202969','3');
insert into City values('122225','United
States','CITY_000014739122225','1');
insert into City values('8013','United States','CITY_0000147848013','SN');
insert into City values('51508','United States','CITY_00001478451508','1');
insert into City values('204081','United
States','CITY_000014784204081','2');
insert into City values('8121','United States','CITY_0000148548121','SN');
insert into City values('739882','United
States','CITY_000014854739882','01Za');
insert into City values('8688','United States','CITY_0000151818688','SNZb');
insert into City values('8690','United States','CITY_0000151908690','SNZb');
insert into City values('8689','United States','CITY_0000152068689','SNZb');
insert into City values('8692','United States','CITY_0000152158692','SNZb');
insert into City values('9208','United States','CITY_0000155079208','SN');
insert into City values('9666','United States','CITY_0000155079666','1');
insert into City values('9667','United States','CITY_0000155079667','2');
insert into City values('9668','United States','CITY_0000155079668','3');
insert into City values('1059913','United
States','CITY_0000155071059913','4');
insert into City values('3774117','United
States','CITY_0000155073774117','5');
insert into City values('8765368','United
States','CITY_0000155078765368','6');
insert into City values('8185','United States','CITY_0000159698185','SN');
insert into City values('8221','United States','CITY_0000159698221','1');
insert into City values('8224','United States','CITY_0000159698224','2');
insert into City values('8351','United States','CITY_0000159698351','3');
insert into City values('8352','United States','CITY_0000159698352','4');
insert into City values('8358','United States','CITY_0000159698358','5');
insert into City values('8416','United States','CITY_0000159698416','6');
insert into City values('8431','United States','CITY_0000159698431','7');
insert into City values('8509','United States','CITY_0000159698509','8');
insert into City values('8519','United States','CITY_0000159698519','9');
insert into City values('8257','United States','CITY_0000161718257','SN');
insert into City values('560241','United
States','CITY_000016171560241','01Zd');
insert into City values('1378533','United
States','CITY_0000167731378533','5');
insert into City values('1489455','United
States','CITY_0000167731489455','6');
insert into City values('1633832','United
States','CITY_0000167731633832','7');
insert into City values('1678805','United
States','CITY_0000167731678805','8');
insert into City values('1788137','United
States','CITY_0000167731788137','9');
insert into City values('2026359','United
States','CITY_0000167732026359','10');
insert into City values('2749858','United
States','CITY_0000167732749858','11');
insert into City values('10312994','United
States','CITY_00001677310312994','12');
insert into City values('10312986','United
States','CITY_00001677310312986','12Za');
insert into City values('10312989','United
States','CITY_00001677310312989','12Zb');
insert into City values('16772','United States','CITY_00001678216772','SN');
insert into City values('16874','United States','CITY_00001678216874','1');
insert into City values('18279','United States','CITY_00001678218279','2');
insert into City values('18280','United States','CITY_00001678218280','3');
insert into City values('18459','United States','CITY_00001678218459','4');
insert into City values('21504','United States','CITY_00001678221504','5');
insert into City values('21785','United States','CITY_00001678221785','6');
insert into City values('1828357','United
States','CITY_0000167821828357','9');
insert into City values('2060302','United
States','CITY_0000167822060302','10');
insert into City values('3126785','United
States','CITY_0000167823126785','11');
insert into City values('21484','United States','CITY_00001714321484','SN');
insert into City values('21486','United States','CITY_00001714321486','1');
insert into City values('21487','United States','CITY_00001714321487','2');
insert into City values('21489','United States','CITY_00001714321489','3');
insert into City values('21490','United States','CITY_00001714321490','4');
insert into City values('131677','United
States','CITY_000017143131677','5');
insert into City values('9285','United States','CITY_0000189209285','SN');
insert into City values('9347','United States','CITY_0000191969347','SN');
insert into City values('9892','United States','CITY_0000212169892','SN');
insert into City values('10046','United States','CITY_00002184510046','SN');
insert into City values('10324','United States','CITY_00002184510324','1');
insert into City values('10336','United States','CITY_00002184510336','2');
insert into City values('10374','United States','CITY_00002184510374','3');
insert into City values('10540','United States','CITY_00002184510540','4');
insert into City values('110420','United
States','CITY_000021845110420','5');
insert into City values('8677601','United
States','CITY_0000218458677601','6');
insert into City values('10058','United States','CITY_00002199710058','SN');
insert into City values('10467','United States','CITY_00002199710467','1');
insert into City values('10598','United States','CITY_00002199710598','2');
insert into City values('10188','United States','CITY_00002265910188','SN');
insert into City values('10210','United States','CITY_00002270110210','SN');
insert into City values('10216','United States','CITY_00002273810216','SN');
insert into City values('10218','United States','CITY_00002275610218','SN');
Thanks,
Nilesh
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Please find attached SQL file .
Result of query:
select count(*) from city c join country co on c.country_name =
co.country_name;
= 0 Rows
select count(*) from city c join country co on c.country_name !=
co.country_name;
= 1200 Rows
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Looks like affinity collocation does not work. Can you share country-city
script (and DDL) so I could check?
Regards,
--
Ilya Kasnacheev
пт, 15 мар. 2019 г. в 19:16, NileshKhaire <ng...@gmail.com>:
> Hello,
>
> I have inserted 1000 cities now and 3 countries.
>
> 1st Country = 500 cities
> 2nd Country = 300 cities
> 3rd Country = 200 cities
>
> After executing first query
>
> select * from City c join Country cc on cc.Code = c.CountryCode; *record
> count is 0*
>
> after executing second query
>
> select * from City c join Country cc on cc.Code != c.CountryCode;* record
> count is 1200*
>
> This is completely opposite to your result , in first query you have 0
> records and for second query you have some records.
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Hello,
I have inserted 1000 cities now and 3 countries.
1st Country = 500 cities
2nd Country = 300 cities
3rd Country = 200 cities
After executing first query
select * from City c join Country cc on cc.Code = c.CountryCode; *record
count is 0*
after executing second query
select * from City c join Country cc on cc.Code != c.CountryCode;* record
count is 1200*
This is completely opposite to your result , in first query you have 0
records and for second query you have some records.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Well, maybe both entries landed on the same node. You will need to have
around a dozen entries (each table) to reliably observe this difference.
Regards,
--
Ilya Kasnacheev
пт, 15 мар. 2019 г. в 17:45, NileshKhaire <ng...@gmail.com>:
> Hello Ilya Kasnacheev,
>
> I executed both queries, and it gives me same result. It would be great if
> you could explain this in more detail .
>
> Thanks,
> Nilesh
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Finding collocated data in ignite nodes
Posted by NileshKhaire <ng...@gmail.com>.
Hello Ilya Kasnacheev,
I executed both queries, and it gives me same result. It would be great if
you could explain this in more detail .
Thanks,
Nilesh
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Finding collocated data in ignite nodes
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
You can't really check it from SQL when it works, but you can compare it
with non-collocated requests:
0: jdbc:ignite:thin://localhost> select * from City c join Country cc on
cc.Code = c.CountryCode;
ID 101
NAME Mumbai
COUNTRYCODE IND
DISTRICT NA
POPULATION 0
CODE IND
NAME India
CONTINENT Asia
REGION Asia
SURFACEAREA 0.0
POPULATION 0
CAPITAL 0
ID 102
NAME Moscow
COUNTRYCODE RU
DISTRICT NA
POPULATION 0
CODE RU
NAME Rusia
CONTINENT Rusia
REGION Rusia
SURFACEAREA 0.0
POPULATION 0
CAPITAL 0
2 rows selected (0,021 seconds)
but
0: jdbc:ignite:thin://localhost> select * from City c join Country cc on
cc.Code != c.CountryCode;
No rows selected (0,013 seconds)
You would expect that latter query will return two rows as former, but it
returns zero since in former case data is collocated and in latter it's not.
Regards,
--
Ilya Kasnacheev
ср, 13 мар. 2019 г. в 13:13, NileshKhaire <ng...@gmail.com>:
> I am trying to collocate data based on SQL given in this link
>
> https://ignite.apache.org/features/collocatedprocessing.html .
>
> I have created 2 caches 'Country' and 'City' using following SQLs.
>
> -- Cache Country
> CREATE TABLE Country (
> Code CHAR(3),
> Name CHAR(52),
> Continent CHAR(50),
> Region CHAR(26),
> SurfaceArea DECIMAL(10,2),
> Population INT(11),
> Capital INT(11),
> PRIMARY KEY (Code)) WITH "template=partitioned, backups=1";
>
> --Cache City
> CREATE TABLE City (
> ID INT(11),
> Name CHAR(35),
> CountryCode CHAR(3),
> District CHAR(20),
> Population INT(11),
> PRIMARY KEY (ID, CountryCode)
> ) WITH "template=partitioned, backups=1, affinityKey=CountryCode";
>
> I have inserted some sample records, for example :
>
> insert into Country values('RU','Rusia','Rusia','Rusia',0.0,00,0);
> insert into Country values('IND','India','Asia','Asia',0.0,00,0);
>
>
> insert into City values(101,'Mumbai','IND','NA',00);
> insert into City values(102,'Moscow','RU','NA',00);
>
> I have started 2 ignite(on different machines) node to collocate data on
> different nodes. After finding records presents on node 0 through visor
>
> cache -scan -c=@c0 -id8=@n0
>
> I can see both cities Mumbai and Moscow are present on node 0 (n0) as well
> as on node 1. I was expecting that cities of India will be collocated on
> node 0 and cities of Rusia will collocated on node 1 but not both on the
> same node.
>
> My questions are :
>
> 1. I am doing anything wrong while collocating the data .
> 2. Running visor cache -scan command is correct way to find collocated data
> on nodes ?
> 3. If this is not correct way then, how can we find which data is
> collocated
> on node 0 and node 1 ?
> 4. Let's say data is collocated on node 0 (cities of India) and node 1
> (cities on Russia) . What will happen if one of the node will be
> disconnected from cluster ? Will there be a data loss ? After restarting
> the
> node, Will data be collocated again ?
>
> Thank you in Advance.
>
> PS : I have already asked this question on stack overflow but didn't get
> answer
>
> https://stackoverflow.com/questions/55100844/finding-collocated-data-in-ignite
> <
> https://stackoverflow.com/questions/55100844/finding-collocated-data-in-ignite>
>
>
> I have already tried collocated=true and local=true approaches . I also
> tried to remove backups=1 flag from SQL query , starting 3rd node but
> nothing is working. Hope I will get answer here :)
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>