Share your voice Tags $999 Use promo code 19LABOR10 to get an unusually good deal on JBL’s interesting hybrid product — not quite headphones, and not quite a traditional speaker, but something you wear like neckphones to listen to music on the go. $155 at Google Express 7 TVs Speakers Mobile Accessories Cameras Laptops Automobiles Smart Speakers & Displays $520 at HP Formerly known as the Google Home Hub, Google’s Nest Hub packs a wealth of Google Assistant goodness into a 7-inch screen. At $59, this is within a buck of the best price we’ve seen. It lists for $129 and sells elsewhere in the $89-to-$99 range.This is one item of many available as part of eBay’s Labor Day Sale (which, at this writing, doesn’t specifically mention Labor Day, but that’s how it was pitched to us). Read DJI Osmo Action preview Boost Mobile Comments Android 10 (Android Q) Google Play Google,I’m shocked — shocked! — to learn that stores are turning Labor Day into an excuse to sell stuff. Wait — no, I’m not. As much as I respect the original intent of the holiday (which became official back in 1894), to most of us, it’s just a bonus day off — one that’s blissfully tacked onto a weekend. So, yeah, stores; go ahead, run your sales. I’m listening. Perhaps unsurprisingly, Labor Day doesn’t bring out bargains to compete with the likes of Black Friday (which will be here before you know it), but there are definitely some sales worth your time.For example:We’ve rounded up the best Labor Day mattress deals.We’ve also gathered the best Labor Day laptop deals at Best Buy.The 2019 Vizio P Series Quantum is back under $999.Be sure to check out Amazon’s roughly three dozen Labor Day deals on TVs and audio. Google Express is having a big sale as well, one that includes deals on game consoles, AirPods, iPhones, laptops and more.Below I’ve rounded up a handful of individual items I consider to be the cream of the crop, followed by a handy reference guide to other Labor Day sales. Keep in mind, of course, that products may sell out at any time, even if the sale itself is still running. Note that CNET may get a share of revenue from the sale of the products featured on this page. Turo is kind of like Uber meets Airbnb: You borrow someone’s car, but you do all the driving. I’ve used it many times and found it a great alternative to traditional car-rental services — in part because you get to choose exactly the vehicle you want (not just, say, “midsize”) and in part because you can often do pickup and dropoff right outside baggage claim.Between now and Sept. 1, the first 300 people to check out can get $30 off any Turo rental with promo code LDW30. Sarah Tew/CNET 1:33 $60 at Best Buy $299 at Amazon Free Echo Dot with an Insignia or Toshiba TV (save $50) Lenovo Smart Clock: $59.99 (save $20) The problem with most entry-level laptops: They come with mechanical hard drives. That makes for a mighty slow Windows experience. This Lenovo model features a 128GB solid-state drive, so it should be pretty quick to boot and load software, even with its basic processor. Plus, it has a DVD-burner! That’s not something you see in many modern laptops, especially at this price. See at Turo See it Sarah Tew/CNET Post a comment Chris Monroe/CNET Tidal 3-month family subscription: $5.99 (save $54) Preview • iPhone XS is the new $1,000 iPhone X Now playing: Watch this: JBL Soundgear wearable speaker: $90 (save $160) The Cheapskate $999 $59 at eBay Best laptops for college students: We’ve got an affordable laptop for every student. Best live TV streaming services: Ditch your cable company but keep the live channels and DVR. Google is apparently introducing a method for you to pay for Android apps in cash. Omar Marques/SOPA Images/LightRocket via Getty Images Google will soon let people literally part with their cash to pay for Android apps, a report said.The search giant will launch “pending transactions” to give you more payment options, according to TechCrunch.”This is a new class of delayed form of payment – like cash, bank transfer and direct debit,” Aurash Mahbod, the Director of Engineering responsible for the Play Store and Games on Google Play, told the site at Google’s I/O Developer conference on Wednesday. $999 Though not technically a Labor Day sale, it’s happening during Labor Day sale season — and it’s too good not to share. Nationwide Distributors, via Google Express, has just about the best AirPods deal we’ve seen (when you apply promo code ZBEDWZ at checkout). This is for the second-gen AirPods with the wireless charging case. Can’t imagine these will last long at this price, so if you’re interested, act fast. Read Google Home Hub review Other Labor Day sales you should check out Best Buy: In addition to some pretty solid MacBook deals that have been running for about a week already, Best Buy is offering up to 40% off major appliances like washers, dryers and stoves. There are also gift cards available with the purchase of select appliances. See it at Best BuyDell: Through Aug. 28, Dell is offering an extra 12% off various laptops, desktops and electronics. And check back starting Aug. 29 for a big batch of Labor Day doorbusters. See it at DellGlassesUSA: Aug. 29 – Sept. 3 only, you can save 65% on all frames with promo code labor65. See it at GlassesUSALenovo: The tech company is offering a large assortment of deals and doorbusters through Labor Day, with the promise of up to 56% off certain items — including, at this writing, the IdeaPad 730S laptop for $700 (save $300).See it at LenovoLensabl: Want to keep the frames you already love and paid for? Lensabl lets you mail them in for new lenses, based on your prescription. From now through Sept. 2 only, you can save 20% on the blue light-blocking lens option with promo code BLOCKBLUE. See it at LensablSears: Between now and Sept. 7, you can save up to 40% on appliances (plus an additional 10% if you shop online), up to 60% on mattresses, up to 50% on Craftsman products and more. The store is also offering some fairly hefty cashback bonuses. See it at SearsNote: This post was published previously and is continuously updated with new information.CNET’s Cheapskate scours the web for great deals on tech products and much more. For the latest deals and updates, follow the Cheapskate on Facebook and Twitter. Questions about the Cheapskate blog? Find the answers on our FAQ page, and find more great buys on the CNET Deals page. $261 at Daily Steals via Google Express $210 at Best Buy Rylo Android 10 beta’s best new tricks from Google I/O 2019 Turo The feature is geared towards emerging markets where credit cards aren’t as common, Mahbod noted. It apparently gives people a payment code that they can use to make their purchase in cash at a local store — they’ll get the app or in-app item and an emailed receipt within 10 minutes.However, TechCrunch mentions that getting your purchase can take up to 48 hours at times and refunds only come as Play Store credit, not cash.Google didn’t immediately respond to a request for further comment.First published at 5:04 a.m. PT.Updated at 5:23 a.m. PT: Adds more detail. Read the AirPods review Read Lenovo Smart Clock review Sarah Tew/CNET See It See at Amazon HP Laptop 15t Value: $520 (save $780) Apple iPhone XS Sprint 0 Read the Rylo camera preview Turo: Save $30 on any car rental CNET may get a commission from retail offers. All of the news out of Googles I/O keynote $90 at Daily Steals via Google Express Sarah Tew/CNET Mentioned Above Apple iPhone XS (64GB, space gray) $999 DJI Osmo Action camera: $261 (save $89) Tags Best Buy Google Nest Hub: $59 (save $70) 34 Photos $6 at Tidal See It Recently updated to include digital-photo-frame capabilities, the Lenovo Smart Clock brings Google Assistant goodness to your nightstand. It’s a little smaller than the Amazon Echo Show 5, but also a full $30 less (and tied with Prime Day pricing) during this Best Buy Labor Day sale. An Echo Dot makes a fine match for any Fire edition TV, because you can use the latter to say things like, “Alexa, turn on the TV.” Right now, the 24-inch Insignia Fire TV Edition starts at just $100, while the 32-inch Toshiba Fire TV Editions is on sale for $130. Just add any Fire TV Edition to your cart, then add a third-gen Echo Dot, and presto: The latter is free. Share your voice DJI’s answer to GoPro’s action cameras is rugged little model that’s shockproof, dustproof and waterproof down to 11 meters. It normally runs $350, but this deal drops it to $261 when you apply promo code 19LABOR10 at checkout. Apple AirPods with Wireless Charging Case: $155 (save $45) I thought this might be a mistake, but, no, the weirdly named HP Laptop 15t Value is indeed quite the value at this price. Specs include an Intel Core i7 processor, 12GB of RAM, a 256GB solid-state drive and a 15.6-inch display. However, I strongly recommend paying an extra $50 to upgrade that display to FHD (1,920×1,080), because you’re not likely to be happy with the native 1,366×768 resolution. Review • iPhone XS review, updated: A few luxury upgrades over the XR What’s cooler: A snapshot of a firework exploding in front of you, or full 360-degree video of all the fireworks and all the reactions to seeing them? Oooh, ahhh, indeed. At $250, the compact Rylo dual-lens camera is selling for its lowest price yet. And for an extra $50, you can get the bundle that includes the waterproof housing.This deal runs through Sept. 3; it usually costs $500. Rylo 5.8K 360 Video Camera: $250 (save $250) Internet Services Lenovo 130-15AST 15.6-inch laptop: $210 (save $90) Angela Lang/CNET See It Spotify and most other streaming services rely on compressed audio, which robs the listener of full fidelity. Enter Tidal, the only “major” service that delivers lossless audio — meaning at least on par with CD quality, if not better. Want to see (er, hear) the difference for yourself? Grab this excellent extended trial while you can. It’s just $6 for three months, and it’s good for up to six listeners. Amazon
Love to play water sports like surfing or bodyboarding? Beware, you may be three times more likely to swallow antibiotic-resistant Escherichia coli or E.coli bacteria in your guts, new research has revealed. Surfers were found to swallow ten times more sea water than sea swimmers, making them more vulnerable to E.coli bacteria.Regular surfers were also found four times as likely to harbour bacteria that contain mobile genes that make bacteria resistant to the antibiotic. Also Read – Add new books to your shelfThis is significant because the genes can be passed between bacteria – potentially spreading the ability to resist antibiotic treatment between bacteria, the researchers said. “Antimicrobial resistance has been globally recognised as one of the greatest health challenges of our time, and there is now an increasing focus on how resistance can be spread through our natural environments,” said Anne Leonard, from the University of Exeter. Scientists compared faecal samples from 300 surfers and non-surfers to assess whether the surfers’ guts contained E.coli bacteria that were able to grow in the presence of cefotaxime. Also Read – Over 2 hours screen time daily will make your kids impulsiveThe study, published in the journal Environment International, found that 13 of 143 (9 per cent) of surfers were colonised by these resistant bacteria, compared to just four of 130 (3 per cent) of non-surfers swabbed.A treatment with cefotaxime – a commonly used and clinically important antibiotic previously prescribed to kill off E.coli bacteria – showed that the bacteria has acquired genes that enable them to survive this treatment, the study showed.According to the 2016 O’Neill report commissioned by the UK government, antimicrobial resistant infections could kill one person every three seconds by the year 2050 if current trends continue.There is an urgent need to curb antibiotic-resistance or else we may be entering an era in which antibiotics are no longer effective to kill simple, and previously treatable, bacterial infections, warned the World Health Organization.
Two lanes were closed on the M6 motorway due to an accident in Staffordshire this morning. Inrix, the traffic data company, reported the lanes were blocked on the Northbound carriageway from J13 A449 (Stafford South) to J14 A5013 (Stafford North). Two cars were involved in the accident, with one in each of the closed lanes before they were moved onto the hard shoulder. The accident was first reported at around 9.30am today (Sunday November 4) – with the road reopening at around 10.10am. A Highways England spokesman said: “All 3 lanes now open after collision clearance work and treatment to clear fluids off the carriageway. Thanks for your patience if held.” Read MoreRevealed: One stretch of M6 saw 1,100 accidents in just two-and-a-half years10:21Highways England confirm road has reopenedA spokesman said:All 3 lanes now open after collision clearance work and treatment to clear fluids off the carriageway. Thanks for your patience if held..”10:17All lanes have reopened Queueing traffic but all lanes have been re-opened.Traffic was held until around 10:10 to move the vehicles to the hard shoulder. 10:04All traffic now heldWe’re now getting reports all traffic is being held to help emergency services clear debris.10:00Vehicles now being moved to hard shoulderThe vehicles are now being moved to the hard shoulder.09:55What we know so farPolice, Highways England and firefighters are at the scene of an accident on the M6 Northbound betwene J13 and J14Two lanes are blocked and traffic is moving slowly as a resultTwo cars are involved in the accident, which took place shortly before 9.30am.09:52Debris and surface water reportedInrix, the traffic data company, is now reporting these is debris as a result of the collision – as well as surface water.09:50Location of the accident (Image: Inrix)09:48Picture from the sceneHighways England have published this picture of the scene.The accident on the M6 this morning (Image: Highways England)
In today’s tutorial we will assist you to overcome the errors that arise while loading, deleting or updating large volumes of data using Teradata Utilities. This article is an excerpt from Teradata Cookbook co-authored by Abhinav Khandelwal and Rajsekhar Bhamidipati. This book provides recipes to simplify the daily tasks performed by database administrators (DBA) along with providing efficient data warehousing solutions in Teradata database system. Resolving FastLoad error 2652 When data is being loaded via FastLoad, a table lock is placed on the target table. This means that the table is unavailable for any other operation. A lock on a table is only released when FastLoad encounters the END LOADING command, which terminates phase 2, the so-called application phase. FastLoad may get terminated in phase 1 due to any of the following reasons: Load script results in failure (error code 8 or 12) Load script is aborted by admin or some other session FastLoad fails due to bad record or file Forgetting to add end loading statement in script If so, it keeps a lock on the table, which needs to be released manually. In this recipe, we will see the steps to release FastLoad locks. Getting ready Identify the table on which FastLoad is been ended prematurely and tables are in locked state. You need to have valid credentials for the Teradata Database. Execute the dummy FastLoad script from the same user or the user which has write access to the lock table. A user requires the following privileges/rights in order to execute the FastLoad: SELECT and INSERT (CREATE and DROP or DELETE) access to the target or loading table CREATE and DROP TABLE on error tables SELECT, INSERT, UPDATE, and DELETE are required privileges for the user PUBLIC on the restart log table (SYSADMIN.FASTLOG). There will be a row in the FASTLOG table for each FastLoad job that has not completed in the system. How to do it… Open a notepad and create the following script: .LOGON 127.0.0.1/dbc, dbc; /* Vaild system name and credentials toyour system */.DATABASE Database_Name; /* database under which locked table is */erorfiles errortable_name, uv_tablename /* same error table name asin script */begin loading locked_table; /* table which is getting 2652 error */.END LOADING; /* to end pahse 2 and release the lock */.LOGOFF; Save it as dummy_fl.txt. Open the windows Command Prompt and execute this using the FastLoad command, as shown in the following screenshot: This dummy script with no insert statement should release the lock on the target Table. Execute Select on the locked table to see if the lock is released on the table. How it works… As FastLoad is designed to work only on empty tables, it becomes necessary that the loading of the table finishes in one go. If the load script is errored out prematurely in phase 2, without encountering the END loading command, it leaves a lock on loading the table. Fastload locks can’t be released via the HUT utility, as there are no technical lock on the table. To execute FastLoad, the following are some requirements: Log table: FastLoad puts its progress information in the fastlog table. EMPTY TABLE: FastLoad needs the table to be empty before inserting rows into that table. TWO ERROR TABLES: FastLoad requires two error tables to be created; you just need to name them, and no ddl is required. The first error table records any translation or constraint violation error, whereas the second error table captures errors related to the duplication of values for Unique Primary Indexes (UPI). After the completion of FastLoad, you can analyze these error tables as to why the records got rejected. There’s more… If this does not fix the issue, you need to drop the target table and error tables associated with it. Before proceeding with dropping tables, check with the administrator to abort any FastLoad sessions associated with this table. Resolving MLOAD error 2571 MLOAD works in five phases, unlike FastLoad, which only works in two phases. MLOAD can fail in either phase three or four. Figure shows 5 stages of MLOAD. Preliminary: Basic setup. Syntax checking, establishing session with the Teradata Database, creation of error tables (two error tables per target table), and the creation of work tables and log tables are done in this phase. DML Transaction phase: Request is parse through PE and a step plan is generated. Steps and DML are then sent to AMP and stored in appropriate work tables for each target table. Input data sent will be stored in these work tables, which will be applied to the target table later on. Acquisition phase: Unsorted data is sent to AMP in blocks of 64K. Rows are hashed by PI and sent to appropriate AMPs. Utility places locks on target tables in preparation for the application phase to apply rows in target tables. Application phase: Changes are applied to target tables and NUSI subtables. Lock on table is held in this phase. Cleanup phase: If the error code of all the steps is 0, MLOAD successfully completes and releases all the locks on the specified table. This being the case, all empty error tables, worktables, and the log table are dropped. Getting ready Identify the table which is getting affected by error 2571. Make sure no host utility is running on this table and the load job is in a failed state for this table. How to do it… Check on viewpoint for any active utility job for this table. If you find any active job, let it complete. If there is a reason that you need to release the lock, first abort all the sessions of the host utility from viewpoint. Ask your administrator to do it. Execute the following command: RELEASE MLOAD ;> If you get a Not able to release MLOAD Lock error, execute the following Command: /* Release lock in application phase */RELEASE MLOAD in apply; Once the locks are released you need to drop all the associated error tables, the log table, and work tables with it. Re-execute MLOAD after correcting the error. How it works… The Mload utility places a lock in table headers to alert other utilities that a MultiLoad is in session for this table. They include: Acquisition lock: DML allows all DDL allows DROP only Application lock: DML allows SELECT with ACCESS only DDL allows DROP only There’s more… If the release lock statement still gives an error and does not release the lock on the table, you need to use SELECT with the ACCESS lock to copy the content of the locked table to a new one and drop the locked tables. If you start receiving the error 7446 Mload table %ID cannot be released because NUSI exists, you need to drop all the NUSI on the table and use ALTER Table to nonfallback to accomplish the task. Resolving failure 7547 This error is associated with the UPDATE statement, which could be SQL based or could be in MLOAD. Various times, while updating the set of rows in a table, the update fails on Failure 7547 Target row updated by multiple source rows. This error will happen when you update the target with multiple rows from the source. This means there are duplicated values present in the source tables. Getting ready Let’s create sample volatile tables and insert values into them. After that, we will execute the UPDATE command, which will fail to result in 7547: Create a TARGET TABLE with the following DDL and insert values into it: ** TARGET TABLE**create volatile table accounts(CUST_ID,CUST_NAME,Sal)with dataprimary index(cust_id)insert values (1,’will’,2000);insert values (2,’bekky’,2800);insert values (3,’himesh’,4000); Create a SOURCE TABLE with the following DDL and insert values into it: ** SOURCE TABLE**create volatile table Hr_payhike(CUST_ID,CUST_NAME,Sal_hike) with dataprimary index(cust_id)insert values (1,’will’,2030);insert values (1,’bekky’,3800);insert values (3,’himesh’,7000); Execute the MLOAD script. Following the snippet from the MLOAD script, only update part (which will fail): /* Snippet from MLOAD update */UPDATE ACCFROM ACCOUNTS ACC , Hr_payhike SUPDSET Sal= TUPD.Sal_hikeWHEREAcc.CUST_ID = SUPD.CUST_ID;Failure: Target row updated by multiple source rows How to do it… Check for duplicate values in the source table using the following: /*Check for duplicate values in source table*/SELECT cust_id,count(*)from Hr_payhikegroup by 1 order by 2 desc The output will be generated with CUST_ID =1 and has two values which are causing errors. The reason for this is that while updating the TARGET table, the optimizer won’t be able to understand from which row it should update the TARGET row. Who’s salary will be updated Will or Bekky? To resolve the error, execute the following update query: /* Update part of MLOAD */UPDATE ACCFROM ACCOUNTS ACC ,( SELECTCUST_ID,CUST_NAME,SAL_HIKEFROMHr_payhikeQUALIFY ROW_NUMBER() OVER (PARTITION BY CUST_ID ORDER BYCUST_NAME,SAL_HIKE DESC)=1) SUPDSET Sal= SUPD.Sal_hikeWHEREAcc.CUST_ID = SUPD.CUST_ID; Now, the update will run without error. How it works… Failure will happen when you update the target with multiple rows from the source. If you defined a primary index column for your target, and if those columns are in an update query condition, this error will occur. To further resolve this, you can delete the duplicate from the source table itself and execute the original update without any modification. But if the source data can’t be changed, then you need to change the update statement. To summarize, we have successfully learned how to overcome or prevent errors while using utilities for loading data into database. You could also check out the Teradata Cookbook for more than 100 recipes on enterprise data warehousing solutions. Read Next: 2018 is the year of graph databases. Here’s why. 6 reasons to choose MySQL 8 for designing database solutions Amazon Neptune, AWS’ cloud graph database, is now generally available