Observing the current data warehouse table, we always include the updated_at column of the main driving table. ![]() Implementation of the distribution key should help us to reduce the data scan when joining two tables provided if the joining is applied on the distribution key of the two tables and sort key should help us when we are filtering the data. We have implemented distribution key and sort key in our data warehouse. Implementing Sort Key : The sort key is a column or a combination of columns used to determine the order of data storage within each block on disk.Implementing Distribution Key : The distribution key, also known as the distribution column, is a column or set of columns that determines how data is distributed across the compute nodes in a Redshift cluster.From AWS documentation, there are several way to help optimizing the query, such as : We use the left join clause to combine the two pieces of data, since not all consultations ended with doctor prescription.īefore we optimized the query, this simple query took 4 sec runtime and 149,44 MB of total data scan. This information will be useful for the analytics team to analyze how many consultations have a prescription or not. ![]() Here is the sample from part of our ETL query before optimization.įrom the given query above, we want to fetch the consultation id and prescription time. One single SQL file could have multiple join conditions for transforming the results. In summary, a data scan in Redshift refers to the process of reading and processing data from one or more tables in the Redshift cluster to satisfy a query.įrom the above picture, we execute the sql file and read the data from Redshift Dimensional / Fact schema before ingested into the Presentation layer. If the query requires data from one or more tables, Redshift will need to perform a scan of the table(s) to locate the required data. When we execute a query in Redshift, the query planner will determine how to retrieve the data needed by the query. We are using Apache Airflow to run scheduled transformation SQL (ETL) and Redshift as our Data Warehouse.Īs the data grows, it will affect scanning time when ETL performs a query and also consume more CPU resources & Disk space from the instance that makes the instance pushing to the limit. ![]() Data transformation is a critical step in the data management process that involves converting raw data into a format that is ready for analysis or further processing. In Halodoc, we extract and transform millions of data points on our platform every day.
0 Comments
![]() Delete all whitespace in MySQL column names from a table 1. ![]() How to remove leading and trailing whitespace in a MySQL field 0. Ubiq makes it easy to visualize data in minutes, and monitor in real-time dashboards. To remove first and last space(s) of column : UPDATE table SET colname TRIM(colname). | id | int(11) | NO | PRI | NULL | auto_increment | Mysql> alter table orders3 drop column category_id So first you need to delete foreign key constraint and only then use MySQL DROP COLUMN mysql> alter table orders3 drop foreign key fk_cat mysql> alter table orders3 drop column category_id ĮRROR 1553 (HY000): Cannot drop index 'fk_cat': needed in a foreign key constraint If you try to delete it, you will get an error. In the above example, foreign key category_id in orders3 references primary key ID column from categories table. Mysql> create table categories(id int auto_increment primary key,name varchar(255)) īonus Read : How to Get Records Between 2 Dates in MySQL Let’s say you have the following tables mysql> create table orders3(id int auto_increment primary key,category_id int) If you try to directly DROP COLUMN with Foreign Key MySQL will throw an error. Here’s the MySQL DROP COLUMN statement to drop multiple columns from table in MySQL mysql> alter table ordersīonus Read : How to Get Records from Last 7 Days in MySQL Let’s say you want to drop multiple columns sale & category. | category | varchar(255) | YES | | NULL | |īonus Read : How to Get Records from Today in MySQL | Field | Type | Null | Key | Default | Extra | Let’s say you want to DROP COLUMN product_id mysql> alter table orders drop column product_id Let’s say you have the following table orders mysql> create table orders(order_date date, You can also drop column with Index but the index will become invalid after removal of column. You will need to manually update them to get them working again. When you remove a column from table, all stored procedures, views and triggers that refer to this column become invalid. If you want to drop multiple columns from table, mention them in separate DROP COLUMN clauses, in same statement. Also understand the effects on other MySQL Database. You can use only DROP, instead of using DROP COLUMN above. To delete a column from MySQL Table, use ALTER TABLE tablename DROP COLUMN columnname command. Then specify the column name in DROP COLUMN clause. In the above statement, you need to mention the table whose column you want to drop, in ALTER TABLE clause. Here’s the syntax of DROP COLUMN statement: ALTER TABLE table_name We will use MySQL DROP COLUMN query to remove existing columns from table. Here are the steps to drop column from table in MySQL. Here’s how to drop column from table in MySQL. ![]() You can easily do this using MySQL DROP COLUMN command. Sometimes you may need to delete column from database table in MySQL. ![]() Step 5: Install any parts removed to gain access. Repeat the same procedure on the other end of the AC line with care taken with the o-ring on this side as well. The AC line nut can now be installed and tightened on this end. Make sure the o-ring does not become pinched during assembly. It should go smoothly and be installed straight. ![]() Begin with one end and place it into the fitting. Lubricate the new o-ring before they are installed using an approved lubricant such as AC oil. If your AC line did not come equipped with a new o-ring, install it now. Others the o-ring must be purchased separately. Some new AC lines may come with o-rings installed. If you are unable to locate the old o-rings, make sure both fittings are clear before proceeding. If you do not see an o-ring, then it may still be in the other end of the fitting. Before the new line is installed, take a look at the old ac line. ![]() Repeat the procedure on the other end of the AC line and set the AC line aside. The AC line then is able to pull out of the fitting. In this style, the nut will be loosened and removed. The most common are the threaded block with an o-ring fitting on one end as shown above. There are a variety of different styles of line and each has its own method of removal. Put on your eye protection to ensure any refrigerant in the system does not get into your eyes when the line is disconnected.īegin by disconnecting the first end of the AC line to be replaced. ![]() Remove any parts needed to be able to work on the AC line. If this is the case, now will be the time to remove these parts. In some cases, components must be removed to gain access to the AC line. Note if the line is leaking and where it was leaking from if so. Make sure it matches the new line you have before any repairs begin. Locate both ends for the line that will be replaced. The gauges for the high and low side should both read at least zero before the process is completed. Follow the steps for the individual machine. Turn on the AC recovery machine and follow its prompts for the procedure for that machine If not already done, hook the recovery machine’s yellow line up to an approved recovery tank.ĭo not begin the process yet. The blue line will go to the low side port while the red line will attach to the high side port. Part 1 of 3: Recovery of the old refrigerant If you are not certified or do not have the the tools, then the recovery, vacuum, and recharging are best left to the professionals. Specialized machines are used when recovering refrigerant. Warning: The EPA requires individuals or professions that handle refrigerant to to have a Section 608 License or a universal refrigerant handler’s license.There are high and low pressure lines and the replacement procedure for either will be the same. This article only covers replacing the AC hose after it has been diagnosed as the cause of the air not blowing cold or a leak. Many different reasons can be the cause of why the AC system to not blow cold air. The AC lines can fail over time, though and can leak or fail internally requiring replacement. They connect all the pieces together and help to carry both gas and liquid refrigerant through the system. The AC lines are one of the most important components in the AC system. ![]() ALLERGY ALERT: May cause an allergic reaction in people sensitive to inhaled or ingested psyllium. As your body adjusts to increased fibre intake, you may experience changes in bowel habit or minor bloating. If you are taking a prescription medicine by mouth, take this product at least 2 hours before or 2 hours after the prescribed medicine to minimize any effect on drug absorption. Bulk fibre may affect how well other medicines work. If constipation persists beyond 7 days, consult a doctor. Do not take if you have difficulty in swallowing. If mixture thickens, add more water and stir. Taking this product without adequate fluid may cause it to swell and block your throat or oesophagus and may cause choking. If you experience chest pain, vomiting or difficulty in swallowing or breathing after taking this product, seek immediate medical attention. Before using this product, consult a doctor if you have a sudden change in bowel habits persisting for 2 weeks or have abdominal pain, nausea, vomiting, rectal bleeding or are considering it as part of a cholesterol-lowering program and if pregnant or nursing. In case of overdose, seek professional help or contact a Poison Information Centre immediately. Do not use in cases of medication induced constipation. Helps body's natural toxin removal process via cleansing effect.Įach 7g dose contains 3.4g of psyllium husk powder (2.4 grams of soluble fibre) Metamucil contains no chemical stimulants, Metamucil is gluten free.So start the day right with Metamucil and improve your health in 5 ways.It's a Multi-Health Fibre that provides 5 ways to energize your health & vitality: - Helps you feel lighter & more active - Helps your body's natural toxin removal process via cleansing effect - Cleanses your insides - Helps maintain healthy cholesterol levels - Helps maintain digestive health.If symptoms persist, see your healthcare professional. Always read the label, use only as directed. Consult a doctor if you are planning to take Metamucil as part of a cholesterol lowering program. Reductions in cholesterol levels may contribute to reducing the risk of heart disease. * Diets low in saturated fat and cholesterol that include 7 grams of soluble fibre from psyllium husk, as in Metamucil, may lower cholesterol levels. Helps relieve constipation and maintain regularity during pregnancy Helps maintain healthy cholesterol levels* Helps body's natural toxin removal process via cleansing effect The natural way to stay regular and support a healthy gut. Start your day with Metamucil Daily Fibre Supplement Natural Granualr mixed in 250ml of water - a delicious and convenient way to add essential fibre to your diet. Metamucil contains 100% natural psyllium husk, which is a great source of both soluble and insoluble fibre. Metamucil is the leading fibre supplement brand. Four great-tasting variants including Orange, Lemon Lime, Wild Berry and Natural ![]() Made by leading digestive health and wellness brand, Metamucil ![]() The natural way to stay regular and support a healthy gut Daily Multi-Health Fibre with 100% Natural Psyllium Go to the directory where the file was downloaded and extract its contents using an archive utility like 7-Zip.Download the ZIP package of the MediaTek Preloader USB VCOM drivers to your Windows PC.Method 1: Automatic & Direct Installation However, if you find that the automatic installation method doesn’t work and your particular MTK Android device is still not detected by the computer, then you can follow the second method that takes the manual approach for the installation. This is the easiest and recommended way to install MediaTek USB VCOM drivers on your PC. The first method follows an automatic and direct approach and lets you install the said drivers by simply using the setup wizard. The provided MediaTek USB drivers could be installed on any Windows 11, Windows 10, Windows 8.1/8, Windows 7, Windows Vista, and Windows XP PC using two different methods. ![]() Microsoft Windows 11, Windows 10, Windows 8.1/8, and Windows 7 Choose the driver package according to the installation method you prefer to use. Download MediaTek USB VCOM Driversīelow, you will find the links to download the latest MediaTek USB VCOM drivers for devices with MT65xx, MT67xx, and MT68xx chipsets. ![]() ![]() It can even help you install custom binaries like TWRP recovery, Magisk Root, and more.įurther, they also hold an important role when and if you need to transfer files to/from your Android device over MTP protocol, and also when operating with Android tools like ADB and Fastboot. This can allow you to flash the stock ROM for unbricking the device or upgrading the software on it. So, you would need to install the MediaTek USB VCOM drivers (or MediaTek Preloader Drivers) on your PC to be able to flash firmware files on any MTK Android device using the SP Flash Tool. The figure below explains how the Preloader on MediaTek-powered Android devices can communicate with the SP flash tool over USB (Courtesy of mcgrady_tracy at CSDN). The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is used to store the user consent for the cookies in the category "Other. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. How to turn on Low Power mode on your Mac.How to fix USB ports not working on Mac?.Best Zoom alternatives for iPhone and iPad.This will enhance your experience and even save time! In the rare case it did not, please consider reaching out to Zoom Support.Īlso, if you have trouble getting Zoom to work on your iPhone or iPad, we have some tested fixes for that as well.įinally, it would be perfect for taking a few minutes and learning about Zoom keyboard shortcuts for Mac. I believe the above steps helped you get Zoom working on your Mac again. Once this is done, restart your Mac and try using Zoom. ![]() For this, open System Preferences and click Security & Privacy. In some instances, turning off Firewall may help with the proper working of Zoom. Give it the necessary permissions when you make the first Zoom call. Finally, download and install Zoom again.Open Finder → Applications → and right-click .app. ![]() For this, click the app/process name and click the x at the top left. Now type Activity Monitor and open this app.įrom here, if you find apps hogging CPU power the most/unnecessarily, consider closing them. Press command + space bar to bring Spotlight Search. Close other apps consuming significant resources Zoom may not be able to access the camera or microphone if another app is using it. Quit other apps using Mac’s Camera and MicrophoneĪre you running other apps in the background (like Skype, Discord, FaceTime, etc.) using Mac’s camera, microphone, or recording the screen? If yes, please quit those apps. This lets you share your Mac’s screen during Zoom calls.Īfter giving the necessary permission, quit the Zoom app and reopen it.
![]() Most screws will only require 1/16″ or so to work, but you might need to go a little further on some. Pro Tip 1: If the screw extractor doesn’t bite, drill or bore out a little more of the head. Once that happens, just keep turning until your screw is safely out. The screw extractor will twist down until it grabs hold of the screw. If you’re using a drill in reverse, turn the screw extractor into the guide hole you’ve drilled. At this point, you can finally put the screw extractor to use. Step 5: Screw Itįor a tutorial on how to use a screw extractor, it feels like we took a long time to get to the actual screw extraction, doesn’t it? Well, here we are. Just compare each bit to the screw and choose the best size.Īs you can probably tell, we find double-ended screw extractor sets easier to use. The nice thing is that the double-ended bit already matches up with the proper extractor size, so there’s no guesswork. If you’re using a burnishing/extractor double-ended bit, you’ll need to kick your drill into reverse to use it properly. You also want to use a drill for this process as the mechsnism on an impact driver doesn’t deliver a smooth action. Don’t ruin the whole thing by rushing the process. If you’re stopping to remove a screw, then there’s some value in protecting your workpiece. Depending on the size of the screw extractor you plan to use, you probably only need to drill down about 1/8″ to 1/4″. ![]() Keeping your drill bit straight, drill down slowly into the screw. To make your life easier, add a little bit of thread cutting oil to the head of the screw. Next, find a drill bit that has a smaller diameter than the screw you need to remove. Pro Tip: If you’re working a bolt or plug out of an engine, mind those metal shards – you don’t want them falling into the engine block! Step 4: Drilling a Guide Hole If that’s the set you have, skip the punching and drilling step. Some screw extractors have a burnishing end that you can use to drill out the screw head directly. This will create an indentation in the very center of the screw that will help guide the drill bit. To do this, you align a punch to the center of the screw and hammer it down lightly. With a basic screw extractor, you may need to provide some space in the screw head for it to work. That means drilling or expanding a hole in that old screw. You may also want a pair of gloves if you’re concerned about metal shavings cutting you. You always want to protect your eyeballs from debris. Thread cutting oil and/or penetrating oilĭon those safety glasses, because your work could potentially send a few metal shards flying about.Drill bits (not needed if your extractor has a boring end).Drill (we do not recommend using an impact driver-too much torque and speed). ![]() You need a few tools depending on the type and size of fastener as well as the material you’re trying to remove it from: How to Use a Screw Extractor – Step by Step Step 1: Gather Some Needed Tools Makes sense, right?īasically, after punching or drilling into the top of your busted-up screw, you’ll use a screw extractor to bite down into the screw and twist it back out of whatever it was holding together. This helps it lock into and remove damaged screws. While brands vary, the most common design uses a tapered drill bit with reverse threading. The key to the screw extractor’s usefulness lies in its general design. How a Screw Extractor Removes Damaged Screws ![]() If you’re just starting out, or you find yourself apprenticing with a Pro, we can show you how to extract a screw as if you’ve been doing it for years. It will let you quickly remove those pesky worn and weathered fasteners with a minimal amount of frustration.Īny Pro from mechanics to woodworkers should keep a set of screw extractors close by. Keep a relatively inexpensive screw extractor on hand. Rounded out and stripped screws can throw a real wrench in your productivity, but they don’t have to bring your work to a grinding halt. Other times, however, you’ve simply got to get it out. Sometimes you can cut or bend off a fastener and it’s fine. Slowly keep turning the screw/bolt/plug out until it works free.Flip the bit around and use constant pressure in reverse (slooooooow speed) to drive in the extractor until it bites.Using your drill in reverse, slowly bore out the damaged head.Look for hardened steel-these bits need to be strong.Use a set with double-ended boring/screw extracting bits-they’re easier.How to Use a Screw Extractor – Step by Step.How a Screw Extractor Removes Damaged Screws. ![]() As a result, the Raja-Tama predominant waves associated with the sheath of desire of the deceased, move rapidly in a circular manner at the place of his death. When the vital energy (prān) leaves the physical body, sub-vital energies and other subtle putrefying gases are released into the environment, and the person gets confined to that place with the physical body becoming lifeless. Whenever there is a death in the family, why is an earthen lamp lit in the house and what should be its direction ? This prevents the subtle putrefying gases from spreading into the environment through the ears and nose, and the environment is purified too. Instead of cotton balls, a bunch of tulsī leaves is placed in the nostrils and ears of the dead body. Why is a bunch of tulsī leaves placed in the nostrils and ears of the dead body ? Hence this is treated as one of the prime rituals after death. Moreover, Gangājal and tulsī leaves help in retaining the purity of the inner sheaths of the deceased and in preventing entry of negative energies through the mouth. This brings about disintegration of putrefying waves released from the mouth into environment, thus keeping the environment pure. By pouring Gangājal and placing tulsī (basil) leaves in the mouth, Sattva waves from the Universe get attracted to these sāttvik objects placed in the mouth. Often, when the prān (vital energy) leaves the gross body, the mouth remains open, and through this open mouth, putrefying waves from the dead body spread into the environment. Why is Gangājal (water collected from the river Gangā) poured into the mouth of a deceased followed by placing tulsī (basil) leaves in the mouth ? Rituals after death Below are some very common questions and doubts raised about some of the Hindu Rituals after death 1. There's one downside: If you're a member of multiple library systems, you can only have one assigned as the store on the device at a time. Kobo takes this to the next level by making libraries into a native store on the device, so you can browse them just like you browse the Kobo store. With most public libraries, you can log onto their site using your PC and choose ebooks to send to your Kindle-that's fine. Kobo's public library support is also better than Amazon's. There's a bit of trouble with two-page spreads, though, which get shrunk too small to read you can zoom on them, but scrolling is quite slow. Grayscale rendering, overall, is pretty good. Akira, in PDF, had some ghosting issues with some page flips, especially because it uses heavily dark pages. (If your eyes aren't super-sharp, get a Kobo Forma.) I read a paperback of Yotsuba!& in EPUB, as well as Saga and The Wicked and the Divine in CBR, and they all loaded quickly and flipped pages well. The 7-inch screen is just big enough that standard small-format manga are quite readable, as long as you have sharp eyes the Kobo Clara HD, and all Kindles, are just a little too small. The Libra H2O makes quick work of EPUB, CBR, CBZ, and PDF format manga and comics. If you're into manga, you've found your device. It's better to go into Kobo knowing what you want to read already. Its store's front page has Recommended and Trending options, as well as searching by book name or category, but Amazon has mastered the art of shoving a ton of artifically intelligent suggestions at you. Kobo also isn't terribly good at marketing or discovery. ![]() Amazon also offers the free Kindle Lending Library and $10/month Kindle Unlimited services for heavy readers Kobo doesn't have any subscription services. Books published through Amazon's own imprints, of course, are only available on Amazon devices. But Amazon's bookstore has a lot more options. Mainstream books are generally available through Kobo's store, for reasonable retail prices. ![]() You can also drag and drop books into its 8GB of storage using a standard micro USB cable. There's no cellular option, unlike on Kindles. Like all Kobo ebook readers, the Libra H2O connects to the internet using 2.4GHz Wi-Fi. Entirely independent of the very murky legal issues, it's just cumbersome to do so, and I generally recommend smooth options over cumbersome ones.) (This is the part where people start talking about cracking Amazon's copy protection. They're great if you get books from anywhere other than Amazon, but not Amazon. They read MOBIs and PDFs natively, as well as HTML, RTF, various graphic formats, and CBR and CBZ, which are mostly used for comics. They read EPUBs, bought through Kobo or elsewhere. Kobo devices, on the other hand, read lots of different kinds of books. Most libraries also have a Kindle book selection. The freeware package Calibre can convert EPUB and other formats into Kindle books, but it can be a little kludgey. You can send PDFs to Kindles, but odd things often happen with the formatting. The Libra H2O doesn't have a speaker or play audio.Īmazon's Kindle devices read, primarily, Kindle books or MOBI format files. Inside is a 1,200mAh battery, which I found just fine for more than two full 250-300 page books. Kobo has an array of covers available for $25 to $39 that also function as stands. It's also reversible, so it can be used right- or left-handed. That makes the whole thing even more pleasant to hold than the Kindle Oasis. ![]() The buttons press easily, like the ones on the Kindle Oasis, not stiffly like the ones on the Barnes & Noble Nook GlowLight 3. One bezel is much larger than the others and angled, with physical page-turn buttons on it. Bluetooth® wireless headphones or speaker required.The 7-inch screen is the same 300ppi E Ink Carta display used by other high-end ebook readers, with a color-changing front light that goes from blue to yellow. TypeGenius: 13 different fonts and over 50 font stylesġ71 g Actual size and weight may vary by configuration and manufacturing process.ġ5 file formats supported natively (EPUB, EPUB3, FlePub, PDF, MOBI, JPEG, GIF, PNG, BMP, TIFF, TXT, HTML, RTF, CBZ, CBR) Kobo Audiobooks** **Audiobooks available only in select countries. IPX8 - up to 60 mins in 2 metres of waterĬomfortLight PRO – Adjustable brightness and colour temperature Weeks of battery life* *Dependent on individual usage. WiFi 802.11 ac/b/g/n (dual band), Bluetooth® wireless technology, and USB-C 6” HD E Ink Carta 1200 touchscreen 300 PPI, 1448 x 1072 resolution with Dark Mode ![]() Intel’s pricing for its graphics cards is ultimately going to boil down to what segment of the consumer market it plans to capitalize on it. Intel Xe prototype shroud design (Image credit: Future) Intel graphics cards price Intel has been talking up its Xe HPG card a lot more recently, though, so a very late 2021 release can't be entirely ruled out either. It's definitely possible that we can see them at CES 2022, however, with an actual release following soon after. Given the semiconductor shortages in 20, it's unlikely that we'll get an actual Intel Xe HPG card going on sale in 2021. This is typically done in the final stages after the design and prototyping is finished and the graphics cards are ready for large scale production. More recently, Intel has confirmed that Xe HPG gaming graphics cards, previously known by it's prototype codename "DG2," is being sampled to graphics card partners. It's not quite as robust as the offerings from AMD and Nvidia, but it indicates that Intel is pretty far along the road to releasing gaming-ready graphics cards sometime in the near future. On the other hand, Intel released a graphics tuning software and updated it recently with a video recording feature. It's unlikely that any of the renders we've seen so far will be the final design of any consumer-facing GPU. Team Blue kind of did the same thing at CES 2020, but this time clarified that these renders were for PCIe versions of the DG1 mobile chip that it would send to developers, so that they could code on the new hardware. But AMD did win a CES award this year for a different card, so picky players can still prioritize performance - and patience - over price.So, at GDC 2019, Intel showed off some renders of its future graphics cards. ![]() ![]() If the card doesn't perform well, that'll indeed be disappointing. And if crypto mining i s slowed, that's also good news because the practice uses so much energy and produces so much heat it's turned one lake into a hot tub. If gamers are able to get graphics cards that actually work, that's good news. To be fair, the publication says it's awaiting third-party reviews before making any final calls, but it may be that it's just difficult to make a card that's effective at gaming and bad at mining. This week, PC Game r published a headline declaring AMD's new graphics card as "worse on paper than AMD's $199 GPU from six years ago." The article compares the new model to a previous version with higher memory bandwidth, more shader cores, and more texture units. Graphics cards have been in short supply for months, although there may soon be a small respite following China's ban on most mining within its borders. That’s a really nice frame buffer size for the majority of AAA games, but it’s not particularly attractive if you’re doing blockchain type activities, or mining activities." Game On "And you can see that with the way that we configured the part. ![]() "We have really optimized this one to be gaming-first at that target market," Smith said in the interview. In an interview with PC World, Laura Smith, Radeon graphics CVP, sat down at a table full of tech journalists to explain. It's cheap, but does it work? A gamer-oriented new $199 graphics card was designed to be less desirable for cryptominers to reduce issues with scalpers and a lack of supply, but some reviewers are worried it won't be able to perform at, well, games.Ĭomputer hardware giant AMD showcased the new Radeon RX 5500 XT at this year's CES. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |