SQL-On-Hadoop: Hive - Part II
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
4,710 reads
MapReduce
Distributed Computing Principles and SQL-on-Hadoop Systems
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
2019-09-06 (first published: 2017-10-26)
5,390 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)
11,341 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,050 reads
RE: Query Analyzer and sysdepends
HELLO BRIAN,Not sure if this is the best way to add on a question to this topic, but could not find alternative... I just loaded a script with about 20 stored procedures. they were in alpha order rather than ordered by called procedures prior to the calling procedures. should I worry that I got this […]
2005-02-21
RE: Question of the Day for 17 Feb 2005
My mistake. I must have put it in their twice. Sometimes when you're doing this in advance, it gets confusing.
2005-02-17
Backup to network device failing
I am backing up from one server to another server across the network. This has been working for months. Then on Monday night netweork backups began failing with an error like this:Processed 829088 pages for database 'molert', file 'molert_data_1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 959 pages for database 'molert', file 'molert_log_1' on […]
2004-08-18
50 reads
qurey hangs with distributed transactions
If I write an insert directly to a linked server then it works. If I do exactly the same via a distributed transaction it hangs. The syntax is 100% correct including the xact_abort on I'm using sql2000 sp2 with a domain service account. I can't believe the answer is upgrade to sp3a. Any suggestions gratefully received.
2004-07-29
2 reads
RE: Permissions in sql server 2000 (URGENT)
HI robbac, yes, Users are under NT group.AppDev How use ddl_admin to create/alter/execute procedure/functions and not to create /alter table/constraints/indexes.Thanks,Sheilesh
2004-07-26
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers