Big SQL - Hadoop, JDBC, ODBC

What is BIG SQL?
This question coming to every software professional. We all know what is SQL. SQL is a language is used to access data from RDBMS.

Big SQL- to provide ANSI SQL access to data across any system from Hadoop, via JDBC or ODBC - seamlessly whether that data exists in Hadoop or a relational data base. This means that developers familiar with the SQL programming language can access data in Hadoop without having to learn new languages or skills.

There are different types of queries in Bg SQL:

Point queries - These are queries that need to return very fast, like HBase queries, for example.  In these types of queries, you cannot use MapReduce

Big ad-hoc queries - In larger, more complex jobs MapReduce parallelism becomes very important to be able to break down these massive data sets.

Standards-compliant via JDBC -This is how most applications access databases and in this usage pattern, you can use the same to access your Hadoop-based data store.

Standards-compliant ODBC - For non-Java developers, this usage pattern allows you to access database with specific products or tooling that only use ODBC


 

Comments

Post a Comment

Popular posts from this blog

Top myths for NULL value in SQL Queries

Image
The below are some of the key points about nulls, and how to compare them. Just to make sure that you should know about what is NULL value. Interpretation is not exactly missing value. There could be many reasons why no value is present, e.g., value inappropriate. How to compare NULL to values In the below example the where condition just checks for TRUE condition. If not matches you will get UNKNOWN. Example: Table Name is: Sells bar beer price ======================= Joe's bar Bud NULL SELECT bar FROM Sells WHERE price < 2.00 OR price >= 2.00; ------------ ------------- UNKNOWN Conclusion Joe's Bar is not produced, even though the WHERE condition is correctly given. The reason is the price value is NULL. So, we should not compare NULL to values.
Read more