Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides...
2012-12-27
26 reads
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large...
2012-12-26
420 reads
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to go little deeper with Pig. Pig is a high-level...
2012-12-26
20 reads
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to...
2012-12-25
455 reads
In my previous blog I have given more insight on Big Data and now we will take a closer look at Hadoop.
Hadoop
Hadoop is a software framework that supports data-intensive...
2012-12-24
39 reads
In my previous blog I have given more insight on Big Data and now we will take a closer look at...
2012-12-24
446 reads
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools to capture, curate, manage, and process the data within...
2012-12-14
28 reads
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...
2012-12-14
455 reads
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now question is how we can configure SSIS to run...
2012-09-29
280 reads
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now...
2012-09-29
986 reads
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
When the schema of an object is changed, SQL Server wipes out the previous...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers