Strategy integrates with Spark SQL, leveraging the power of in-memory cluster computing to run analytics against Hadoop and other big data sources.
• Support for 11 Spark SQL datatypes
• Native support for Spark SQL views which provides flexibility to make changes to views rather than physical changes to underlying tables
• Better query performance by pushing down approximately 81% of all the analytical functions to the database
• Reduced number of SQL passes with optimized settings
• Allows users to query structured data as a distributed dataset, making it easy to run SQL queries along complex algorithms
• Provides standard connectivity mechanisms via ODBC or JDBC
• Compatible with existing and unmodified Hive queries and data
• Uses the same engine for both interactive and long queries, allowing for scaling up to large jobs
Click below to learn how to connect to Spark SQL
