Announcing the immediate availability of Big SQL v5.0.1 – maintenance release


Big SQL, a SQL engine on Hadoop, has been making strides with the fast-evolving open source ecosystem. The core capabilities of Big SQL focusses on federation, SQL compatibility, scalability, performance, and of course enterprise security, making it a desirable query engine to seek insights from disparate data sources including Hadoop.

We announced Big SQL v5.0 in July, 2017 following our partnership announcement with Hortonworks. Following that, we now announce the release of Big SQL v5.0.1 which focuses on  consumability  (support for – Zeppelin notebook, CentOS,  Sandbox and other enterprise capabilities).  It also includes an automated tool for migrations and upgrades. Here are the highlights of Big SQL v5.0.1 release: 

  • Introducing support on CentOS
    • Big SQL v5.0.1 will now be supported on CentOS v6.8 and v7.2 (x86-64)
  • Connect to Big SQL using Zeppelin (available in HDP)
    • You can now query and visualize data using Zeppelin by connecting to Big SQL. Using Big SQL, you can access data on disparate sources for efficient execution of the queries.
  • Tool for BigInsights customers to migrate to Hortonworks Data Platform (HDP) 2.6.2 and upgrade to Big SQL 5.0.1
    • An automated tool is available for BigInsights (IBM Open Platform) customers to migrate to the latest version of HDP
    • An automated tool is available for BigInsights (Big SQL v4.2 and v4.2.5) customers to upgrade to the latest version of Big SQL on HDP
  • Improved enterprise capabilities
    • Improved integration with Spark for every Big SQL worker when Elastic boost is enabled
    • Big SQL can now be managed by YARN in a Kerberized environment as well.
    • Improved memory handling/resource management
    • Enhanced performance and scalability for ORC file formats
    • Big SQL takes away the pain of renewing Kerberized tickets manually and now automatically renews when they expire
    • Some improvements in HA usability and resiliency
  • Enhanced SQL Compatibility
    • Support for BINARY and VARBINARY data types
    • Improved decimal division semantics providing a minimum scale of 6 for the result to better match Hive and Netezza
    • Support for INT2, INT4, INT8, FLOAT4 and FLOAT8 data types to improve compatibility with Netezza
  • Big SQL sandbox available now!
    • A quick and easy way to install and try out Big SQL (on HDP 2.6.2) is just a few clicks away. The Big SQL sandbox and tutorials are available at Big SQL marketplace

Technical documentation can be found in IBM Knowledge Center.

Big SQL 5.0.1 is available for download from Passport Advantage and Passport Advantage Express website. 

More information on Hortonworks Data Platform (HDP) 2.6.2: 

Join The Discussion

Your email address will not be published. Required fields are marked *