Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Big SQL Overview
Transcript of Big SQL Overview
SQL is widely used in relational world - can make big data analysis accessible to masses
Existing SQL for Hadoop technologies have numerous limitations - data types, query syntax support, poor performance Native SQL technology for Hadoop and HBase - by inventors of SQL (IBM)
Comprehensive SQL support (ANSI SQL 92+), data types, etc.
Optimized for big data sets - high performance and low latency Full function OBDC & JDBC drivers: Prepared Statements, Cancel Support, Authentication, SSL
Access data from varied data sources - Hive tables, HBase, CSV files, JSON, etc.
Leverages Hive Catalogs ANSI SQL 92+ & standard SQL syntax
Supports variety of Joins, Nested Subqueries, Windowed Aggregates
Numerous datatypes including varchars, decimals
Lots of built-in functions; extend with macros, UDFs, UDTF, UDA Built for the open source Hadoop environment on top of Hive infrastructure
Designed for use with existing SQL Queries with little or no modifications
Use standards compliant (JDBC / ODBC) tools e.g. Cognos BI, Eclipse, SQuirreL
JSquish for command line interface Multi-threaded, Scalable - have multiple Big SQL servers in the Hadoop cluster
Optimizer can leverage MapReduce parallelism or direct access (local mode)
Run point queries with real-time response i.e. milliseconds No need to download or install anything
No-charge Cloud environment to test-drive and learn hands-on
Complete with Hadoop and Big SQL pre-installed and pre-configured
Sign-up for access:
http://BigSQL.IMDemoCloud.com Free course on Big Data University
Learn SQL access for Hadoop and HBASE
Includes Hive and Big SQL
Watch videos and perform hands-on exercises