Categories
数据库

Presto兼容Hive语法语义的一些改动

Presto是一款优秀的交互式查询解决方案，并且已经被诸多公司证实过，因为其数倍于Hive的查询速度的优势，团队决定引入Presto用于交互式查询场景。

但是因为迁移成本和服务器成本，Presto和Hive需要有一段长期共存的时间。我们的解决方案是，将Presto的语法和语义向Hive靠拢，整个产品对外提供Hive的语法和语义。本文介绍Presto的语法和语义向Hive兼容的一些改造工作。

语法部分

语法部分的兼容思路是修改SQL，我们定义了一个SQL Rewriter将用户发过来的SQL进行改写，因为整个产品对外提供Hive的语法标准，所以SQL Rewriter需要将Hive的语法改写成Presto的语法。

一开始的解决方案是通过Apache Calcite，因为它提供了Hive的语法的改写功能，但是我们发现它的改写器BUG太多，我们修了几个BUG后，就放弃了该方案。以下是我们修的BUG：CALCITE-3220、CALCITE-3247、CALCITE-3282。

新的方案是自定义一个SQL语法解析器，然后修改语法。我们的方案选型是ANTLR4，因为ANTLR4支持SQL语法的修改。Spark的语法跟Hive是高度一致的，并且Spark的语法文件也是基于ANTLR4的，所以我们直接使用了Spark的语法文件。

以下是语法部分的改动：

1. Presto不支持’%’运算符

改写前：
select 1 % 2

改写后：
select mod(1, 2)

2.Presto不支持regexp、rlike语法

改写前：
select map['field'] rlike '.*'
select map['field'] regexp '.*'

改写后：
select regexp_like(map['field'], '.*')

3.数组定义方式

改写前：
select array (1, 2)

改写后：
select array [1, 2]

4.变量名的quoting方案

改写前：
select `col`

改写后：
select "col"

5.变量名是否能以数字开头

改写前：
select 1col

改写后：
select "1col"

6.Presto不支持LATERAL VIEW语法

改写前：
SELECT student, score FROM tests LATERAL VIEW explode(scores) t AS score

改写后：
SELECT student, score FROM tests cross join unnest(scores) as t (score)

7.Presto不支持cluster by、distribute by语法

改写前：
SELECT student, score FROM tests cluster by student
SELECT student, score FROM tests distribute by student

改写后：
SELECT student, score FROM tests

8.Presto不支持sort by语法

改写前：
SELECT student, score FROM tests sort by student

改写后：
SELECT student, score FROM tests order by student

9.Presto如果函数名包含’.’则需要Quoting

改写前：
select a.b(1)

改写后：
select "a.b"(1)

10.Presto的字符串常量不能用双引号Quoting

改写前：
select "stringLiteral"

改写后：
select 'stringLiteral'

11正则表达式转义方案不同

改写前：
select RLIKE( '1 2', '\\S')

改写后：
select regexp_like( '1 2', '\S')

12.Presto不支持String数据类型

改写前：
select cast (1 as string)

改写后：
select cast(1 as varchar)

语义部分

对于语义部分的处理Hive和Presto有着截然相反的味道，Hive对于语义的处理显得更“包容”，相反Presto显得更“严格”。比如数组越界，Hive会当做null处理，而Presto会中断整个查询；再比如某一个数据文件损坏或者缺失，Hive会忽略该文件，而Presto依然会中断查询。

语义部分的改写需要修改Presto内核，由于Hive和Presto截然相反的理念，所以需要改写的细节是繁多的，我们只处理了查询频率较多的一些场景：

支持查询Hive View

因为与Hive的语法语义处理不同，所以Presto是不支持Hive View查询的，但是我们改造的目标是将Presto的语法语义向Hive靠拢，所以自然改造后的Presto是可以查询Hive View的。

改造思路是将Hive view按照Presto view处理，我们的处理方式参考了社区的一个方案#9031。并且我们将上边的SQL Rewriter内嵌到了Hive view处理的流程中，以修改Hive语法。

隐式类型转换

对于隐式类型转换社区也有一个提案#116，可以看到社区坚持ANSI SQL标准，对于隐式类型转换的支持是有所顾虑的，但是支持隐式类型转换无疑是公司内部的迫切需求。

我们知道通过显示添加cast是可以实现字符串和整醒家族的类型转换的，那么思路就比较明确了，在解析SQL的时候添加cast。

改动的类是ExpressionAnalyzer，该类的作用是给AST做类型检查，目前改动点主要是：

1.算术二元运算符

select 1 + '2'
3

2.比较运算符

select 2 > '1'
true

3.between

select 2 between '1' and 3
true

4.in

// TODO check
select '2' in array(1,2)
true
空值处理

1.数组越界

select array(1,2)[-1]
NULL

2.Map中字段不存在

select map(ARRAY('1','3'), ARRAY('2','4'))['6']
NULL

3.一些数组函数的下标越界

select slice(ARRAY(1,2), 3, 1)
NULL

select element_at(ARRAY(1,2), 3)
NULL
其它语义上的改造

1.整形相除返回结果为Double类型

select 1/2
0.5

2.数组下标从零开始

select ARRAY(1,2)[0]
1

3.Map查询不准确

实践中有用户反馈查询Map类型的字段有不准确的现象，通过调查发现其实是Presto的一个bug，我们将其进行了修复，可以参考#1321。

小结

通过大量线上查询统计，经过改造后的Presto的语法和语义与Hive的兼容率为99%。目前不兼容的场景主要集中在函数上，一是Hive中有大量的内置函数还没有迁移到Presto中；二是已经迁移过来的函数在隐式类型转换上还需要做进一步兼容。

版权声明：文章为作者辛勤劳动的成果，转载请注明作者与出处。

8,056 replies on “Presto兼容Hive语法语义的一些改动”

Доброго времени суток друзья
Наша компания предоставялет интим услуги, лучшие телки с буферами, голые письки, отборная порнушка, анал, лесбиянки, все на нашем сайте.
Наша сайт – https://ecomarket.ru/

Заходи и дрочи по полной !!!

Hello there I am so glad I found your website, I really found you by mistake, while I was looking
on Askjeeve for something else, Regardless I am here now and would just like to say thanks for a incredible post
and a all round entertaining blog (I also love the theme/design), I don’t have time to
look over it all at the moment but I have saved it and also
included your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the fantastic job.

Water heating coil description
Water heating coils are a type of heat exchanger often called hydronic coils that use hot water from a boiler to heat or remove moisture from the air. The air moves through the fins of the coil which is hot from water flowing through the tubes. This is a type of heat exchanger mostly used in commercial and industrial air handler units, roof top units as well as ductwork installations downstream.

gạch ốp lát
gạch ốp lát, thiết bị vệ sinh, cửa hàng nội thất
Text: Nội thất Tiến Khôi chuyên kinh doanh các mặt hàng gạch ốp lát, thiết bị vệ sinh, các loại mái ngói, thiết bị điện năng lượng Địa chỉ: 91 Đường Nguyễn Đệ, Phường An Hòa, Quận Ninh Kiều, TP Cần Thơ, SĐT: 0936565654, 0826565654, Website: noithattienkhoi.vn

Magnificent beat ! I would like to apprentice even as you amend
your web site, how can i subscribe for a weblog web site?
The account helped me a appropriate deal. I were a little bit familiar
of this your broadcast provided vivid clear concept

refrigerator coil cleaner
How does condenser coil works
While the evaporator coil picks up heat from indoor air, the condenser coil releases heat into outdoor air. The load of heat energy extracted from your home and compressed in hot refrigerant vapor is rapidly released when refrigerant circulates into the coil and condenses to liquid.

What’s the Difference Between A/C Condenser coil and Evaporator Coils?
Extracting indoor heat from the air and adding it to refrigerant is the function of the evaporator coil. Installed inside the indoor air handler, the evaporator is continuously exposed to the flow of warm air drawn by the system blower from individual rooms in the house through return ducts.

Refrigerant circulating through copper tubes in the coil is a cold vapor around 40 degrees. In this state, the heat-absorbent properties of the refrigerant are maximized. Heat energy from the warm house airflow transfers through the chilled copper coil tubing and is readily absorbed by the refrigerant flow. With its heat energy extracted by the coil, the cooled airflow is pushed by the blower into the supply ducts and dispersed throughout the house.

At the same time heat is being extracted, the warm air contacting frigid evaporator coil surfaces triggers condensation, which lowers the humidity level in the airflow, “conditioning” the air just as Willis Carrier designed over a century ago. After leaving the evaporator coil, refrigerant flows through an insulated conduit to the outdoor A/C component that’s usually directly behind the house.

This cabinet contains both the compressor and the condenser coil. Refrigerant entering the compressor is pressurized, concentrating the molecules of heat energy and raising the temperature of the refrigerant vapor to over 100 degrees. This superheated state ensures efficient transfer of the heat energy into outdoor air, even when the outdoor temperature is high, such as on a hot summer day.

The condenser coil is of similar design to the indoor evaporator coil. However, the difference between A/C evaporator and condenser coil is exactly reversed. While the evaporator coil picks up heat from indoor air, the condenser coil releases heat into outdoor air. The load of heat energy extracted from your home and compressed in hot refrigerant vapor is rapidly released when refrigerant circulates into the coil and condenses to liquid.
As the refrigerant releases its heat load, a fan incorporated in the unit blows air through the condenser coil passages and heat is dispersed into outdoor air. High-pressure liquid refrigerant leaving the condenser coil makes a u-turn and flows back to the evaporator coil. An expansion valve before the evaporator restricts the flow of refrigerant, forcing it through a narrow orifice and converting it back to a vaporized state, ready to absorb more heat energy from your home.

finned tube
Copper finned tubes manufacturing process
Pipe line——compressing or rolling——strip peeling——washing——pressure test——blast blowing——packaging. The cold machining process of fins provides excellent mechanical resistance , fins are strong and have strong resistance to atmospheric corrosion, etc. The pressure required to extrude the fin from the aluminum sleeve creates an excellent “pressure bond” between the two materials. In addition, the aluminum finned material completely surrounds the metal of the tube, so there is no risk of electrical corrosion at the fin root (between the tube and the fin). All of these advantages ensure the most stable performance over time of all other fin types.
Copper finned tube applications
Copper finned tubes products are widely used in petrochemical, power plant and power plant renovation, air conditioning and refrigeration, boilers, finned tube economizers and air preheaters.

U bend tube applications
In various bends, various bends are inevitably used, such as marine pipelines, automobile oil pipes and other pipelines. Compared with other types of elbows, the arc elbow has many advantages. First, all kinds of materials flow smoothly at the arc elbow, and the impact force on the pipe wall is small and uniform; secondly, the arc elbow itself has less stress concentration. Strong and high impact resistance;
With the rise of modern steel furniture, office chairs, beach chairs, luggage carts, shopping carts, children’s trolleys, cribs, computer tables, etc., several metal tubes form several bright lines, which are practical, convenient, safe and reliable ;
Air conditioning refrigeration pipes mainly include elbows, small U-shaped pipes, return elbows, etc.;
The bathroom industry now has more and more bends, faucets, towel racks and S-shaped accessories.
Motorcycles, automobiles, electric vehicles, bicycles and other vehicles, handlebars, bumpers, frames, etc.;
Fitness equipment, lighting, construction machinery and other industries.

L/LL/KL Finned Tube applications
Application: Mainly used in air coolers in petrochemical, electric power, paper making, tobacco, building heating and other industries, air heaters and air heaters in spray drying systems such as vegetable protein and starch in the food industry. Blast furnace and converter systems, power generation: condensate exhaust gas discharged from steam turbines, condensate contact cycle cooling condensation, fossil and nuclear power plants, air conditioners (Freon, ammonia, propane), waste incineration equipment, compressor coolers, etc.
We customized finned tube according to customer indivisual requirement, for more details about L/LL/KL finned tube please inquire us!

FasciaBlade will help you to reduce muscle pain by using NMES’s latest technology to reduce Muscle aches and pains, relax muscles to relieve stiffness, spasms, and fatigue, Restore damaged muscle tissue, Blood flow and circulation are increased and Enhances muscle growth

We will help you eliminate neck pain will be gone in 10 minutes a day with the Lumbar Hero! Reduce back and sciatic pain naturally, Having your own chiropractor at home, Postural imbalances are corrected, Relieve stress, anxiety, and tension, Relieve Muscle Stiffness , Relieve Sciatic Nerve Pain, Results In 2 Weeks and Correct Your Posture

thiết bị vệ sinh
gạch ốp lát, thiết bị vệ sinh, cửa hàng nội thất
Text: Nội thất Tiến Khôi chuyên kinh doanh các mặt hàng gạch ốp lát, thiết bị vệ sinh, các loại mái ngói, thiết bị điện năng lượng Địa chỉ: 91 Đường Nguyễn Đệ, Phường An Hòa, Quận Ninh Kiều, TP Cần Thơ, SĐT: 0936565654, 0826565654, Website: noithattienkhoi.vn

fin tube cover
Extruded finned tube applications
Extruded finned tubes are the main equipment for air coolers and are commonly used as heat exchangers in power plants (electric, nuclear, thermal and geothermal). Steam condensate system. Chemical and petrochemical industries. Food processing plants and refrigeration technology. Industry (steel mills, incinerators, gas compression facilities). Petrochemical, power plant and power plant renovation, air conditioning and refrigeration, boilers, finned tube economizers and air preheaters. Maximum working temperature is 280°C-300°C.

gạch ốp lát, thiết bị vệ sinh, cửa hàng nội thất
Text: Nội thất Tiến Khôi chuyên kinh doanh các mặt hàng gạch ốp lát, thiết bị vệ sinh, các loại mái ngói, thiết bị điện năng lượng Địa chỉ: 91 Đường Nguyễn Đệ, Phường An Hòa, Quận Ninh Kiều, TP Cần Thơ, SĐT: 0936565654, 0826565654, Website: noithattienkhoi.vn

Today, I went to the beachfront with my children. I found a sea shell and gave
it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear
and screamed. There was a hermit crab inside and it pinched her ear.
She never wants to go back! LoL I know this is completely off
topic but I had to tell someone!

รถตู้เช่าน่าน ให้บริการรถตู้นำเที่ยวพร้อมคนขับรถคู่ใจที่ให้บริการทุกท่าน กับบริการรถตู้เช่า ที่พร้อมพาลุย ตามที่ลูกค้าต้องการพร้อมคนขับรถคู่ใจที่พร้อมจะพาทุกท่านลุยทุกที่ โดยคนขับรถที่มีประสบการณ์เดินทางจากการขึ้นเขาลงห้วย ปลอดภัยหางห่วง โดยรถตู้เช่าน่านที่เราใช้ เป็นรถตู้เช่า VIP 10 ที่นั่ง พร้อมคนขับรถที่มีประสบการณ์มาอย่างนาน และทีมงานที่พร้อมจะพาทุกท่านท่อง ภายในรถตู้น่าน มีสิ่งอำนวยความสะดวกครบคัน ทั้งทีวีและน้ำดื่มสะอาดตลอดเวลาในการเดินทางเพื่อสร้างความเพลิดเพลินในการเดินทางกับลูกค้า ด้วยบริการคุณภาพที่พร้อมพาทุกท่านเดินทางไปกับทีมงานของเรา เพราะการเดินทางคือปัจจัยในการเดินทางและพาทุกท่านท่องเที่ยว ในราคารถตู้เช่าอยู่ที่ 1800 บาท ไม่รวมน้ำมัน เรายังมีทริปท่องเที่ยวมากมายในบริการรถตู้เช่าของเรา ไม่ว่าจะเป็นทริปท่องเที่ยวหลวงพระบาง และทริปต่างๆอีกมากมายหรือทริปท่องเที่ยว 3 คืน 4 วันกับทัวร์รถตู้น่าน ของเรา อยากเดินทางจากการเดินทางจากจังหวัดน่านไปยังจังหวัดเชียงใหม่ ก็ยังทำได้ หรือจะเดินทางไปเที่ยวทะเลโดยท่านสามารถติดต่อการบริการเช่ารถตู้ได้ในจังหวัดน่าน จะมีทีมงานพาทุกท่านเดินทางไปยังสถานที่ต่างๆในประเทศไทยหรือไปเที่ยวลาว หรือเดินทางไปยังประเทศพม่า ก็ได้ เพียงท่านที่มาจากจังหวัดน่านต้องการเดินทางไม่ว่าจะเป็นเดินทางเพื่อผักผ่อนหย่อนใจเดินทางเพื่อสัมนาติดต่อข้าราชการหรือสัมมนาไปด้วยเที่ยวไปด้วยติดต่อรถตู้เช่าน่านของเราครับ

Aw, this was an incredibly nice post. Spending some time
and actual effort to create a good article… but what can I say… I put things off a lot and don’t seem to get nearly anything done.

What’s Taking place i am new to this, I stumbled upon this I have discovered It positively useful and it has aided me out
loads. I’m hoping to give a contribution & help different
users like its helped me. Great job.

Having the right ammunition for your firearm is the key to any succesful hunting trip. Buy the ammunition you need at the price you want online with Honor Ammo shop. Fast delivery

Having the right ammunition for your firearm is the key to any succesful hunting trip. Buy the ammunition you need at the price you want online with Honor Ammo shop. Fast delivery

Having the right ammunition for your firearm is the key to any succesful hunting trip. Buy the ammunition you need at the price you want online with Honor Ammo shop. Fast delivery

Having the right ammunition for your firearm is the key to any succesful hunting trip. Buy the ammunition you need at the price you want online with Best Ammunitions store. Fast delivery

Having the right ammunition for your firearm is the key to any succesful hunting trip. Buy the ammunition you need at the price you want online with Honor Ammo shop. Fast delivery

BayVip
Cổng game dân gian hấp dẫn nhất Việt Nam đã ra mắt phiên bản mới nhất 2022.
Cổng truy cập ổn định nhất thuộc quyền quản lý của nhà phát hành game đổi thưởng BayVip Club. Tương thích cao với mọi thiết bị, đường truyền internet tốc độ nhanh nhất từ trước tới nay với hàng ngàn quà tặng dành cho thành viên.

Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services

We design and build all types of mobile businesses. From food trucks to coffee trailers and coffee trucks to bar trailers and custom campers to live in. We can help you take your business mobile with a custom food or drink trailer or custom food truck.

coffee truck
We design and build all types of mobile businesses. From food trucks to coffee trailers and coffee trucks to bar trailers and custom campers to live in. We can help you take your business mobile with a custom food or drink trailer or custom food truck.

cosmetic surgery Istanbul
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services

mobile business
We design and build all types of mobile businesses. From food trucks to coffee trailers and coffee trucks to bar trailers and custom campers to live in. We can help you take your business mobile with a custom food or drink trailer or custom food truck.

cosmetic surgery turkey
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services

cosmetic surgery turkey
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services.

The Most Special Moments In One’s Life
A wedding is one of the most special moments in one’s life. Now you can capture the moments and keep them alive for years with a wedding video. In order to make the best。, the most important thing is the selection of a wedding videographer. With large numbers of videographers in the market, it might be a bit confusing in selecting the best one. Here, you will come across some useful suggestions that will help you choose the best videographer for your special day. We are now introducing S+ studio from Taiwan in the Asia region. In Taiwan, traditional and romantic elements are all over in the weddings. S+ studio has unique ways to merge these two elements and creates a whole new wedding video.

cosmetic surgery Istanbul
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services

best cosmetic surgery turkey
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services.

카지노사이트
온라인 카지노 가입 상담 전문 컨설팅

온라인 카지노를 처음 접하신 분들은 카지노 게임 플레이를 즐기고 싶은데 어디서 어떻게 해야 되는지 많은 고민이 될 것 입니다. 고민의 종류로는 카지노 게임을 플레이 후 환급 처리에 관한 문제, 온라인 카지노는 어떠한 방식으로 이용하는지 대한 문제, 온라인 카지노를 이용 시 나에게 오는 피해는 없을지 많은 것을 생각하게 됩니다. 따라서 어떻게 해야 좋은 선택 인지를 많이 고민합니다. 본사와 상담 후 카지노 사이트 가입을 추천 드리고 있습니다.
온라인 카지노를 이용 함으로써 나에게 오는 악 영향은 없을지 왜 많은 사람들은 온라인 카지노를 플레이 하는지, 온라인 카지노를 믿을 수 있는지 모든 것을 본사에서 상담하여 드리고 있습니다.

본사에서 안내해드리는 카지노사이트 는 모두 100% 검증이 되었고 안전한 곳만을 안내하여 드리고 있습니다.

best cosmetic surgery turke
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services

WordPress

[…]we prefer to honor many other world-wide-web websites around the internet, even when they aren’t linked to us, by linking to them. Underneath are some webpages worth checking out[…]

온라인 카지노 가입 상담 전문 컨설팅

온라인 카지노를 처음 접하신 분들은 카지노 게임 플레이를 즐기고 싶은데 어디서 어떻게 해야 되는지 많은 고민이 될 것 입니다. 고민의 종류로는 카지노 게임을 플레이 후 환급 처리에 관한 문제, 온라인 카지노는 어떠한 방식으로 이용하는지 대한 문제, 온라인 카지노를 이용 시 나에게 오는 피해는 없을지 많은 것을 생각하게 됩니다. 따라서 어떻게 해야 좋은 선택 인지를 많이 고민합니다. 본사와 상담 후 카지노 사이트 가입을 추천 드리고 있습니다.
온라인 카지노를 이용 함으로써 나에게 오는 악 영향은 없을지 왜 많은 사람들은 온라인 카지노를 플레이 하는지, 온라인 카지노를 믿을 수 있는지 모든 것을 본사에서 상담하여 드리고 있습니다.

본사에서 안내해드리는 카지노사이트 는 모두 100% 검증이 되었고 안전한 곳만을 안내하여 드리고 있습니다.

Rajabet168 : Situs Slot 4D 303 Slot Gacor Hari Ini Terbaru

Rajabet168 adalah situs slot 4d terbaru yang terkemuka diantara 303 slot dengan memiliki beragam info slot gacor hari ini selalu 24 jam online non stop.Lebih dari 500 permainan slot 4d & mpo terbaik di Indonesia bisa kamu mainkan di sini.

Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services.

Slot 4d
Rajabet168 : Situs Slot 4D 303 Slot Gacor Hari Ini Terbaru

Rajabet168 adalah situs slot 4d terbaru yang terkemuka diantara 303 slot dengan memiliki beragam info slot gacor hari ini selalu 24 jam online non stop.Lebih dari 500 permainan slot 4d & mpo terbaik di Indonesia bisa kamu mainkan di sini.

cosmetic surgery Istanbul
Plastic, Reconstructive, and Aesthetic Surgery treat congenital and acquired aesthetic, shape, and functional disorders. Specialist plastic surgeons meet the requirements of the branch. Cosmetic surgery in Turkey includes plastic, Reconstructive, and Aesthetic Surgical operations.
if there’s anything else that you need you can write me.
thanks in advance for your services.

Hunting in South Africa
Are you ready for the best South Africa Hunting Safari?

I can honestly say that I have hunted all over this beautiful continent and people might differ from me but there is no other place in the world where you will be treated and hunt the amount of animals in a short period of time.

And I know there is a lot of debate on hunting in High Fenced areas but let me tell you something from one thing I’ve experience and still deal with every day. No matter if you hunt in Masai Land in Tanzania or in Luangwa Valley in Zambia of in Tsholotsho in Zimbabwe.

If you would like to know more about African Safari and Photo. We are excited to discuss a custom hunting package just for you.

If you are on a personal connection, like at home, you can run an anti-virus scan on your device to make sure it is not infected with malware. Juuri tämänkaltaisia kasinoita voit löytää yllä olevasta no deposit -kasinolistaltamme. Voittaa Rahaa Peliautomaateissa Online 2020 Monilla netticasinoilla on kutsubonuksen sijaan kaytossa jatkuva suosittelubonus, joka certains kaytannossa sama asia mutta pienemmilla eduilla. Suosittelija voi lahettaa ystavilleen netticasinon kautta viestin, jossa certains erityinen, henkilokohtainen linkki netticasinon rekisteroitymissivulle. Kun viestin saaja rekisteroityy casinon asiakkaaksi, saa suosittelija esimerkiksi bonusrahaa tai talletusbonuksen. https://luminosity-masks.com/profile/jdujarred542184/ Paketissa on monipuolinen valikoima välineitä, se sisältää 15 temppua, joihin kaikkiin on kuvalliset ja kirjalliset ohjeet. 5-vuotiaskin voi itse harjoitella temppuja. Tärkeintä on hallita muutama temppu hyvin! Mukana mm. taikuri Simo Aallon ensimmäinen temppu, taikakolikko. Simo sai kolikkotempun ollessaan itse 5-vuotias ja hänestä tuli ammattitaikuri. Harjoittele ja esiinny – jokeri, pokeri, box! Lisää tapahtuma kalenteriisi: Liikkuminen ja ulkoilu tapahtumataloraahe.fi Taikapelikortit, joilla pystyy tekemään kolme helposti opittavaa korttitemppua. Korttipakassa on 52 korttia sekä kolme jokeria. Pakkaus sisältää hyvät ohjeet. Pienen taikurin pelikortit, jotka johdattavat taikurin oppipojan korttitemppujen maailmaan. Tämä on kertamaksu, et sitoudu jatkuvaan tilaukseen.

카지노사이트
온라인 카지노 가입 상담 전문 컨설팅

온라인 카지노를 처음 접하신 분들은 카지노 게임 플레이를 즐기고 싶은데 어디서 어떻게 해야 되는지 많은 고민이 될 것 입니다. 고민의 종류로는 카지노 게임을 플레이 후 환급 처리에 관한 문제, 온라인 카지노는 어떠한 방식으로 이용하는지 대한 문제, 온라인 카지노를 이용 시 나에게 오는 피해는 없을지 많은 것을 생각하게 됩니다. 따라서 어떻게 해야 좋은 선택 인지를 많이 고민합니다. 본사와 상담 후 카지노 사이트 가입을 추천 드리고 있습니다.
온라인 카지노를 이용 함으로써 나에게 오는 악 영향은 없을지 왜 많은 사람들은 온라인 카지노를 플레이 하는지, 온라인 카지노를 믿을 수 있는지 모든 것을 본사에서 상담하여 드리고 있습니다.

Начинать полноправным членом клуба vavada tge com могут исключительно совершеннолетние игрок. Обычай строго соблюдает принципы ответственной зрелище и не допускает к ставкам несовершеннолетних. Посетителям предлагается перейти для официальный сайт ресурса, найти кнопку «Регистрация» и кликнуть на нее. Коль площадка заблокирована, клиенты могут воспользоваться актуальным зеркалом, которое дозволено найти через оператора технической поддержки. Чтобы останавливаться полноправным членом казино Vavada , в регистрационной анкете стоит вписать:

Контакты (адрес электронной почты сиречь номер телефона)
Придумать крепкий пароль. Разрешается пользоваться отзыв, сгенерированный системой
Выбрать одну из 8-ми валюту счета (доллар, тенге, рубль, гривна, евро, лира, другое)
Прежде чем делать профиль, игрокам нуждаться внимательно выучить пользовательское соглашение. Русскоязычная версия документа находится в нижней части главной страницы и доступна к просмотру в любое время. Когда игроку необходима консультация по-любому из пунктов правил пользовательского соглашения, он может обратиться к операторам технической поддержки после разъяснениями. Не стоит делать учетную запись, если игрок не согласен с каким-то из пунктов правил. Для сайте запрещены мультиаккаунты, использование персональных данных третьих лиц.