What Happened to Hadoop?
For a time, it seemed that everyone wanted to build a Hadoop system. The world has changed, and that's not as popular an idea as it used to be. Today, Steve has a few thoughts.
2020-03-02
525 reads
Hadoop
2019-09-19
514 reads
2019-09-12
493 reads
SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,461 reads
SQL-On-Hadoop: Hive - Part I
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
12,447 reads
Getting ready for Hadoop
Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.
2015-11-23
6,358 reads
2015-10-20
4,003 reads
Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT
As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)
2016-12-02 (first published: 2015-08-06)
12,375 reads
A Beginners Look at Hadoop
Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.
2015-01-01 (first published: 2013-06-05)
24,112 reads
Blogs
Trace Flag 3625 Follow Up
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
How to Build Data Management for Unstructured Data
The post How to Build Data Management for Unstructured Data appeared first on Joyful...
Forums
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Why Would You Do That?
Comments posted to this topic are about the item Why Would You Do That?
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers