No Image

Amazon Athena – 10가지 성능 향상 팁

2017-05-26 KENNETH 0

Amazon Athena – 10가지 성능 향상 팁 Amazon Athena는 표준 SQL을 통해 Amazon S3에 저장된 데이터를 쉽게 분석 할 수 있는 대화식 쿼리 서비스입니다. Athena는 서버리스(Serverless) 서비스로서, 관리해야 할 분석 서버 인프라가 없으며, 실행 쿼리에 대해서만 비용을 지불하고, 사용 방법도 매우 쉽습니다. Amazon S3에 있는 데이터 파일을 지정하고, 이에 대한 스키마를 정의한 후, 표준 SQL을 사용하여 쿼리를 하기만 하면 됩니다. 이 블로그 게시물에서는 Athena의 SQL 쿼리 성능을 향상 시킬 수있는 10 가지 팁을 알려드립니다.  특정 쿼리를 튜닝하는 것과 관련된 측면에 중점을 두어 설명합니다. Amazon Athena는 Presto를 사용하여 SQL 쿼리를 실행하므로 Amazon EMR에서 Presto를 실행하는 경우에도 이 팁들이 유용할 수 있습니다. 이 글을 읽기 앞서 우선 여러분이 Parquet, ORC, 텍스트 파일, Avro, CSV, TSV 및 JSON과 같은 다양한 파일 형식에 대한 지식이 있다고 가정합니다. I. 스토리지 모범 사례 이 섹션에서는 Athena를 최대한 활용할 수 있도록 데이터를 구조화하는 방법에 대해 설명합니다. 데이터가 [ more… ]

This Week on Windows: The new Surface Pro, Movies & TV deals and more

2017-05-26 KENNETH 0

This Week on Windows: The new Surface Pro, Movies & TV deals and more We hope you enjoyed today’s episode of This Week on Windows! Head over here for our Windows 10 Tip on how to lower the blue light emitted from your PC with Night light, watch the season premiere of Casual with the Hulu app from the Windows Store, or keep reading to catch up on this week’s news. In case you missed it: <!– !function(a,b){"use strict";function c(){if(!e){e=!0;var a,c,d,f,g=-1!==navigator.appVersion.indexOf("MSIE 10"),h=!!navigator.userAgent.match(/Trident.*rv:11./),i=b.querySelectorAll("iframe.wp-embedded-content");for(c=0;c<i.length;c++){if(d=i,!d.getAttribute("data-secret"))f=Math.random().toString(36).substr(2,10),d.src+="#?secret="+f,d.setAttribute("data-secret",f);if(g||h)a=d.cloneNode(!0),a.removeAttribute("security"),d.parentNode.replaceChild(a,d)}}}var d=!1,e=!1;if(b.querySelector)if(a.addEventListener)d=!0;if(a.wp=a.wp||{},!a.wp.receiveEmbedMessage)if(a.wp.receiveEmbedMessage=function(c){var d=c.data;if(d.secret||d.message||d.value)if(!/[^a-zA-Z0-9]/.test(d.secret)){var e,f,g,h,i,j=b.querySelectorAll('iframe[data-secret="'+d.secret+'"]'),k=b.querySelectorAll('blockquote[data-secret="'+d.secret+'"]');for(e=0;e<k.length;e++)k[e].style.display="none";for(e=0;e1e3)g=1e3;else if(~~g<!]]> <!– !function(a,b){"use strict";function c(){if(!e){e=!0;var a,c,d,f,g=-1!==navigator.appVersion.indexOf("MSIE 10"),h=!!navigator.userAgent.match(/Trident.*rv:11./),i=b.querySelectorAll("iframe.wp-embedded-content");for(c=0;c<i.length;c++){if(d=i,!d.getAttribute("data-secret"))f=Math.random().toString(36).substr(2,10),d.src+="#?secret="+f,d.setAttribute("data-secret",f);if(g||h)a=d.cloneNode(!0),a.removeAttribute("security"),d.parentNode.replaceChild(a,d)}}}var d=!1,e=!1;if(b.querySelector)if(a.addEventListener)d=!0;if(a.wp=a.wp||{},!a.wp.receiveEmbedMessage)if(a.wp.receiveEmbedMessage=function(c){var d=c.data;if(d.secret||d.message||d.value)if(!/[^a-zA-Z0-9]/.test(d.secret)){var e,f,g,h,i,j=b.querySelectorAll('iframe[data-secret="'+d.secret+'"]'),k=b.querySelectorAll('blockquote[data-secret="'+d.secret+'"]');for(e=0;e<k.length;e++)k[e].style.display="none";for(e=0;e1e3)g=1e3;else if(~~g<!]]> Here’s what’s new in the Windows Store: Halo Wars 2 – Sergeant Johnson Pack – Buy for $5.99 He’s back! The newest leader for Halo Wars 2 is none other than Sergeant Johnson himself and this time he’s brought his “Green Machine” with him, [ more… ]

Accessibility improvements in EdgeHTML 15

2017-05-26 KENNETH 0

Accessibility improvements in EdgeHTML 15 In last year’s Windows 10 Anniversary Update, we introduced a new architecture for web accessibility, enabling a more accessible web with Microsoft Edge. With this dramatically improved foundation, we’ve been hard at work improving the experience even more in EdgeHTML 15 and the Windows 10 Creators Update. This post details the web platform accessibility improvements introduced with EdgeHTML 15 in the Windows 10 Creators Update. These improvements are made possible by our continued partnership with the developer ecosystem, assistive technology community, and standards bodies, which allowed us to identify and implement the most impactful changes to enable a more accessible user experience. The Windows 10 Creators Update introduces advanced support for UIA Text Pattern and improved support for web accessibility patterns, built on top of the accessible Web Platform core introduced in the Windows 10 [ more… ]

No Image

Computex 2017: Acer announces Spin 1 notebook and Nitro 5 gaming line with Windows 10

2017-05-26 KENNETH 0

Computex 2017: Acer announces Spin 1 notebook and Nitro 5 gaming line with Windows 10 Ahead of Computex, Acer announced new Windows 10 devices for gaming and productivity on-the-go with the new Nitro 5 notebook line for casual gamers and the lightweight Spin 1 for flexible computing and sleek design, all powered by Windows 10. Here’s a closer look at these devices: Acer debuts all-new Nitro 5 notebook line with Windows 10 for casual gaming First from the new Acer Nitro family, the Nitro 5 series with Windows 10 provides a balance of powerful features with a sharp and stylish design, as well as a variety of configurations that feature popular graphics and processors to provide a wide selection that meets different budgets and needs. With Windows 10, these devices also have your personal digital assistant, Cortana*, built-in, are equipped with [ more… ]

Introducing “Mixer”

2017-05-25 KENNETH 0

Introducing “Mixer” Today, we’re excited to announce a big evolution of the interactive live-streaming platform Beam, and reveal a new name for the service: Mixer. We’re also launching several exciting new features that will unlock a whole new world of possibilities for social streaming, as well as a big update for our mobile app. The name Mixer represents what we love most about the service: how it brings people together through the core experience fans know and love: the ability to not just watch streams, but to also interact with streamers and play together in near real-time. In other words, Mixer is livestreaming that’s actually LIVE, compared to the traditional 10 – 20 second latency on other platforms. What’s more, viewers can actively participate in what’s happening on screen instead of just watching from the sidelines. With Mixer, you can [ more… ]