Finding collocated data in ignite nodes

classic Classic list List threaded Threaded
17 messages Options
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
stephendarlington stephendarlington
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
stephendarlington stephendarlington
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]> 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/


Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/
Nilesh K Nilesh K
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Finding collocated data in ignite nodes

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 <[hidden email]>:
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/